Google Sheets Keyboard Shortcuts: 85 Shortcuts (Searchable)

Q: Do Excel shortcuts work in Google Sheets?

Many do. Press Ctrl+/ and turn on Enable compatible spreadsheet shortcuts to get more of them.

Q: How do I paste only values?

Copy the cells, then press Ctrl+Shift+V.

Google Sheets · Windows & Chromebook

Every Google Sheets shortcut, one keystroke away.

A searchable reference of 85 keyboard shortcuts for Google Sheets — editing, formatting, navigation, rows and columns, formulas and comments. Search, filter by category, and tap any shortcut to copy it.

e.g.Ctrl+Shift+VorCtrl+Alt+M

85shortcuts

8categories

25to memorise first

Essential — learn first Productivity — big time-savers Advanced — power users+ together → in sequence

★

Start here — the 25 to memorise first

These are the shortcuts that save the most time in everyday Google Sheets work.

#	Shortcut	Action	Why remember it
01	`Ctrl`+`/`	Show all shortcuts	Google Sheets’ own built-in shortcut list.
02	`Ctrl`+`C`or`Ctrl`+`X`or`Ctrl`+`V`	Copy, cut, paste	The basics.
03	`Ctrl`+`Shift`+`V`	Paste values only	Paste numbers without formulas or formatting.
04	`Ctrl`+`Z`	Undo	Reverse any change.
05	`Ctrl`+`Y`	Redo	Bring back an undo.
06	`Ctrl`+`Enter`	Fill range	Type once, fill every selected cell.
07	`Ctrl`+`D`	Fill down	Copy the top cell down.
08	`Ctrl`+`Arrow`	Jump to edge	Reach the end of your data.
09	`Ctrl`+`Shift`+`Arrow`	Select to edge	Select a whole block of data.
10	`Ctrl`+`Space`	Select column	Select the entire column.
11	`Shift`+`Space`	Select row	Select the entire row.
12	`Ctrl`+`F`	Find	Search the sheet.
13	`Ctrl`+`H`	Find and replace	Fix values everywhere.
14	`Ctrl`+`B`	Bold	Format headers.
15	`Ctrl`+`Shift`+`4`	Currency format	Format money in one step.
16	`Ctrl`+`Shift`+`5`	Percent format	Format percentages.
17	`Ctrl`+`;`	Insert date	Today’s date as a value.
18	`Ctrl`+`\`	Clear formatting	Remove all formatting from cells.
19	`F2`	Edit cell	Edit without retyping.
20	`F4`	Toggle absolute reference	Switch between A1, $A$1, A$1 and $A1.
21	`Ctrl`+`	Show formulas	See every formula at once.
22	`Ctrl`+`Alt`+`M`	Insert comment	Discuss a value with your team.
23	`Ctrl`+`Alt`+`9`	Hide row	Hide rows you don’t need.
24	`Ctrl`+`Shift`+`Page Down`	Next sheet	Move between tabs.
25	`Ctrl`+`K`	Insert link	Link to a website or range.

Essential Shortcuts

Everyday editing commands in Google Sheets.

Shortcut	Action	What it does	Example / use case
`Ctrl`+`/`	Keyboard shortcuts	Shows the built-in list of shortcuts.	Look up a shortcut you forgot.
`Ctrl`+`C`	Copy	Copies the selection.	Copy a range.
`Ctrl`+`X`	Cut	Cuts the selection.	Move data.
`Ctrl`+`V`	Paste	Pastes the clipboard.	Paste copied cells.
`Ctrl`+`Shift`+`V`	Paste values only	Pastes values without formulas or formatting.	Freeze calculated results.
`Ctrl`+`Alt`+`V`	Paste format only	Pastes only the formatting.	Copy a table style.
`Ctrl`+`Z`	Undo	Undoes the last action.	Reverse a wrong edit.
`Ctrl`+`Y`or`Ctrl`+`Shift`+`Z`	Redo	Redoes the last undone action.	Restore an edit.
`Ctrl`+`F`	Find	Finds text in the sheet.	Find a customer name.
`Ctrl`+`H`	Find and replace	Opens Find and replace.	Replace an old code everywhere.
`Ctrl`+`P`	Print	Opens print settings.	Export to PDF.
`Ctrl`+`O`	Open	Opens a file.	Open another sheet.
`Ctrl`+`S`	Save	Every change is saved automatically; this does nothing harmful.	Habit from Excel.
`Alt`+`/`	Search the menus	Searches menu commands by name.	Find “Data validation”.

Navigation

Move around large sheets quickly.

Shortcut	Action	What it does	Example / use case
`Ctrl`+`Arrow`	Jump to edge	Moves to the edge of the current data region.	Jump to the last row.
`Ctrl`+`Home`	Go to A1	Moves to the beginning of the sheet.	Back to the top.
`Ctrl`+`End`	Last cell	Moves to the last cell with data.	Check where data ends.
`Home`or`End`	Start or end of row	Moves to the start or end of the row.	Go to column A.
`Page Up`or`Page Down`	Screen up or down	Scrolls one screen.	Browse a long list.
`Ctrl`+`Backspace`	Scroll to active cell	Brings the active cell back into view.	Lost after scrolling.
`Ctrl`+`Shift`+`Page Down`	Next sheet	Moves to the next sheet tab.	Switch months.
`Ctrl`+`Shift`+`Page Up`	Previous sheet	Moves to the previous sheet tab.	Go back a sheet.
`Alt`+`Shift`+`K`	List of sheets	Shows the list of sheets.	Jump to any tab.
`Alt`+`Enter`	Open hyperlink	Opens the link in the selected cell.	Open a linked file.

Selection

Select cells, rows, columns and data blocks.

Shortcut	Action	What it does	Example / use case
`Shift`+`Arrow`	Extend selection	Extends the selection one cell.	Select a few cells.
`Ctrl`+`Shift`+`Arrow`	Select to edge	Extends the selection to the edge of the data.	Select a full column of data.
`Ctrl`+`Space`	Select column	Selects the entire column.	Format a column.
`Shift`+`Space`	Select row	Selects the entire row.	Delete a row.
`Ctrl`+`A`	Select all	Selects the data region, then the whole sheet.	Format everything.
`Ctrl`+`Shift`+`Home`or`Ctrl`+`Shift`+`End`	Select to start or end	Selects from the current cell to A1 or the last cell.	Copy a full report.

Data Entry and Editing

Enter, fill and edit values faster.

Shortcut	Action	What it does	Example / use case
`F2`	Edit cell	Edits the active cell.	Fix a typo.
`Enter`or`Shift`+`Enter`	Confirm and move	Confirms entry and moves down or up.	Fast data entry.
`Tab`or`Shift`+`Tab`	Confirm and move across	Confirms entry and moves right or left.	Fill a row.
`Ctrl`+`Enter`	Fill range	Enters the value in every selected cell.	Type “Kerala” in 50 cells at once.
`Ctrl`+`D`	Fill down	Copies the top cell into the cells below.	Copy a formula down.
`Ctrl`+`R`	Fill right	Copies the left cell into the cells to the right.	Copy a formula across.
`Alt`+`Enter`	New line in cell	Inserts a line break while editing.	Two-line address.
`Delete`	Clear contents	Clears the selected cells.	Remove values.
`Esc`	Cancel edit	Cancels the current entry.	Discard a typo.
`Ctrl`+`;`	Insert date	Inserts today’s date.	Log an entry date.
`Ctrl`+`Shift`+`;`	Insert time	Inserts the current time.	Time-stamp a call.
`Ctrl`+`Alt`+`Shift`+`;`	Insert date and time	Inserts the current date and time.	Audit entries.
`Ctrl`+`K`	Insert link	Inserts or edits a link.	Link to a document.

Formatting

Format numbers, text and borders.

Shortcut	Action	What it does	Example / use case
`Ctrl`+`B`	Bold	Bolds the selection.	Header row.
`Ctrl`+`I`	Italic	Italicises the selection.	Notes.
`Ctrl`+`U`	Underline	Underlines the selection.	Totals.
`Alt`+`Shift`+`5`	Strikethrough	Applies strikethrough.	Mark completed tasks.
`Ctrl`+`Shift`+`L`	Align left	Left-aligns the cells.	Text columns.
`Ctrl`+`Shift`+`E`	Align center	Centers the cells.	Headers.
`Ctrl`+`Shift`+`R`	Align right	Right-aligns the cells.	Numbers stored as text.
`Ctrl`+`Shift`+`1`	Number format	Formats as number with 2 decimals.	12345.678 → 12,345.68
`Ctrl`+`Shift`+`2`	Time format	Formats as time.	Clock-in times.
`Ctrl`+`Shift`+`3`	Date format	Formats as date.	Invoice dates.
`Ctrl`+`Shift`+`4`	Currency format	Formats as currency.	Prices.
`Ctrl`+`Shift`+`5`	Percent format	Formats as percentage.	Growth rates.
`Ctrl`+`Shift`+`6`	Scientific format	Formats in scientific notation.	Very large numbers.
`Ctrl`+`\`	Clear formatting	Removes all formatting.	Clean pasted data.
`Alt`+`Shift`+`7`	Outer border	Applies an outer border.	Box a table.
`Alt`+`Shift`+`1`	Top border	Applies a top border.	Line above totals.
`Alt`+`Shift`+`3`	Bottom border	Applies a bottom border.	Underline headers.
`Alt`+`Shift`+`2`	Right border	Applies a right border.	Separate column groups.
`Alt`+`Shift`+`4`	Left border	Applies a left border.	Separate column groups.
`Alt`+`Shift`+`6`	Remove borders	Removes all borders.	Clean layout.

Rows and Columns

Insert, delete, hide and group rows and columns.

Shortcut	Action	What it does	Example / use case
`Ctrl`+`Alt`+`=`	Insert rows or columns	Inserts rows or columns (select whole rows or columns first).	Add a row in a list.
`Ctrl`+`Alt`+`-`	Delete rows or columns	Deletes the selected rows or columns.	Remove empty rows.
`Ctrl`+`Alt`+`9`	Hide row	Hides the selected rows.	Hide helper rows.
`Ctrl`+`Shift`+`9`	Unhide row	Unhides rows in the selection.	Show hidden rows.
`Ctrl`+`Alt`+`0`	Hide column	Hides the selected columns.	Hide working columns.
`Ctrl`+`Shift`+`0`	Unhide column	Unhides columns in the selection.	Show hidden columns.
`Alt`+`Shift`+`Right`	Group	Groups the selected rows or columns.	Collapsible month details.
`Alt`+`Shift`+`Left`	Ungroup	Ungroups the selected rows or columns.	Remove a group.
`Alt`+`Shift`+`Down`	Expand group	Expands grouped rows or columns.	Show details.
`Alt`+`Shift`+`Up`	Collapse group	Collapses grouped rows or columns.	Show only totals.
`Shift`+`F11`	Insert new sheet	Adds a new sheet.	Add next month’s tab.

Formulas

Write, check and read formulas.

Shortcut	Action	What it does	Example / use case
`Ctrl`+`	Show formulas	Shows all formulas instead of results.	Audit a sheet.
`F4`	Toggle references	Cycles A1, $A$1, A$1 and $A1 while editing.	Lock a tax rate cell.
`Ctrl`+`Shift`+`Enter`	Array formula	Wraps the formula in ARRAYFORMULA.	Calculate a whole column.
`F1`	Formula help	Shows or hides formula help while editing.	Check the argument order.
`Shift`+`F1`	Full formula help	Shows the full help for the function being typed.	Read the function examples.
`Tab`	Accept suggestion	Accepts the highlighted function suggestion.	Type =VLO and Tab.

Comments, Notes and History

Collaborate and track changes.

Shortcut	Action	What it does	Example / use case
`Ctrl`+`Alt`+`M`	Insert comment	Adds a comment to the cell.	Ask a teammate to confirm a value.
`Ctrl`+`Alt`+`Shift`+`A`	Comment history	Opens the comment history.	Review a discussion.
`Shift`+`F2`	Insert note	Inserts or edits a note.	Explain a number.
`Ctrl`+`Alt`+`Shift`+`H`	Version history	Opens version history.	Restore yesterday’s data.
`Ctrl`+`Shift`+`F`	Compact controls	Hides or shows the menus.	More room for data.

No shortcuts match that search.
Try a different word, or clear the filter to see all 85.

Tips for Google Sheets shortcuts

Press Ctrl+/ inside any sheet to see Google’s built-in shortcut list. You can also turn on compatible spreadsheet shortcuts there, which lets many Excel shortcuts work in Sheets.

Some browser shortcuts take priority over Sheets. If a shortcut opens a browser feature instead, try it in a different browser or use Alt+/ to search the menus.

On a Mac, use Cmd in place of Ctrl and Option in place of Alt for most of these.

FAQ

Do Excel shortcuts work in Google Sheets?

Many do. Press Ctrl+/ and turn on Enable compatible spreadsheet shortcuts to get more of them.

Do I need to save in Google Sheets?

No. Every change is saved automatically to Google Drive.

Do these work on a Chromebook?

Yes. The Windows shortcuts in this list also work on Chrome OS.

How do I paste only values?

Copy the cells, then press Ctrl+Shift+V.

More shortcut guides

Shortcut references for the other apps you use every day.

Excel shortcuts Word shortcuts PowerPoint shortcuts Excel functions

Compiled by Ajay Anand · XL n CAD — 85 shortcuts for Google Sheets on Windows. Google Sheets is a trademark of Google LLC.