Omega
Wisdom



Blending Life, Wealth, Work & What's Next
July 20, 2018

Excel Tips and Tricks

Knowing how to use some basic features of MS Excel can really enhance your spreadsheet experience. Once you have these down, you’ll be able to more easily navigate within your workbook!

Get more comfortable in Excel now, give these tricks a try!

Quickly Fit Columns and Rows to Show All Text.

Select the shaded triangle in the left hand corner of your sheet - where the rows and columns meet. This highlights the entire workbook. (Alternately, you can just select the rows and/or columns for which you'd like to adjust the sizing.)

Double click on the line between a row or column (or both, one at a time!). This will automatically adjust the size of the row or column to show all text. 

Format Information as a Table.

When you’re working with a matrix of numbers or columns and rows with text information, it can be easy to move one item and leave behind its related data. Formatting as a table allows you to clearly identify items within a row by alternating colors, filter content based on headers, and sort content without accidentally disorganizing it. 

To format as a table, first select the area you'd like to turn into a table. Ideally, this should have rows, columns, and a row with "Headers" which identify the content in the rows below. 

Then, with the selection still highlighted, click "Format as Table" from the ribbon at the top, and choose the color/style from the list available.

Once formatted, it should look like this (but with your own color and style showing!): 

You can click on the dropdown arrows next to your Headers to do things such as: choose specific rows to view, sort numerically or alphabetically, and more!

Already have the basics down?

Check out this video from Seven Second Riddles to learn how to use some hot-keys and cut out unnecessary typing to save even more time working within your spreadsheet!

 

 

Comments

CONNECT WITH US

Want to know more?

Omega Wealth Management serves as a “lifeline” to help you successfully navigate major life changes. Our comprehensive and flexible process is designed to meet you where you are and help you get to where you want to go, at your own pace.

 

CONTACT US

200 North Glebe Road, Suite 730
Arlington, VA 22203

Phone: (703) 387-0919 | Fax: 703-387-0918
Email Us