Automatically SUM()
with ALT + =
Quickly add an entire column or row by clicking in the first empty cell in the column. Then enter
ALT + '=' (equals key) to add up the numbers
in every cell above.
Display Formulas with
CTRL + `
When you're troubleshooting first look at the
formulas. Display the formula used in a cell by hitting just two keys: Ctrl + `(known as the accent key) - this key is furthest to the left on the row with the number keys. When shifted it is the tilde (~).
Add or Delete Columns Keyboard Shortcut
Managing columns and rows in your spreadsheet is an all-day task. Whether adding or deleting, you can save a little time when you use this keyboard shortcut. CTRL + '-' (minus key) will delete the column your cursor is in and CTRL + SHIFT + '=' (equal key) will add a new column. From an earlier tip, think about CTRL + '+' (plus sign).
Adjust Width of One or Multiple Columns
It's easy to adjust a column to the width of its content and get rid of those useless ##### entries. Click on the column's header, move your cursor to the right side of the header and double click when it turns into a plus sign.
Double Click Format Painter
Format Painter is a great tool which lets you duplicate a format in other cells with no more effort than a mouse click. Many Excel users (Outlook, Word and PowerPoint too) use this handy feature, but did you know you can double-click Format Painter to copy the format into multiple cells? It's quite a time-saver.
Copy a Pattern of Numbers or Even Dates
Another amazing feature built into Excel is its ability to recognize a pattern in your data, and allow you to automatically copy it to other cells. Simply enter information in two rows which establish the pattern, highlight those rows and drag down for as many cells as you want to populate. This works with numbers, days of the week or months!
_____________