Google Sheets keyboard shortcuts

Windows and Mac keys side by side. Shortcuts marked "Differs from Excel" do something else if you press them out of Excel habit.

Learn in the drill Use them in the simulation Differences from Excel Printable cheat sheet (PDF)

Navigation

Action	Windows	Mac
Jump to the edge of the dataJumps straight to the end of the data in that direction.	`Ctrl`+`Arrow`	`⌘`+`Arrow`
Go to the top of the sheetTakes you back to A1 from anywhere.	`Ctrl`+`Home`	`⌘`+`fn`+`←`
Go to the last cell with dataMoves to the bottom-right cell that contains data.	`Ctrl`+`End`	`⌘`+`fn`+`→`
Go to the next sheetDiffers from ExcelSwitches to the sheet on the right.	`Alt`+`↓`	`Option`+`↓`
Go to the previous sheetDiffers from ExcelSwitches to the sheet on the left.	`Alt`+`↑`	`Option`+`↑`
FindFinds text in the sheet.	`Ctrl`+`F`	`⌘`+`F`
Find and replaceFinds and replaces text across the whole document.	`Ctrl`+`H`	`⌘`+`Shift`+`H`

Selection

Action	Windows	Mac
Select the entire rowSelects the whole row of the active cell.	`Shift`+`Space`	`Shift`+`Space`
Select the entire columnSelects the whole column of the active cell.	`Ctrl`+`Space`	`control`+`Space`
Select allSelects the whole sheet.	`Ctrl`+`A`	`⌘`+`A`
Select to the edge of the dataExtends the selection to the end of the data in that direction.	`Ctrl`+`Shift`+`Arrow`	`⌘`+`Shift`+`Arrow`

Entering and editing

Action	Windows	Mac
Edit the cellStarts editing at the end of the cell, keeping what is already there.	`F2`	`F2`
Fill downCopies the top cell of the selection into the cells below.	`Ctrl`+`D`	`⌘`+`D`
Fill rightCopies the leftmost cell of the selection into the cells to the right.	`Ctrl`+`R`	`⌘`+`R`
Copy to rangeDiffers from ExcelPuts the contents of the active cell into every cell of the selection.	`Ctrl`+`Enter`	`⌘`+`Return`
Insert today's dateEnters today's date in the active cell.	`Ctrl`+`;`	`⌘`+`;`
Insert the current timeDiffers from ExcelEnters the current time in the active cell.	`Ctrl`+`Shift`+`;`	`⌘`+`Shift`+`;`
Insert date and timeEnters today's date and the current time together.	`Ctrl`+`Alt`+`Shift`+`;`	`⌘`+`Option`+`Shift`+`;`
UndoCancels the last action.	`Ctrl`+`Z`	`⌘`+`Z`
RedoRepeats an action you undid.	`Ctrl`+`Y`	`⌘`+`Y`
Toggle absolute and relative referencesWhile typing a formula, adds or removes $ in the reference.	`F4`	`fn`+`F4`
Show all formulasDiffers from ExcelShows formulas in cells instead of their results. Press again to switch back.	`Ctrl`+`~`	`control`+`~`

Copy and paste

Action	Windows	Mac
CopyCopies the selected cells.	`Ctrl`+`C`	`⌘`+`C`
CutCuts the selected cells. Pasting them moves them.	`Ctrl`+`X`	`⌘`+`X`
PastePastes what you copied.	`Ctrl`+`V`	`⌘`+`V`
Paste values onlyDiffers from ExcelPastes only the resulting values, without formulas or formatting.	`Ctrl`+`Shift`+`V`	`⌘`+`Shift`+`V`
Paste format onlyDiffers from ExcelPastes only formatting such as bold and number formats, leaving the text as it is.	`Ctrl`+`Alt`+`V`	`⌘`+`Option`+`V`

Formatting and number formats

Action	Windows	Mac
BoldMakes the text in the selected cells bold. Press again to remove it.	`Ctrl`+`B`	`⌘`+`B`
ItalicMakes the text in the selected cells italic.	`Ctrl`+`I`	`⌘`+`I`
UnderlineUnderlines the text in the selected cells.	`Ctrl`+`U`	`⌘`+`U`
StrikethroughDiffers from ExcelStrikes through the text in the selected cells.	`Alt`+`Shift`+`5`	`⌘`+`Shift`+`X`
Clear formattingDiffers from ExcelRemoves bold, borders, number formats and other formatting at once. The text stays.	`Ctrl`+`\`	`⌘`+`\`
Center alignDiffers from ExcelCenters the text in the cell.	`Ctrl`+`Shift`+`E`	`⌘`+`Shift`+`E`
Left alignDiffers from ExcelAligns the text to the left of the cell.	`Ctrl`+`Shift`+`L`	`⌘`+`Shift`+`L`
Right alignDiffers from ExcelAligns the text to the right of the cell.	`Ctrl`+`Shift`+`R`	`⌘`+`Shift`+`R`
Number formatShows the number with thousands separators and two decimals (1,234.00).	`Ctrl`+`Shift`+`1`	`control`+`Shift`+`1`
Time formatDiffers from ExcelShows the cell value as a time.	`Ctrl`+`Shift`+`2`	`control`+`Shift`+`2`
Date formatDiffers from ExcelShows the cell value as a date.	`Ctrl`+`Shift`+`3`	`control`+`Shift`+`3`
Currency formatDiffers from ExcelShows the currency symbol and two decimals (with US settings, $300.00).	`Ctrl`+`Shift`+`4`	`control`+`Shift`+`4`
Percent formatDiffers from ExcelMultiplies the value by 100 and adds % (0.85 → 85.00%).	`Ctrl`+`Shift`+`5`	`control`+`Shift`+`5`
Scientific formatDiffers from ExcelShows the value in scientific notation (such as 1.23E+04).	`Ctrl`+`Shift`+`6`	`control`+`Shift`+`6`
Outer borderDiffers from ExcelDraws a border around the selected range.	`Alt`+`Shift`+`7`	`Option`+`Shift`+`7`
Clear bordersDiffers from ExcelRemoves the borders from the selected range.	`Alt`+`Shift`+`6`	`Option`+`Shift`+`6`

Rows and columns

Action	Windows	Mac
Insert rowDiffers from ExcelWith rows selected, inserts a row above. With cells selected, opens a menu to choose rows, columns or cells.	`Ctrl`+`Alt`+`=`	`⌘`+`Option`+`=`
Delete rowDiffers from ExcelWith rows selected, deletes them. With cells selected, opens the delete menu.	`Ctrl`+`Alt`+`-`	`⌘`+`Option`+`-`
Hide rowsDiffers from ExcelHides the selected rows. Nothing is deleted, so you can bring them back.	`Ctrl`+`Alt`+`9`	`⌘`+`Option`+`9`
Unhide rowsShows the hidden rows inside the selection.	`Ctrl`+`Shift`+`9`	`⌘`+`Shift`+`9`
Hide columnsDiffers from ExcelHides the selected columns.	`Ctrl`+`Alt`+`0`	`⌘`+`Option`+`0`
Unhide columnsShows the hidden columns inside the selection.	`Ctrl`+`Shift`+`0`	`⌘`+`Shift`+`0`
Group rows or columnsGroups the selected rows (or columns) so you can collapse them.	`Alt`+`Shift`+`→`	`Option`+`Shift`+`→`
UngroupRemoves the row (or column) group.	`Alt`+`Shift`+`←`	`Option`+`Shift`+`←`
Convert to tableDiffers from ExcelTurns the selected range into a table. The first row becomes the header.	`Ctrl`+`Alt`+`T`	`⌘`+`Option`+`T`

Notes, comments and links

Action	Windows	Mac
Insert or edit a noteAdds a note to yourself on the cell. Nobody is notified.	`Shift`+`F2`	`Shift`+`F2`
Insert a commentAdds a comment that other people can see. Post it with Ctrl+Enter.	`Ctrl`+`Alt`+`M`	`⌘`+`Option`+`M`
Insert a linkAdds a link to the cell.	`Ctrl`+`K`	`⌘`+`K`
Open a linkDiffers from ExcelOpens the cell's link in a new tab.	`Alt`+`Enter`	`Option`+`Return`
Open version historyOpens the history of who changed what and when.	`Ctrl`+`Alt`+`Shift`+`H`	`⌘`+`Option`+`Shift`+`H`

Menus and sheets

Action	Windows	Mac
Search the menusDiffers from ExcelType the name of an action to call up the menu item. Works for actions that have no shortcut.	`Alt`+`/`	`Option`+`/`
Show the shortcut listOpens the list of Sheets keyboard shortcuts.	`Ctrl`+`/`	`⌘`+`/`
Insert a new sheetAdds a sheet and moves to it.	`Shift`+`F11`	`Shift`+`F11`

Sources: the Google Docs Editors Help page "Keyboard shortcuts for Google Sheets" and the shortcut list inside the app (Ctrl+/). Checked in Chrome on a Mac in October 2026.

Depending on your language or keyboard layout, some shortcuts may not work.

* Google Sheets is a trademark of Google LLC. This site is not affiliated with Google.