Printable Excel Cheat Sheet Pdf

Girl, I just found the holy grail of Excel shortcuts! You know I’ve been struggling with spreadsheets at work, but no more. This Excel Cheat Sheet cheat sheet has all the keyboard shortcuts you need to make your life easier.

Excel Keyboard Shortcuts

First things first, did you know that the “control” key (Ctrl) is your best friend in Excel?

  • Ctrl + C: Copy selected cells
  • Ctrl + V: Paste copied cells
  • Ctrl + Z: Undo last action
  • Ctrl + Y: Redo last action
  • Ctrl + Shift + $: Apply currency formatting to selected cells
  • Ctrl + Shift + %: Apply percentage formatting to selected cells
  • Ctrl + 1: Open Format Cells dialog box
  • Ctrl + Space: Select entire column
  • Shift + Space: Select entire row
  • Ctrl + Shift + L: Turn filter on/off for selected cells

Hitting the Function Keys

Another thing you need to know is how to use the function keys in Excel.

  • F2: Edit the selected cell
  • F4: Repeat the last action
  • F7: Spell check selected cells
  • F11: Create a chart of selected cells

Finally, you need to know how to navigate around Excel without driving yourself crazy.

  • Ctrl + F: Find something in your spreadsheet
  • Ctrl + G: Go to a specific cell
  • Ctrl + Home: Go to the beginning of your spreadsheet
  • Ctrl + End: Go to the end of your spreadsheet
  • Tab: Move right one cell
  • Shift + Tab: Move left one cell
  • Enter: Move down one cell
  • Shift + Enter: Move up one cell

There you have it, ladies! The ultimate Excel cheat sheet. Keep it handy and watch your Excel skills soar.