Browse all keyboard shortcut cheat sheets

Google Sheets Keyboard Shortcuts (Web (2024)) — Complete Cheat Sheet

Google Sheets keyboard shortcuts for navigation, formulas, formatting, and data management. Crunch numbers faster without a mouse.

37 shortcuts across 4 categories · Web (Chrome · Firefox · Safari)

Google Sheets keyboard shortcuts let you navigate large datasets, enter formulas, format cells, and manage spreadsheet structure entirely from the keyboard. For teams working collaboratively in the browser, knowing Sheets shortcuts is just as important as knowing Excel shortcuts for desktop-based spreadsheet work.

Navigation

Action	Shortcut	Description
Move to Last Row with Data	`Ctrl` + `↓`	Jump to the last filled cell in a column
Move to First Row with Data	`Ctrl` + `↑`	Jump to the first filled cell in a column
Move to End of Row	`Ctrl` + `→`	Jump to the last filled cell in a row
Move to Beginning of Row	`Ctrl` + `←`	Jump to the first cell in a row
Go to Beginning of Sheet	`Ctrl` + `Home`	Jump to cell A1
Go to Last Cell with Data	`Ctrl` + `End`	Jump to the last cell containing data
Go to Cell	`Ctrl` + `G`	Open Go to Range dialog to navigate to a cell reference
Next Sheet Tab	`Ctrl` + `Shift` + `PgDn`	Switch to the next sheet in the workbook
Previous Sheet Tab	`Ctrl` + `Shift` + `PgUp`	Switch to the previous sheet in the workbook

Editing

Action	Shortcut	Description
Edit Active Cell	`F2`	Enter edit mode for the selected cell
Insert Row Above	`Ctrl` + `Alt` + `Shift` + `=`	Insert a new row above the selected row
Insert Column Left	`Ctrl` + `Alt` + `=`	Insert a column to the left of the selected column
Delete Row	`Ctrl` + `Alt` + `-`	Delete the entire selected row
Insert Today's Date	`Ctrl` + `;`	Insert the current date as a static value
Insert Current Time	`Ctrl` + `Shift` + `;`	Insert the current time as a static value
Fill Down	`Ctrl` + `D`	Fill the selected cells down with the top cell's content
Fill Right	`Ctrl` + `R`	Fill the selected cells right with the leftmost cell's content
Clear Cell Contents	`Delete`	Clear contents of selected cells without deleting the cell
Undo	`Ctrl` + `Z`	Undo the last action
Redo	`Ctrl` + `Y`	Redo the last undone action

Formulas & Data

Action	Shortcut	Description
Start Formula	`=`	Begin entering a formula in the active cell
AutoSum	`Alt` + `=`	Insert a SUM formula for the range above the cursor
Toggle Absolute Reference	`F4`	Cycle between $A$1, A$1, $A1, and A1 in formula
Evaluate Formula Part	`F9`	Preview the result of a selected formula portion
Show All Formulas	`Ctrl` + `	Toggle display of formulas instead of values
Open Named Ranges	`Ctrl` + `F3`	Open the Named ranges sidebar
Find & Replace	`Ctrl` + `H`	Open Find and Replace dialog
Open Sort Range	`Alt` + `D` + `S`	Open sort options for the selected range

Formatting

Action	Shortcut	Description
Bold	`Ctrl` + `B`	Toggle bold on selected cells
Italic	`Ctrl` + `I`	Toggle italic on selected cells
Underline	`Ctrl` + `U`	Toggle underline on selected cells
Strikethrough	`Alt` + `Shift` + `5`	Apply strikethrough to selected cells
Format as Currency	`Ctrl` + `Shift` + `4`	Apply currency format to selected cells
Format as Percentage	`Ctrl` + `Shift` + `5`	Apply percentage format to selected cells
Format as Date	`Ctrl` + `Shift` + `3`	Apply date format to selected cells
Add Border	`Alt` + `Shift` + `7`	Add an outer border to selected cells
Open Format Cells dialog	`Ctrl` + `1`	Open the full cell formatting dialog

Google Sheets Tips & Tricks

Ctrl+D and Ctrl+R fill faster than copying: Select a cell plus the cells below or to the right, then press Ctrl+D (down) or Ctrl+R (right). The formula or value from the first cell fills the entire selection — no clipboard needed.
F4 toggles absolute references while editing: Click inside a cell reference in the formula bar and press F4 to cycle through $A$1, A$1, $A1, and A1. No need to type dollar signs by hand — essential for building formulas that copy correctly.
Ctrl+` reveals all formulas at once: Press Ctrl+` (backtick, top-left of keyboard) to toggle formula view. Every cell shows its formula instead of its value — great for auditing a complex spreadsheet.

Frequently Asked Questions — Google Sheets

How do I quickly sum a column in Google Sheets?: Select the cell below the column of numbers and press Alt+= to insert a SUM formula automatically. Google Sheets will suggest the range to sum — press Enter to confirm.
What is the Google Sheets shortcut to enter the current date?: Press Ctrl+; (semicolon) to insert today's date as a static value in the selected cell. Press Ctrl+Shift+; to insert the current time. These values don't update — use =TODAY() or =NOW() for live values.
How do I toggle formula view in Google Sheets?: Press Ctrl+` (backtick, the key above Tab) to switch all cells from showing their values to showing their formulas. This makes it easy to audit a spreadsheet and spot errors.

How to Learn Google Sheets Keyboard Shortcuts

Google Sheets shares many keyboard shortcuts with Microsoft Excel, which is deliberate — Google designed the compatibility to ease the transition for users moving between platforms. The core navigation, selection, and formula shortcuts are nearly identical. Where Google Sheets differs is in its collaboration features and browser-specific behaviors. For teams doing real-time collaborative spreadsheet work, Sheets is often preferred over Excel's web version, and knowing its shortcuts — particularly Ctrl+/ to open the shortcut list and Ctrl+Shift+F to open the find and replace dialog — makes collaborative sessions significantly more efficient.

The Google Sheets shortcuts that most improve practical workflow are in the data entry and formatting categories. Ctrl+Shift+: enters the current time, Ctrl+; enters the current date — both useful for timestamping entries without manually typing. Ctrl+Shift+1 through 6 apply common number formats (number, time, date, currency, percentage, scientific notation) with a single keystroke, which dramatically speeds up formatting large datasets. For navigating large sheets with frozen headers, Ctrl+Home jumps to the first cell while Ctrl+End jumps to the last cell containing data. The F4 key in Google Sheets repeats the last action — a shortcut borrowed from Excel that's invaluable for applying the same formatting operation to many cells quickly.