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

Good morning!  Having a home with space is wonderful!  The kids and I are so happy and feeling much more comfortable and at ease.  We spent 2 days straight moving then began unpacking Saturday night.  After church yesterday we organized and unpacked some more and last night was cleaning.  We were able to begin our Monday morning routine with easy and comfort - I can't begin to express how truly grateful we are.  We are feeling blessed and know without a doubt that God's hand was with us from the beginning.  

Thank you so much for all you did.  You were an anchor for me and without your direction through this process I would have been lost. 

Sincerely, Julie, Clifton Park

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

518.982.0480 | Office
518.982.0483 | Fax

NMLS# 872824