Shortcuts, Tips and Tricks

This Advanced Excel Help page is dedicated to providing Excel shortcuts and Excel tips and tricks. Often times people think that using the mouse is the fastest way to navigate Excel; however, In many cases this is not true. On the other hand, mastering Excel’s keyboard shortcuts is a much more efficient way to navigate the program and to complete tasks such as copying and pasting or formatting data. Using the keyboard shortcuts will not only allow you to accomplish the task at hand faster, but you will impress those around you with your speed and skill. Bookmark this page to use as a quick reference sheet!

Excel Tips

By highlighting your formula, or parts of your formula, in the formula bar at the top of the screen and pressing F9 will show you the the formula’s result for the part you have highlighted.

Adding spaces in your formulas can make them easier to read and will not impact their result. Also, if you have an exceptionally long formula, press Alt + Enter in the formula bar to start a new line.

Excel Navigation Shortcuts

CTRL + Page Up / Page Down: This allows a user to navigate left and right in the worksheets within and Excel file.
CTRL + Tab: This allows a user to navigate from one open file to another open file within the Excel program.
ALT + Tab: This allows a user to cycle through open programs on the computer.

Excel Function Key Shortcuts

F1 – Help Menu
F2 – Edit formula text, press it again to insert cell references into a formula by moving around spreadsheet
F3 – Inserts a named cell or range into a formula
F4 –  Repeats last task; this is also the short cut key for toggling sbsolute and relative references
F5 – Go to a cell or named cell
F7 – Spell Check
F8 – Extend (works similar to holding down the shift key)
F9 – Calculate Workbook (Shift + F9 calculates only the current worksheet; Ctrl + Alt + Shift + F9 recalculates the entire workbook and forces external links to update)

Excel Control Key Shortcuts

Ctrl + A to Select All cells in the workbook (or all text in the formula bar)
Ctrl + B to Bold
Ctrl + C to Copy
Ctrl + D to Copy down formulas or values
Ctrl + F to find text
Ctrl + H to find and replace text
Ctrl + I to Italics
Ctrl + N to create New Workbook
Ctrl + O to Open a Workbook
Ctrl + P to Print
Ctrl + R to Copy formulas or values to the right
Ctrl + S to Save
Ctrl + U to Underline
Ctrl + V to Paste
Ctrl + W to close window
Ctrl + X to Cut
Ctrl + Y to Redo
Ctrl + Z to Undo
Ctrl + + / –  to add or to delete Rows, Columns or Cells
Ctrl + ` to Display formulas in all cells
Ctrl + 1 to open format cells window
Ctrl + Space to select entire column
Shift + Space to select entire row

Tip: Using Ctrl + Space or Shift + Space combined with Ctrl + +/- is an easy way to insert entire columns or rows into a spreadsheet

Excel Control + Shift Shortcuts for Formatting

Ctrl + Shift + 1 to format numbers with comma separator and two decimals
Ctrl + Shift + 2 to format numbers as date and time
Ctrl + Shift + 3 to format numbers as dates
Ctrl + Shift + 4 to format numbers with dollar sign, comma separator, and two decimals
Ctrl + Shift + 5 to format numbers as percentage
Ctrl + Shift + 6 to format numbers in exponential form
Ctrl + Shift + 7 to add outside borders to the selected cells

Excel Alt Key Shortcuts

Alt + F1 to add a new chart
Alt + F2 to save as
Alt + F4 closes the program
Alt + F8 opens the run macro dialogue box
Alt + F11 opens the VBA editor window

Tip: You can use Alt + a number to access the quick access tool bar at the top of the screen

Excel Shift Key Shortcuts

Shift + Enter moves the cursor up one cell
Shift + F2 inserts a comment
Shift + F3 opens the Insert Function Dialogue box
Shift + F4 moves the cursor right one cell
Shift + F5 opens the Find Dialogue box
Shift + F6 activates to Ribbon
Shift + F7 toggles the research pane
Shift + F9 calculates the current sheet only
Shift + F10 opens the same menu as right clicking the mouse
Shift + F11 inserts a new worksheet
Shift + F12 save as