Excel Keyboard Shortcuts — Full List & Interactive Guide

Jump to the farthest filled cell boundary in arrow direction

Tip: Use Up, Down, Left, or Right to leap across thousands of rows instantly.

Extend cell selection to edge of data region

Tip: The standard power shortcut for highlighting an entire column of data.

Jump to cell A1 (top-left origin of worksheet)

Switch to the next worksheet tab in the workbook

Switch to the previous worksheet tab in the workbook

Automatically insert SUM formula covering adjacent numbers

Tip: Select a block of numbers plus empty edge row/column and press once.

Cycle cell reference lock states ($A$1 -> A$1 -> $A1 -> A1)

Tip: Press repeatedly while editing a formula to lock row, column, or both.

Open the Insert Function dialog wizard

Toggle sheet view between calculated values and raw formulas

Tip: Essential for spreadsheet auditing and locating reference errors.

Insert current calendar date as a static timestamp

Insert current system time as a static timestamp

Open the full Format Cells dialogue box

Tip: Direct access to number formats, borders, fills, and alignment.

Apply standard Currency format ($#,##0.00) with two decimals

Apply Percentage format with zero decimal places

Apply standard Day-Month-Year date format

Reset cell formatting back to default General format

Convert highlighted range into an official Excel Table with filters

Tip: Adds zebra banding, auto-expanding rows, and structured column references.

Toggle auto-filter dropdown arrows on header row

Execute Flash Fill to automatically detect and extract patterns

Tip: Split names or reformat phone numbers without writing complex text formulas.

Copy value and formula from cell above down into selection

Copy value and formula from cell to the left into selection