Google Sheets Keyboard Shortcuts

Google Sheets Keyboard Shortcuts

Google Sheets is the go-to spreadsheet tool for anyone who doesn’t want to use Microsoft Excel. While the menus at the top offer most of the functions at your fingertips, there’s no doubt that keyboard shortcuts will save you time. Whether your device uses Windows, macOS, or ChromeOS, this list of Google Sheets keyboard shortcuts can help boost your productivity so you can become a spreadsheets master.

Google Sheets Keyboard Shortcuts Download

Download this Cheatsheet

Enter your email below to receive this PDF cheatsheet in your Inbox.

Apart from the below-mentioned keyboard shortcuts, you can also use keyboard shortcuts made by other apps/companies in Google Sheets. To do so, go to Help → Keyboard shortcuts (or use Ctrl +/) shortcut and then turn on Enable compatible spreadsheet shortcuts.

WindowsmacOSChromeOSFunction
Menus
Alt + F
or Alt + Shift + F
Ctrl + Option + FAlt + FOpen the File menu.
Alt + E
or Alt + Shift + E
Ctrl + Option + EAlt + EOpen the Edit menu.
Alt + V
or Alt + Shift + V
Ctrl + Option + VAlt + VOpen the View menu.
Alt + I
or Alt + Shift + I
Ctrl + Option + IAlt + IOpen the Insert menu.
Alt + O
or Alt + Shift + O
Ctrl + Option + OAlt + OOpen the Format menu.
Alt + D
or Alt + Shift + D
Ctrl + Option + DAlt + DOpen the Data menu.
Alt + T
or Alt + Shift + T
Ctrl + Option + TAlt + TOpen the Tools menu.
Ctrl + Alt + Equal Sign (=)Command + Option + Equal Sign (=) Ctrl + Alt + Equal Sign (=) Open the Insert menu with cells selected.
Ctrl + Alt + Minus Sign (-) Command + Option + Minus Sign (-) Ctrl + Alt + Minus Sign (-) Open the Delete menu with cells selected.
Alt + M or Alt + Shift + MCtrl + Option + MAlt + MForm menu (present when the spreadsheet is connected to a form).
Alt + N or Alt + Shift + NCtrl + Option + NAlt + NOpen the Add-ons menu.
Alt + HCtrl + Option + HAlt + HOpen the Help menu.
Alt + ACtrl + Option + AAlt + AOpen the Accessibility menu (present when screen reader support is enabled).
Alt + Shift + SOption + Shift + SCtrl + Shift + SOpen the Sheet menu (copy, delete, and other sheet actions).
Ctrl + Shift + \ or Shift + F10Command + Shift + \ or Shift + F10Ctrl + Shift + \ or Shift + F10Open the Context menu.
Alt + /Option + /Alt + /Search the menus.
Common Actions
Ctrl + SpaceCtrl + SpaceCtrl + SpaceSelect column.
Shift + SpaceShift + SpaceShift + SpaceSelect row.
Ctrl + A
or Ctrl + Shift + Space
Command + A or Command + Shift + SpaceCtrl + ASelect all.
Ctrl + ZCommand + ZCtrl + ZPerform undo action.
Ctrl + Y
or Ctrl + Shift + Z
or F4
Command + Y
or Command + Shift + Z
or Fn + F4
Ctrl + Y
or Ctrl + Shift + Z
Redo any action.
Ctrl + FCommand + FCtrl + FFind in Google Sheets.
Ctrl + HCommand + Shift + HCtrl + HFind and replace.
Ctrl + EnterCommand + EnterCtrl + EnterFill range.
Ctrl + DCommand + DCtrl + DFill down.
Ctrl + RCommand + RCtrl + RFill right.
Ctrl + SCommand + SCtrl + SSave manually.
Ctrl + OCommand + OCtrl + OOpen new sheet.
Ctrl + PCommand + PCtrl + PPrint sheet.
Ctrl + CCommand + CCtrl + CCopy selected data.
Ctrl + XCommand + XCtrl + XCut selected data.
Ctrl + VCommand + VCtrl + VPaste selected data.
Ctrl + Shift + VCommand + Shift + VCtrl + Shift + VPaste values only.
Ctrl + Slash ( / )Command + Slash ( / )Ctrl + Slash ( / )Show available keyboard shortcuts.
Shift + F11Shift + Fn + F11Insert new sheet.
Ctrl + Shift + FCtrl + Shift + FCtrl + Shift + FCompact controls.
Ctrl + Shift + KCommand + Shift + KCtrl + Shift + KInput tools on/off (available in spreadsheets in non-Latin languages).
Ctrl + Alt + Shift + KCommand + Option + Shift + KCtrl + Alt + Shift + KSelect input tools.
Format Cells
Ctrl + BCommand + BCtrl + BBold the text.
Ctrl + UCommand + UCtrl + UUnderline the text.
Ctrl + ICommand + ICtrl + IItalicize the text.
Alt + Shift + 5Option + Shift + 5Alt + Shift + 5Strikethrough.
Ctrl + Shift + ECommand + Shift + ECtrl + Shift + ECenter align.
Ctrl + Shift + lCommand + Shift + lCtrl + Shift + lLeft align.
Ctrl + Shift + RCommand + Shift + RCtrl + Shift + RRight align.
Alt + Shift + 1Option + Shift + 1Alt + Shift + 1Apply top border.
Alt + Shift + 2Option + Shift + 2Alt + Shift + 2Apply right border.
Alt + Shift + 3Option + Shift + 3Alt + Shift + 3Apply bottom border.
Alt + Shift + 4Option + Shift + 4Alt + Shift + 4Apply left border.
Alt + Shift + 6Option + Shift + 6Alt + Shift + 6Remove borders.
Alt + Shift + 7 or Ctrl + Shift + 7Option + Shift + 7 or Command + Shift + 7Alt + Shift + 7 or Ctrl + Shift + 7Apply outer border.
Insert or Format
Ctrl + KCommand + KCtrl + KInsert link.
Ctrl + Shift + Semicolon ( ; )Command + Shift + Semicolon ( ; )Ctrl + Shift + Semicolon ( ; )Insert time.
Ctrl + Semicolon ( ; )Command + Semicolon ( ; )Ctrl + Semicolon ( ; )Insert date.
Ctrl + Alt + Shift + Semicolon ( ; )Command + Option + Shift + Semicolon ( ; )Ctrl + Alt + Shift + Semicolon ( ; )Insert date and time.
Ctrl + Shift + 1Ctrl + Shift + 1Ctrl + Shift + 1Format as decimal.
Ctrl + Shift + 2Ctrl + Shift + 2Ctrl + Shift + 2Format as time.
Ctrl + Shift + 3Ctrl + Shift + 3Ctrl + Shift + 3Format as date.
Ctrl + Shift + 4Ctrl + Shift + 4Ctrl + Shift + 4Format as currency.
Ctrl + Shift + 5Ctrl + Shift + 5Ctrl + Shift + 5Format as percentage.
Ctrl + Shift + 6Ctrl + Shift + 6Ctrl + Shift + 6Format as exponent.
Ctrl + Slash ( \ )Command + Slash ( \ )Ctrl + Slash ( \ )Clear formatting.
Navigate.
HomeFn + Left ArrowSearch + Left ArrowMove to the beginning of a row.
Ctrl + HomeCommand + Fn + Left ArrowCtrl + Search + Left ArrowMove to the beginning of a sheet.
EndFn + Right ArrowSearch + Right ArrowMove to the end of a row.
Ctrl + EndCommand + Fn + Right ArrowCtrl + Search + Right ArrowMove to the end of a sheet.
Ctrl + BackspaceCommand + BackspaceCtrl + BackspaceScroll to the active cell.
Alt + Down ArrowOption + Down ArrowCtrl + Shift + Search + Down ArrowMove to the next sheet.
Alt + Up ArrowOption + Up ArrowCtrl + Shift + Search + Up ArrowMove to the previous sheet.
Alt + Shift + KOption + Shift + KAlt + Shift + KDisplay the list of sheets.
Alt + EnterOption + EnterAlt + EnterOpen hyperlink.
Alt + Shift + XOption + Shift + XAlt + Shift + XOpen Explore.
Ctrl + Alt + PeriodCommand + Option + PeriodAlt + Shift + PeriodGo to the side panel.
Ctrl + Alt + Shift + MCtrl + Command + Shift + MCtrl + Alt + Shift + MMove focus out of the spreadsheet.
Alt + Shift + QOption + Shift + QAlt + Shift + QMove to quick sum (when a range of cells is selected).
Hold Ctrl + Alt, press E, then PHold Ctrl + Command, press E, then PHold Ctrl + Alt, press E, then PMove focus to a popup (for links, bookmarks, and images).
Ctrl + Alt + RCtrl + Command + RCtrl + Alt + ROpen the drop-down menu on a filtered cell.
Ctrl + Alt + Shift + HCommand + Option + Shift + HCtrl + Alt + Shift + HOpen revision history.
Shift + EscCommand + EscCtrl + EscClose drawing editor.
Edit Notes and Comments
Shift + F2Shift + F2Shift + Search + 2Insert/edit note.
Ctrl + Alt + MCommand + Option + MCtrl + Alt + MInsert/edit comment.
Ctrl + Alt + Shift + ACommand + Option + Shift + ACtrl + Alt + Shift + AOpen comment discussion thread.
Hold Ctrl + Alt, press E, then CHold Ctrl + Command, press E, then CHold Ctrl + Alt, press E, then CEnter a comment.
Hold Ctrl + Alt, press N, then CHold Ctrl + Command, press N, then CHold Ctrl + Alt, press N, then CMove to the next comment.
Hold Ctrl + Alt, press C, then CHold Ctrl + Command, press P, then CHold Ctrl + Alt, press P, then CMove to the previous comment.
RRRReply to the current comment.
JJJMove to the next comment.
KKKMove to the previous comment.
EEEResolve the current comment.
UUUExit current comment.
Add or Change Rows and Columns
Alt + I, then R Ctrl + Option + I, then RAlt + I, then RInsert rows above.
Ctrl + Alt + Equal (=)Command + Option + Equal (=) Ctrl + Alt + Equal (=) Insert rows above (with rows selected).
Alt + I, then w or Alt + Shift + I, then WCtrl + Option + I, then BAlt + I, then WInsert rows below.
Alt + I, then CCtrl + Option + I, then CAlt + I, then CInsert columns to the left.
Ctrl + Alt + = Command + Option + = Ctrl + Alt + =Insert columns to the left (with columns selected).
Alt + I, then O Ctrl + Option + I, then OAlt + I, then OInsert columns to the right.
Ctrl + Alt + Minus (-)Command + Option + Minus (-)Ctrl + Alt + Minus (-) Delete rows (with rows selected).
Alt + E, then D Ctrl + Option + E, then DAlt + E, then DDelete rows.
Ctrl + Alt + Minus (-) Command + Option + Minus (-) Ctrl + Alt + Minus (-) Delete columns (with columns selected).
Alt + E, then E Ctrl + Option + E, then EAlt + E, then EDelete columns.
Ctrl + Alt + 9Command + Option + 9Ctrl + Alt + 9Hide row.
Ctrl + Shift + 9Command + Shift + 9Ctrl + Shift + 9Unhide row.
Ctrl + Alt + 0Command + Option + 0Ctrl + Alt + 0Hide column.
Ctrl + Shift + 0Command + Shift + 0Ctrl + Shift + 0Unhide column.
Alt + Shift + Right ArrowOption + Shift + Right ArrowAlt + Shift + Right Arrow Group rows or columns.
Alt + Shift + Left ArrowOption + Shift + Left ArrowAlt + Shift + Left ArrowUngroup rows or columns.
Alt + Shift + Down ArrowOption + Shift + Down Arrow Alt + Shift + Down ArrowExpand grouped rows or columns.
Alt + Shift + Up ArrowOption + Shift + Up Arrow Alt + Shift + Up ArrowCollapse grouped rows or columns.
Use Formulas
Ctrl + Tilde (~)Ctrl + Tilde (~)Ctrl + Tilde (~)Show all formulas.
Ctrl + Shift + EnterCommand + Shift + EnterCtrl + Shift + EnterInsert array formula.
Ctrl + ECommand + ECtrl + ECollapse an expanded array formula.
Shift + F1Shift + Fn + F1Shift + Search + 1Show/hide formula help (when entering a formula).
F1Fn + F1Search + 1Full/compact formula help (when entering a formula).
F4Fn + F4Search + 9Absolute/relative references (when entering a formula).
F9Fn + F9Toggle formula result previews (when entering a formula).
Ctrl + Up or Ctrl + DownCtrl + Option + Up or Ctrl + Option + DownResize the formula bar (move up or down).
Help for Screen Readers
Ctrl + Alt + ZCommand + Option + ZCtrl + Alt + ZTurn on screen reader support.
Ctrl + Alt + HCommand + Option + HCtrl + Alt + HEnable braille support.
Ctrl + Alt + Shift + CCommand + Option + Shift + CCtrl + Alt + Shift + CRead column.
Ctrl + Alt + Shift + RCommand + Option + Shift + RCtrl + Alt + Shift + RRead row.
Is this post useful?
Subscribe to our newsletter!

Our latest tutorials delivered straight to your inbox

Mehvish Mushtaq

Mehvish is a tech lover from Kashmir. With a degree in computer engineering, she's always been happy to help anyone who finds technology challenging. She's been writing about technology for over six years, and her favorite topics include how-to guides, explainers, tips and tricks for Android, iOS/iPadOS, Windows, social media, and web apps.