Excel Shortcuts You'll Definitely Want to Bookmark

These simple shortcuts can help you

• ➤Shift + Enter (PC and Mac) = Move up through a selection
  ➤CTRL + ↑ (PC); Command + ↑ (Mac) = Jump to the top of a column
  ➤CTRL + ↓ (PC); Command + ↓ (Mac) = Jump to the bottom of a column
  ➤CTRL + . (PC and Mac) = Jump to the corner of a selection (Note: Rotate to each corner by repeating this keystroke)
  ➤CTRL + w (PC); Command + W (Mac) = Close the active workbook window
  ➤CTRL + Shift + F6 (PC); Command + Shift + F6 (Mac) = Switch to previous workbook window
  ➤CTRL + Tab (Mac only) = Switch to the next open worksheet
  ➥CTRL + Shift + Tab (Mac only) = Switch to the previous open worksheet (Mac)
  F11 (PC and Mac) = Start a new chart sheet
  Shift + F11 (PC and Mac) = Insert a new sheet
  ➤CTRL + y (PC); Command + Y (Mac) = Repeat the last action
  ➤CTRL + d (PC and Mac) = Fill selected cell with the content in the cell above selected cell
  ➤CTRL + r (PC and Mac) = Fill selected cell with the content in the cell to the left of selected cell
  

  Formatting

  
  
  
  
  Formatting in Excel can be difficult if you don't know of what you're doing. Here are a few shortcuts that to help you easily format your cells. ➤CTRL + F (PC); Command + F (Mac) = Find and replace values
  ➤CTRL + Shift + % (PC and Mac) = Show all values as percentages
  ➤CTRL + Shift + $ (PC and Mac) = Show all values as currency (Note: Replace $ with your own country's currency key)
  ➤CTRL  + Shift + ~ (PC and Mac) = Show all values in general number format
  ➤CTRL + Shift + & (PC); Command + Option + 0 (Mac) = Apply an outline border to selected cells