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

Joanne was amazing through our forever long process (or so it seemed). As first time home buyers, we had a really bad experience with another lender and Joanne blew us out of the water. She explained the step by step process and never hesitated to explain things further if we did not understand. She answered all our questions in a timely manner. Joanne was there even on weekends and late nights. My fiancé and I cannot thank Joanne enough for all she did for us! We definitely will recommend her to our friends! We also want to thank our laywer (who recommend Joanne to us!). They are a dynamic duo!!! If you think you want to work with Joanne do not hesitate, you will not be disappointed

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

518.982.0480 | Office
518.982.0483 | Fax

NMLS# 872824