Google Sheets Keyboard Shortcuts: The 40 Most Useful

By Gerard Fernandez · Updated · 3 min read

Keyboard shortcuts are the fastest way to work in Google Sheets. You don't need to learn them all: the ones below cover almost everything people do every day.

See every shortcut: Ctrl + /

Press Ctrl + / (⌘ + / on Mac) inside any spreadsheet to open the full list, with a search box.

Google Sheets Keyboard shortcuts dialog with a Search box, the Enable compatible spreadsheet shortcuts switch, and the Editing section listing F4, Ctrl+Shift+Y, Ctrl+C and Ctrl+X
Real test: the dialog that opens with Ctrl + /. We checked every Windows shortcut on this page against this list.

Moving and selecting

ActionWindowsMac
Jump to the edge of the dataCtrl + arrow⌘ + arrow
Select to the edge of the dataCtrl + Shift + arrow⌘ + Shift + arrow
Select allCtrl + A⌘ + A
Select the whole row / columnShift + Space / Ctrl + SpaceShift + Space / ⌘ + Space
Go to the first cell (A1)Ctrl + Home⌘ + Fn + ←
Next / previous tabCtrl + Shift + PgDn / PgUp⌘ + Shift + Fn + ↓ / ↑

Editing

ActionWindowsMac
Edit the active cellF2Enter
Fill down / fill rightCtrl + D / Ctrl + R⌘ + D / ⌘ + R
Paste values onlyCtrl + Shift + V⌘ + Shift + V
Find / Find and replaceCtrl + F / Ctrl + H⌘ + F / ⌘ + Shift + H
Insert today's date / timeCtrl + ; / Ctrl + Shift + ;⌘ + ; / ⌘ + Shift + ;
Line break inside a cell (while typing in it)Ctrl + Enter⌘ + Enter
Insert linkCtrl + K⌘ + K
Add a commentCtrl + Alt + M⌘ + Option + M

Formatting

ActionWindowsMac
Bold / italic / underlineCtrl + B / I / U⌘ + B / I / U
StrikethroughAlt + Shift + 5⌘ + Shift + X
Format as percentCtrl + Shift + 5⌘ + Shift + 5
Format as currencyCtrl + Shift + 4⌘ + Shift + 4
Clear formattingCtrl + \⌘ + \

Rows, columns and formulas

ActionWindowsMac
Hide rows / columnsCtrl + Alt + 9 / 0⌘ + Option + 9 / 0
Switch between relative and absolute referencesF4F4
Show all formulasCtrl + `⌘ + `
Turn a formula into ARRAYFORMULACtrl + Shift + Enter⌘ + Shift + Enter

More on F4 in absolute references.

We also pressed a handful of them in a test sheet on Windows: Ctrl + Shift + 5 turned 0.25 into 25.00%, Ctrl + Shift + 4 turned 1200 into $1,200.00, Ctrl + ; inserted today's date, and Ctrl + Enter while typing put "Line two" on a new line in the same cell. Ctrl + ` then showed the formula =A2*2 instead of its result.

Test cells: 25.00% formatted with Ctrl+Shift+5, $1,200.00 with Ctrl+Shift+4, a formula result of $2,400.00, and a cell with Line one and Line two on separate lines
Real test: the percent and currency formats, and the line break in A5 (the formula bar shows only the first line).

Frequently asked questions

A shortcut doesn't work. Why?

Your browser or an extension may use the same keys. Some shortcuts also differ on non-US keyboards. Search the Ctrl + / list for the version on your system.

Can I use my Excel shortcuts?

Many work already. Turn on Enable compatible spreadsheet shortcuts in the Ctrl + / dialog for more.