10 Excel Keyboard Shortcuts Everyone Should Know

10 Excel Keyboard Shortcuts Everyone Should Know

By Marie McCooey

My Excel classes love learning new keyboard shortcuts. They are amazed at how much time they save when they use them.

Here are 10 of the most popular Excel shortcuts you’ll want to add to your repertoire.

Quickly select an entire worksheet

  1. Press CTRL + A to highlight the entire worksheet

Excel Keyboard Shortcut 1

Insert today’s date and current time without formulas

  1. Today’s date – CTRL + ;
  2. Current time – CTRL + :

Excel Keyboard Shortcut 2 & 3

Apply Currency format to values instantly

  1. Highlight the cells and press CTRL + SHIFT + $

Excel Keyboard Shortcut 4

Quick access to Excel’s formatting options

  1. Press CTRL+1 to display Format Cells

Excel Keyboard Shortcut 5

Sum a range of cells without writing a formula

  1. Press ALT + = to sum a range of cells above or to the left

Excel Keyboard Shortcut 6Change cell references from Relative to Absolute in a flash

  1. Press F4 to fix a cell address so it doesn’t adjust when you copy the formula (Absolute), D2 changes to $D$2

Note: Press F4 again to freeze only the row with D$2. Press F4 again to freeze the column with $D2. Press again to toggle back to D2.

Excel Keyboard Shortcut 7

Move to Next and Previous worksheet tabs

  1. CTRL + PG DN – move to the worksheet tab on the right
  2. CTRL + PG UP – move to the worksheet tab on the left

Excel Keyboard Shortcut 8 & 9

Create a chart instantly

  1. Press ALT + F1 to chart your data on the current worksheet

Excel Keyboard Shortcut 10

Bonus – Create a chart on a new worksheet

Press F11 to chart your data on a new sheet

Excel Keyboard Shortcut Bonus