Google Sheets keyboard shortcuts for Windows and Mac

Copies selected cells or text to the clipboard. [1]

Cuts the selected cell content or text. [1]

Pastes the clipboard with available formatting behavior. [1]

Pastes values while omitting source cell formatting. [1]

Reverses the most recent undoable spreadsheet action. [1]

Reapplies an action that was undone. [1]

Opens in-sheet search of matching text. [1]

Search and optionally replace matched cell contents. [1]

Selects the row corresponding to the current cell. [1]

Selects the column containing the active cell. [1]

Selects a cell region or expands selection based on context. [1]

Replicates top-row data or formulas across the selected range. [1]

Replicates leftmost data or formulas across the selected range. [1]

Fills selected cells with the entered value or formula. [1]

Opens printing controls for the current sheet. [1]

Displays the shortcut list appropriate for your platform. [1]

Opens the Tool Finder for commands in the Sheets interface. [1]

Adds a new sheet tab in the workbook. [1]

Toggles bold for selected cell text or values. [1]

Toggles italic formatting on the selection. [1]

Adds or removes underline from selected content. [1]

Draws a line through selected cell contents. [1]

Centers the text or value within selected cells. [1]

Applies left alignment to a selected cell range. [1]

Applies right alignment to a selected cell range. [1]

Opens link controls for selected cell contents. [1]

Inserts a static date according to workbook locale. [1]

Inserts a static time; some European keyboard layouts use different shortcuts. [1]

Formats selected values as decimal numbers. [1]

Formats selected values using a time style. [1]

Formats selected values using a date style. [1]

Formats selected values as currency. [1]

Formats selected values as percentages. [1]

Applies exponent-based number display. [1]

Removes the selected cells' formatting without clearing their values. [1]

Draws an outer border on the selected range. [1]

Moves the active selection toward the beginning of the current row. [1]

Moves to the beginning of the worksheet. [1]

Moves toward the end of the current row. [1]

Moves to the worksheet's end according to Sheets navigation. [1]

Brings the active cell back into the visible viewport. [1]

Switches to the next worksheet tab. [1]

Switches to the previous worksheet tab. [1]

Displays the workbook's sheet list for navigation. [1]

Activates the selected link rather than editing its text. [1]

Opens the history of edits if permissions allow. [1]

Opens a drop-down menu for a filtered cell. [1]

Opens the note editor for the selected cell. [1]

Opens comment editing on the selected cell. [1]

Shows contextual options for the selected cell or range. [1]

Edits the worksheet's current tab name in supported PC browsers. [1]

Adds rows above the selected row range. [1]

Adds columns before the selected columns. [1]

Removes entire selected rows, not just cell values. [1]

Removes entire selected columns. [1]

Hides selected worksheet rows while retaining their data. [1]

Makes hidden rows within the current selection visible. [1]

Hides selected columns without deleting their data. [1]

Restores hidden columns within the selected range. [1]

Creates a collapsible grouping for the selected dimension. [1]

Removes the selected row or column grouping. [1]

Opens a collapsed grouping of rows or columns. [1]

Hides grouped detail rows or columns. [1]

Toggles formula display instead of calculated results. [1]

Cycles reference modes such as A1 and $A$1. [1]

Toggles contextual formula argument help. [1]

Uses a legacy array-formula shortcut; current array functions may spill directly. [1]

Enables or disables screen reader mode in Google Sheets. [1]

Copies selected cells or text using the macOS modifier. [2]

Pastes values without carrying over the source formatting. [2]

Reverses the last undoable action in the active sheet. [2]

Reapplies an undone operation. [2]

Searches spreadsheet contents. [2]

Opens Google Sheets Find and Replace on macOS. [2]

Copies the uppermost selected row across selected rows. [2]

Copies the leftmost selected column to the right. [2]

Opens the platform-specific shortcut list. [2]

Searches action names in the Sheets interface. [2]

Inserts a new worksheet on typical Mac notebook keyboards. [2]

Inserts the current date; localization may require different keys. [2]

Inserts the current time; some European layouts use a different mapping. [2]

Displays formulas instead of their computed values. [2]

Cycles absolute and relative ranges when using Mac function keys. [2]

Hides the selected row while preserving its contents. [2]

Opens the tab-navigation list for the workbook. [2]

This key may insert a link; use Option + / specifically for Tool Finder. [2]