Microsoft Excel Tips and Shortcuts

Even if you're not a mathematical genius, you can use Microsoft Excel to keep track of just about anything. From managing your personal finances to budgeting and organizing projects, Excel can help you stay on top of it all.

Here are a few tips to making your spreadsheets as effective as possible—for newbies and experts:

Display Formulas - If the cell has a formula inside of it, entering Ctrl + ~ will toggle between the result and the formula.

COUNT - The COUNT and COUNTA formulas total up the number of cells containing numbers, or allow you to quickly find the sum of the numbers in a given set of cells, respectively.

AVERAGE - The AVERAGE function is used to find the average of values in a selected range of cells.

Excel Viewer - If you don't have Excel but still want to look at spreadsheets, just search Google for "Microsoft Excel Viewer" and view them absolutely free.

Keyboard Shortcuts - Finally, here are some helpful keyboard shortcuts using the Control "Ctrl" key (Mac Users: Substitute the "Control" (Ctrl) key with the "Command" key):

Ctrl + 2


Shift + Ctrl + F

Font dropdown list

Ctrl + Z

Undo action

Ctrl + 3


Ctrl + 9

Hide rows

Shift + Space

Select entire row

Ctrl + 4


Ctrl + 0

Hide columns

Ctrl + Space

Select entire column

Ctrl + 5


Ctrl + F

Find items

Ctrl + K

Insert hyperlink

"I wanted to personally take a few minutes to thank you for everything. Thir process has been a long and stressful one, but I SO appreciate your time and patience with both of us. I learned a lot from you and will keep your number because I found you to be precise, honest, and fair. Your closing estimate numbers were on the money (no pun intended!) and the final mortgage payment was right on as well. We even got credited $100 at closing! What a great experience with you and thank you! I will recommend your services, PERIOD!"

-LC, Albany 

646 Plank Road, Suite 102 Clifton Park, New York 12065

518.982.0480 | Office
518.982.0483 | Fax

NMLS# 872824