Google Sheets keyboard shortcuts

Google Sheets is Google's free, browser-based spreadsheet app, used everywhere from quick budgets to shared team trackers. Because it lives in the browser, reaching for the mouse constantly breaks your flow; the keyboard shortcuts below cover navigation, formatting, and data entry so you can work at near-Excel speed without leaving the keys. This cheat sheet covers 61 default shortcuts for Windows and Mac.

General

Show keyboard shortcuts list	`Ctrl`+`/Cmd`+`/`
Search the menus	`Alt`+`/Option`+`/`
Undo	`Ctrl`+`ZCmd`+`Z`
Redo	`Ctrl`+`YCmd`+`Y`
Copy	`Ctrl`+`CCmd`+`C`
Cut	`Ctrl`+`XCmd`+`X`
Paste	`Ctrl`+`VCmd`+`V`
Paste values only	`Ctrl`+`Shift`+`VCmd`+`Shift`+`V`
Find	`Ctrl`+`FCmd`+`F`
Find and replace	`Ctrl`+`HCmd`+`Shift`+`H`
Print	`Ctrl`+`PCmd`+`P`
Select all	`Ctrl`+`ACmd`+`A`
Insert link	`Ctrl`+`KCmd`+`K`

Navigation

Move to edge of data region	`Ctrl`+`Arrow keysCmd`+`Arrow keys`
Move to beginning of row	`HomeFn`+`Left`
Move to end of row	`EndFn`+`Right`
Move to beginning of sheet	`Ctrl`+`HomeCmd`+`Fn`+`Left`
Move to end of sheet	`Ctrl`+`EndCmd`+`Fn`+`Right`
Go to next sheet	`Alt`+`DownOption`+`Down`
Go to previous sheet	`Alt`+`UpOption`+`Up`
Open hyperlink in selected cell	`Alt`+`EnterOption`+`Enter`

Selection

Select entire column	`Ctrl`+`SpaceCtrl`+`Space`
Select entire row	`Shift`+`SpaceShift`+`Space`
Extend selection by one cell	`Shift`+`Arrow keysShift`+`Arrow keys`
Extend selection to edge of data	`Ctrl`+`Shift`+`Arrow keysCmd`+`Shift`+`Arrow keys`

Editing

Edit the active cell	`F2F2`
Insert new line inside a cell	`Ctrl`+`EnterCmd`+`Enter`
Fill down	`Ctrl`+`DCmd`+`D`
Fill right	`Ctrl`+`RCmd`+`R`
Insert current date	`Ctrl`+`;Cmd`+`;`
Insert current time	`Ctrl`+`Shift`+`;Cmd`+`Shift`+`;`
Insert current date and time	`Ctrl`+`Alt`+`Shift`+`;Cmd`+`Option`+`Shift`+`;`
Insert comment	`Ctrl`+`Alt`+`MCmd`+`Option`+`M`
Insert note	`Shift`+`F2Shift`+`F2`

Formatting

Bold	`Ctrl`+`BCmd`+`B`
Italic	`Ctrl`+`ICmd`+`I`
Underline	`Ctrl`+`UCmd`+`U`
Strikethrough	`Alt`+`Shift`+`5Cmd`+`Shift`+`X`
Align left	`Ctrl`+`Shift`+`LCmd`+`Shift`+`L`
Align center	`Ctrl`+`Shift`+`ECmd`+`Shift`+`E`
Align right	`Ctrl`+`Shift`+`RCmd`+`Shift`+`R`
Clear formatting	`Ctrl`+`\Cmd`+`\`
Copy formatting	`Ctrl`+`Alt`+`CCmd`+`Option`+`C`
Paste formatting only	`Ctrl`+`Alt`+`VCmd`+`Option`+`V`
Apply outer border	`Alt`+`Shift`+`7Option`+`Shift`+`7`
Remove borders	`Alt`+`Shift`+`6Option`+`Shift`+`6`

Number Formats

Format as decimal	`Ctrl`+`Shift`+`1Ctrl`+`Shift`+`1`
Format as time	`Ctrl`+`Shift`+`2Ctrl`+`Shift`+`2`
Format as date	`Ctrl`+`Shift`+`3Ctrl`+`Shift`+`3`
Format as currency	`Ctrl`+`Shift`+`4Ctrl`+`Shift`+`4`
Format as percentage	`Ctrl`+`Shift`+`5Ctrl`+`Shift`+`5`
Format as exponent	`Ctrl`+`Shift`+`6Ctrl`+`Shift`+`6`

Rows & Columns

Hide selected row	`Ctrl`+`Alt`+`9Cmd`+`Option`+`9`
Unhide row	`Ctrl`+`Shift`+`9Cmd`+`Shift`+`9`
Hide selected column	`Ctrl`+`Alt`+`0Cmd`+`Option`+`0`
Unhide column	`Ctrl`+`Shift`+`0Cmd`+`Shift`+`0`
Group selected rows or columns	`Alt`+`Shift`+`RightOption`+`Shift`+`Right`
Ungroup rows or columns	`Alt`+`Shift`+`LeftOption`+`Shift`+`Left`

Formulas

Toggle absolute/relative references	`F4F4`
Show all formulas	`Ctrl`+``Cmd`+`
Enter as array formula	`Ctrl`+`Shift`+`EnterCmd`+`Shift`+`Enter`

Put your top Google Sheets shortcuts on real keys

The five Google Sheets actions most worth binding to a physical macropad key:

Ctrl+Shift+VCmd+Shift+V Paste values only The single most repeated paste-special action in any spreadsheet workflow.

Ctrl+;Cmd+; Insert current date Log-style sheets need a date stamp dozens of times a day.

Ctrl+Alt+MCmd+Option+M Insert comment One key to start a comment keeps review sessions moving.

Ctrl+HCmd+Shift+H Find and replace Awkward three-key chord on Mac; a dedicated key makes bulk cleanups instant.

F4F4 Toggle absolute/relative references Formula authors hit this constantly while locking cell references.

I hand-build small-batch programmable macropads (QMK/VIA) in Barcelona. One press, any shortcut, any app.

See the macropads

Google Sheets shortcut FAQs

How do I see all keyboard shortcuts in Google Sheets?

Press Ctrl+/ on Windows or Cmd+/ on Mac to open the built-in shortcut overlay, which lists every shortcut and lets you search them.

How do I paste values only in Google Sheets?

Press Ctrl+Shift+V (Cmd+Shift+V on Mac). It pastes the copied data without any formatting or formulas, which is the most common paste-special need.

Why do some Google Sheets shortcuts not work in my browser?

Because Sheets runs in the browser, a few combinations are intercepted by the browser or OS first. Using Chrome usually gives the best coverage, and the Ctrl+/ overlay shows the exact keys for your platform.

How do I insert the current date in Google Sheets with the keyboard?

Press Ctrl+; (Cmd+; on Mac) for the date, Ctrl+Shift+; for the time, and Ctrl+Alt+Shift+; for both date and time.

Can I use Excel shortcuts in Google Sheets?

Many overlap already, and Sheets also offers an option under Help > Keyboard shortcuts to enable compatible spreadsheet shortcuts, which maps more Excel-style combinations.