Programs · 57 shortcuts

Google Sheets keyboard shortcuts

Google Sheets borrows many of its shortcuts from Excel, so the two feel alike. Because Sheets runs in a browser, a few combinations are different, and some need a setting switched on. The first column is for Windows and Chromebooks, the second for the Mac.

Find a shortcut on this page

The ten to learn first

Ctrl + / shows every shortcut. The same panel has a switch for "compatible spreadsheet shortcuts", which makes more of Excel's keys work.
Ctrl + Arrow key jumps to the edge of the data.
Ctrl + Shift + Arrow key selects to the edge of the data.
Ctrl + Space selects the column and Shift + Space the row.
F2 or Enter edits the cell.
F4 cycles the dollar signs on a reference while editing.
Ctrl + Enter fills the selected range with what you typed.
Ctrl + Shift + V pastes values only.
Ctrl + ; inserts today's date.
Ctrl + Shift + Enter wraps a formula in ARRAYFORMULA.

Windows	Mac	What it does
`Ctrl` + `Arrow key`	`Cmd` + `Arrow key`	Jump to the edge of the data
`Ctrl` + `Shift` + `Arrow key`	`Cmd` + `Shift` + `Arrow key`	Extend the selection to the edge of the data
`Home`	`Fn` + `Left arrow`	Go to the start of the row
`Ctrl` + `Home`	`Cmd` + `Fn` + `Left arrow`	Go to the start of the sheet
`Ctrl` + `End`	`Cmd` + `Fn` + `Right arrow`	Go to the end of the sheet
`Ctrl` + `A`	`Cmd` + `A`	Select everything
`Ctrl` + `Space`	`Ctrl` + `Space`	Select the column
`Shift` + `Space`	`Shift` + `Space`	Select the row
`Alt` + `Down arrow`	`Option` + `Down arrow`	Go to the next sheet
`Alt` + `Up arrow`	`Option` + `Up arrow`	Go to the previous sheet
`Ctrl` + `F`	`Cmd` + `F`	Find
`Ctrl` + `H`	`Cmd` + `Shift` + `H`	Find and replace
`Ctrl` + `/`	`Cmd` + `/`	Show the keyboard shortcuts
`Alt` + `/`	`Option` + `/`	Search the menus

Windows	Mac	What it does
`F2` or `Enter`	`F2` or `Return`	Edit the active cell
`Esc`	`Esc`	Cancel the entry
`Alt` + `Enter`	`Option` + `Return`	Start a new line inside the cell
`Ctrl` + `Enter`	`Cmd` + `Return`	Fill the selected range with the entry
`Ctrl` + `D`	`Cmd` + `D`	Fill down
`Ctrl` + `R`	`Cmd` + `R`	Fill right
`Ctrl` + `;`	`Cmd` + `;`	Insert today's date
`Ctrl` + `Shift` + `;`	`Cmd` + `Shift` + `;`	Insert the current time
`Ctrl` + `C`, `Ctrl` + `X`, `Ctrl` + `V`	`Cmd` + `C`, `Cmd` + `X`, `Cmd` + `V`	Copy, cut, paste
`Ctrl` + `Shift` + `V`	`Cmd` + `Shift` + `V`	Paste values only
`Ctrl` + `Alt` + `V`	`Cmd` + `Option` + `V`	Paste format only
`Ctrl` + `Z`	`Cmd` + `Z`	Undo
`Ctrl` + `Y`	`Cmd` + `Shift` + `Z`	Redo
`Ctrl` + `K`	`Cmd` + `K`	Insert a link

Windows	Mac	What it does
`=`	`=`	Start a formula
`F4`	`F4`	Cycle absolute and relative references while editing
`Ctrl` + `Shift` + `Enter`	`Cmd` + `Shift` + `Return`	Wrap the formula in ARRAYFORMULA
`Ctrl` + `	`Ctrl` + `	Show formulas instead of results, and back
`Tab`	`Tab`	Accept the suggested function
`F1`	`Fn` + `F1`	Show or hide the formula help while editing

Windows	Mac	What it does
`Ctrl` + `B`	`Cmd` + `B`	Bold
`Ctrl` + `I`	`Cmd` + `I`	Italic
`Ctrl` + `U`	`Cmd` + `U`	Underline
`Alt` + `Shift` + `5`	`Cmd` + `Shift` + `X`	Strikethrough
`Ctrl` + `Shift` + `E`	`Cmd` + `Shift` + `E`	Centre
`Ctrl` + `Shift` + `L`	`Cmd` + `Shift` + `L`	Align left
`Ctrl` + `Shift` + `R`	`Cmd` + `Shift` + `R`	Align right
`Ctrl` + `Shift` + `1`	`Ctrl` + `Shift` + `1`	Number with two decimals
`Ctrl` + `Shift` + `3`	`Ctrl` + `Shift` + `3`	Date format
`Ctrl` + `Shift` + `4`	`Ctrl` + `Shift` + `4`	Currency format
`Ctrl` + `Shift` + `5`	`Ctrl` + `Shift` + `5`	Percentage format
`Ctrl` + `\`	`Cmd` + `\`	Clear formatting

Windows	Mac	What it does
`Ctrl` + `Alt` + `=`	`Cmd` + `Option` + `=`	Insert rows or columns, with rows or columns selected
`Ctrl` + `Alt` + `-`	`Cmd` + `Option` + `-`	Delete the selected rows or columns
`Ctrl` + `Alt` + `9`	`Cmd` + `Option` + `9`	Hide the selected rows
`Ctrl` + `Alt` + `0`	`Cmd` + `Option` + `0`	Hide the selected columns
`Ctrl` + `Shift` + `9`	`Cmd` + `Shift` + `9`	Unhide rows
`Ctrl` + `Shift` + `0`	`Cmd` + `Shift` + `0`	Unhide columns
`Alt` + `Shift` + `Right arrow`	`Option` + `Shift` + `Right arrow`	Group rows or columns
`Alt` + `Shift` + `Left arrow`	`Option` + `Shift` + `Left arrow`	Ungroup
`Shift` + `F11`	`Shift` + `Fn` + `F11`	Insert a new sheet
`Ctrl` + `Alt` + `M`	`Cmd` + `Option` + `M`	Insert a comment
`Ctrl` + `Alt` + `Shift` + `H`	`Cmd` + `Option` + `Shift` + `H`	Open the version history

Switch on the Excel-style shortcuts

Open the shortcut panel with Ctrl + / and turn on Enable compatible spreadsheet shortcuts. More of the combinations used in other spreadsheet programs then work in Sheets. The same panel is a searchable list of every shortcut for your own system, and it is the final word when this page and your keyboard disagree.

The browser gets some keys first

Sheets shares the keyboard with the browser. Ctrl + T opens a browser tab, not a table. Ctrl + W closes the whole file's tab. A few of the spreadsheet shortcuts people know from Excel, such as Ctrl + Page Down for the next sheet, are taken by the browser for its own tabs, which is why Sheets uses Alt + Down arrow.

Paste values only

Ctrl + Shift + V pastes the result of a formula without the formula, and text without its formatting. It is the way to freeze a calculated column, or to bring in data from a website without its colours and fonts.

Fill a whole range at once

Select a range, type a value or a formula, and press Ctrl + Enter. Every selected cell gets it, with references adjusted as if you had copied the formula down. To fill a formula down a long column, select from the formula cell to the bottom with Ctrl + Shift + Down arrow, then press Ctrl + D.

Nothing to save

As in Docs, every change is saved as it happens, and File, Version history keeps earlier states. For formulas and functions, see our Google Sheets site.

This is an independent reference site. It is not connected with Microsoft, Apple, Google or any other maker of the programs named here. Product names belong to their owners and are used only to say where a shortcut works. Programs change; if a shortcut does not work for you, check the program's own help.