JcHub
Cheat sheetFree, no sign-upPDF

Excel Shortcuts Cheat Sheet

A practical cheat sheet of essential keyboard shortcuts to navigate, calculate, and format data faster in Excel.

Updated on November 5, 2026

Quick Navigation

  • Ctrl + Arrow keysJumps to the last non-empty cell in that direction. Trap: stops early if an empty cell interrupts data.
  • Ctrl + HomeInstantly returns to cell A1, no matter how far down or across you navigated.
  • Ctrl + EndJumps to the last used cell on the sheet, even if its content was recently cleared.
  • Ctrl + Page DownSwitches to the next worksheet in your workbook without using the mouse.
  • F5 or Ctrl + GOpens the Go To dialog to jump directly to a specific cell reference or named range.

Selection and Entry

  • Ctrl + Shift + Arrow keysExtends cell selection to the last non-empty cell in the chosen direction.
  • Ctrl + ASelects the current active table, or the entire worksheet if pressed a second time.
  • Ctrl + DCopies and pastes the formula or value from the cell directly above.
  • Ctrl + RCopies and pastes the formula or value from the cell directly to the left.
  • Ctrl + EnterFills all currently selected cells with the active formula or text entry at once.

Formulas and Numbers

  • Alt + =Automatically inserts an AutoSum formula for the adjacent row or column.
  • F4Cycles cell references between absolute ($A$1), relative, and mixed modes while editing.
  • Ctrl + Shift + $Applies the standard currency format with two decimal places to selected figures.
  • Ctrl + Shift + %Applies the percentage format with no decimal places to selected values.
  • Ctrl + ;Inserts today's static date without setting an auto-updating formula.

Rows, Columns, and Tables

  • Shift + SpaceSelects the entire row of the active cell without moving your pointer.
  • Ctrl + SpaceSelects the entire column without needing to click the letter header.
  • Ctrl + TConverts the selected data range into a structured Excel table with auto-filters.
  • Ctrl + Shift + +Inserts new blank cells, rows, or columns based on your current selection.
  • Ctrl + -Deletes the currently selected cells, rows, or columns immediately.

Workbook and Display

  • F12Opens Save As to export your file. To share it cleanly as raw data, use our Excel to CSV tool.
  • Ctrl + Shift + LToggles automatic column filters on or off across your active table header.
  • Ctrl + 1Opens the Format Cells dialog to customize borders, alignments, and custom formats.
  • Alt + F1Instantly creates an embedded default chart from your currently selected dataset.

Other resources

Need help with your website?

I build your custom website.

Showcase site, online shop, management tool: let’s talk about your project.

See the services