💬 Complete Reference

All Google Sheets Keyboard Shortcuts

111 shortcuts across 8 categories to supercharge your spreadsheet productivity.

Browse by Category

⚡

Common Actions

Essential everyday shortcuts for Google Sheets productivity.

25 shortcuts

🎨

Formatting

Format cells, text, and numbers quickly with keyboard shortcuts.

24 shortcuts

🧭

Navigation

Navigate spreadsheets efficiently with keyboard shortcuts.

17 shortcuts

🔢

Formulas

Work with formulas and functions using keyboard shortcuts.

6 shortcuts

📊

Rows & Columns

Insert, delete, hide and manage rows and columns.

14 shortcuts

💬

Notes & Comments

Add notes, comments, and collaborate with your team.

6 shortcuts

📋

Menus

Open and navigate menus using keyboard shortcuts.

13 shortcuts

♿

Accessibility & Screen Readers

Accessibility shortcuts for screen readers and braille support.

6 shortcuts

⚡Common Actions

Ctrl + Space
Select ColumnSelect the entire column of the currently active cell in one keystroke.
Shift + Space
Select RowSelect the entire row of the currently active cell.
Ctrl + A
Select AllSelect all cells in the current sheet for bulk operations.
Ctrl + Z
UndoReverse your last action. Press multiple times to undo several actions.
Ctrl + Y
RedoRedo the last undone action to restore changes you reversed.
Ctrl + F
FindOpen the Find toolbar to search for specific text or values in your spreadsheet.
Ctrl + H
Find and ReplaceFind specific text and replace it with new text across your spreadsheet.
Ctrl + Enter
Fill RangeFill the selected range with the content of the current cell.
Ctrl + D
Fill DownCopy the content and formatting of the top cell to all selected cells below.
Ctrl + R
Fill RightCopy the content of the leftmost cell to all selected cells to the right.
Ctrl + S
SaveSave the current spreadsheet. Google Sheets auto-saves, but this forces an immediate save.
Ctrl + O
OpenOpen a file from your Google Drive.
Ctrl + P
PrintOpen print settings to print your spreadsheet or save it as a PDF.
Ctrl + C
CopyCopy selected cells to the clipboard for pasting elsewhere.
Ctrl + X
CutCut selected cells to move them to a new location.
Ctrl + V
PastePaste clipboard contents into the selected cells, including formatting and formulas.
Ctrl + Shift + V
Paste Values OnlyPaste only the values without formatting or formulas — great for cleaning up data.
Ctrl + /
Show Keyboard ShortcutsDisplay the complete list of keyboard shortcuts available in Google Sheets.
Shift + F11
Insert New SheetAdd a new blank sheet tab to your spreadsheet workbook.
Ctrl + Shift + F
Compact ControlsToggle the toolbar and menus between compact and full view to gain more screen space.
Ctrl + Shift + K
Input Tools On/OffTurn input tools on or off for typing in different languages.
Ctrl + Alt + Shift + K
Select Input ToolsOpen the input tools selection menu to choose a different keyboard or input method.
Alt + /
Search the Menus (Tool Finder)Open Tool Finder to quickly search for any menu item or action by name.
Alt + 1
Rename SheetRename the current sheet tab without using the mouse.
Ctrl + Alt + T
Convert Range to TableConvert the selected range of cells into a formatted table.

🎨Formatting

Ctrl + B
BoldApply bold formatting to the selected cells to emphasize important data.
Ctrl + U
UnderlineApply underline formatting to the selected cells.
Ctrl + I
ItalicApply italic formatting to the selected cells.
Alt + Shift + 5
StrikethroughApply strikethrough formatting to cross out text in selected cells.
Ctrl + Shift + E
Center AlignCenter-align the content in the selected cells.
Ctrl + Shift + L
Left AlignLeft-align the content in the selected cells.
Ctrl + Shift + R
Right AlignRight-align the content in the selected cells.
Alt + Shift + 1
Apply Top BorderApply a border to the top edge of the selected cells.
Alt + Shift + 2
Apply Right BorderApply a border to the right edge of the selected cells.
Alt + Shift + 3
Apply Bottom BorderApply a border to the bottom edge of the selected cells.
Alt + Shift + 4
Apply Left BorderApply a border to the left edge of the selected cells.
Alt + Shift + 6
Remove BordersRemove all borders from the selected cells.
Alt + Shift + 7
Apply Outer BorderApply outer borders around the selected cell range.
Ctrl + K
Insert LinkInsert or edit a hyperlink in the selected cell.
Ctrl + Shift + ;
Insert TimeInsert the current time into the selected cell as a static value.
Ctrl + ;
Insert DateInsert today's date into the selected cell as a static value.
Ctrl + Alt + Shift + ;
Insert Date and TimeInsert both the current date and time into the selected cell.
Ctrl + Shift + 4
Format as CurrencyApply currency formatting with a dollar sign to the selected cells.
Ctrl + Shift + 5
Format as PercentageApply percentage formatting to the selected cells.
Ctrl + Shift + 6
Format as ExponentApply scientific notation (exponent) formatting to the selected cells.
Ctrl + Shift + 3
Format as DateApply date formatting to the selected cells.
Ctrl + Shift + 2
Format as TimeApply time formatting to the selected cells.
Ctrl + Shift + 1
Format as NumberApply decimal number formatting to the selected cells.
Ctrl + \
Clear FormattingRemove all formatting from the selected cells while keeping the data.

🧭Navigation

Home
Go to Beginning of RowMove the cursor to the first cell (column A) of the current row.
Ctrl + Home
Go to Beginning of SheetJump to cell A1 — the very beginning of your spreadsheet.
End
Go to End of RowMove the cursor to the last cell with data in the current row.
Ctrl + End
Go to End of SheetJump to the last cell that contains data in your spreadsheet.
Ctrl + Backspace
Scroll to Active CellScroll the view to show the currently active cell when it is out of view.
Ctrl + Page Down
Move to Next SheetSwitch to the next sheet tab in your workbook.
Ctrl + Page Up
Move to Previous SheetSwitch to the previous sheet tab in your workbook.
Alt + Shift + K
Display List of SheetsShow a list of all sheets in your workbook for quick navigation.
Alt + Enter
Open HyperlinkOpen the hyperlink in the selected cell in a new browser tab.
Alt + Shift + X
Open ExploreOpen the Explore panel for insights, charts, and analysis of your data.
Ctrl + Alt + .
Move Focus to Side PanelMove keyboard focus to the side panel (Explore, Calendar, etc.).
Ctrl + Alt + Shift + M
Move Focus Out of SpreadsheetMove keyboard focus out of the spreadsheet grid to the browser or other UI elements.
Ctrl + Alt, then E then P
Move Focus to PopupMove keyboard focus to a popup element such as a link, bookmark, or image tooltip.
Ctrl + Alt + R
Open Drop-Down on Filtered CellOpen the drop-down filter menu on a filtered cell.
Ctrl + Alt + Shift + H
Open Revision HistoryOpen the version history to see and restore previous versions of your spreadsheet.
Shift + Esc
Open ChatOpen the chat panel inside the spreadsheet for real-time collaboration.
Esc
Close Drawing EditorClose the drawing editor overlay and return to your spreadsheet.

🔢Formulas

Ctrl + ~
Show All FormulasToggle between showing cell values and showing the formulas in every cell.
Ctrl + Shift + Enter
Insert Array FormulaEnter an array formula that can return results across multiple cells.
Ctrl + Shift + E
Collapse or Expand Formula BarToggle the formula bar between collapsed and expanded view.
Shift + F1
Show or Hide Formula HelpShow or hide the formula help tooltip when editing a formula.
Ctrl + Up / Ctrl + Down
Resize Formula BarResize the formula bar to show more or fewer lines of your formula.
F4
Absolute Reference (Toggle)Cycle through absolute ($A$1), mixed ($A1, A$1), and relative (A1) cell references.

📊Rows & Columns

Alt + I, then R
Insert Row AboveInsert a new row above the currently selected row.
Alt + I, then B
Insert Row BelowInsert a new row below the currently selected row.
Alt + I, then L
Insert Column LeftInsert a new column to the left of the currently selected column.
Alt + I, then R
Insert Column RightInsert a new column to the right of the currently selected column.
Alt + E, then D
Delete RowDelete the currently selected row and shift remaining rows up.
Alt + E, then E
Delete ColumnDelete the currently selected column and shift remaining columns left.
Ctrl + Alt + 9
Hide RowHide the currently selected row(s) from view without deleting them.
Ctrl + Alt + 0
Hide ColumnHide the currently selected column(s) from view without deleting them.
Ctrl + Shift + 9
Unhide RowReveal previously hidden rows in your spreadsheet.
Ctrl + Shift + 0
Unhide ColumnReveal previously hidden columns in your spreadsheet.
Alt + Shift + Right Arrow
Group Rows or ColumnsGroup the selected rows or columns together for collapsible sections.
Alt + Shift + Left Arrow
Ungroup Rows or ColumnsUngroup previously grouped rows or columns.
Alt + Shift + Down Arrow
Expand Grouped Rows or ColumnsExpand collapsed grouped rows or columns to show their contents.
Alt + Shift + Up Arrow
Collapse Grouped Rows or ColumnsCollapse grouped rows or columns to hide their contents.

💬Notes & Comments

Shift + F2
Insert or Edit NoteAdd a new note or edit an existing note on the selected cell.
Ctrl + Alt + M
Insert CommentAdd a comment to the selected cell for team collaboration and discussion.
Ctrl + Alt + Shift + A
Open Comment ThreadOpen the full comment discussion thread for review and replies.
Ctrl + Alt, then E then C
Enter Current CommentJump into and focus on the current comment for editing or reading.
Ctrl + Alt, then N then C
Move to Next CommentNavigate to the next comment in the spreadsheet.
Ctrl + Alt, then P then C
Move to Previous CommentNavigate to the previous comment in the spreadsheet.

📋Menus

Alt + F
Open File MenuOpen the File menu to access save, download, share, and print options.
Alt + E
Open Edit MenuOpen the Edit menu for undo, redo, copy, paste, and other editing options.
Alt + V
Open View MenuOpen the View menu to control zoom, freeze panes, gridlines, and more.
Alt + I
Open Insert MenuOpen the Insert menu to add rows, columns, charts, images, and more.
Alt + O
Open Format MenuOpen the Format menu for number formatting, text styling, and conditional formatting.
Alt + D
Open Data MenuOpen the Data menu for sorting, filtering, data validation, and pivot tables.
Alt + T
Open Tools MenuOpen the Tools menu for spell check, script editor, macros, and more.
Alt + M
Open Form MenuOpen the Form menu when your spreadsheet is linked to a Google Form.
Alt + N
Open Add-Ons MenuOpen the Extensions/Add-ons menu to manage installed add-ons.
Alt + H
Open Help MenuOpen the Help menu for documentation, keyboard shortcuts, and support.
Alt + A
Open Accessibility MenuOpen the Accessibility menu for screen reader and accessibility settings.
Alt + Shift + S
Open Sheet Tab MenuOpen the right-click context menu for the current sheet tab.
Ctrl + Shift + \
Open Context MenuOpen the right-click context menu for the selected cell(s) using the keyboard.

♿Accessibility & Screen Readers

Ctrl + Alt + Z
Enable Screen Reader SupportEnable screen reader mode for better accessibility when using assistive technology.
Ctrl + Alt + Shift + C
Read ColumnHave the screen reader announce the current column letter and header.
Ctrl + Alt + Shift + R
Read RowHave the screen reader announce the current row number and header.
Ctrl + Alt + H
Enable Braille SupportEnable braille display support for use with refreshable braille devices.
Ctrl + Alt + Shift + L
Announce SelectionHave the screen reader announce the currently selected cell range.
Ctrl + Alt + Shift + F
Announce FormattingHave the screen reader announce the formatting details of the selected cell.

⚡ Want Shortcut Hints Right Inside Google Sheets?

Accelerator Keys shows hints, documents, and shortcut keys directly in your spreadsheet.

Add Accelerator Keys by 8apps to Chrome