Google Sheets Keyboard Shortcuts

Google Sheets — is a cloud-based spreadsheet editor that is part of Google Workspace. It's used for both personal and team projects: from financial spreadsheets to analytical dashboards.

Keyboard shortcuts in Google Sheets allow you to:

Instantly navigate between cells and sheets.
Quickly edit and format data.
Efficiently work with formulas, filters, and analysis tools.
Save time on routine actions.

This article provides a complete list of keyboard shortcuts for Windows/Linux (PC), macOS, and Chrome OS, grouped by function. For Mac, ⌘ (Command) is typically used instead of Ctrl, and ⌥ (Option) instead of Alt. It's worth noting that mastering keyboard shortcuts for working with spreadsheets pairs well with learning other office programs — many users simultaneously study Word keyboard shortcuts for comprehensive document work, and online keyboard typing lessons help develop general skills for fast and accurate data entry, which is critically important when working with large volumes of information in spreadsheets.

General Commands

PC (Windows/Linux)

Create new spreadsheet: Ctrl + N
Open existing: Ctrl + O
Save copy: Ctrl + Shift + S
Print: Ctrl + P
Open keyboard shortcuts list: Ctrl + /
Undo/redo action: Ctrl + Z / Ctrl + Y
Cut/copy/paste: Ctrl + X / Ctrl + C / Ctrl + V
Paste without formatting: Ctrl + Shift + V
Find/replace: Ctrl + F / Ctrl + H
Zoom: Ctrl + mouse wheel or Ctrl + + / Ctrl + -

macOS

New spreadsheet: ⌘ + N
Open: ⌘ + O
Print: ⌘ + P
Open keyboard shortcuts list: ⌘ + /
Undo/redo: ⌘ + Z / ⌘ + Y or ⌘ + Shift + Z
Cut/copy/paste: ⌘ + X / ⌘ + C / ⌘ + V
Paste without formatting: ⌘ + Shift + V
Find/replace: ⌘ + F / ⌘ + Shift + H

Chrome OS

Same as PC: Ctrl + / — shortcuts list; copy, paste, undo, redo — same combinations.

Cell and Range Navigation

Arrow keys — move one cell.
Ctrl + arrow key — jump to edge of data block.
Shift + arrow key — select cells.
Ctrl + Shift + arrow key — select to edge of data block.
Home / End — to beginning/end of row.
Ctrl + Home / Ctrl + End — to beginning/end of sheet.
Page Up / Page Down — scroll page.
Alt + down arrow — open dropdown list in cell

Data Selection

Ctrl + A — select entire sheet (twice — all content).
Shift + Spacebar — select row.
Ctrl + Spacebar — select column.
Ctrl + Shift + Spacebar — select entire data area.

Editing and Data Entry

Enter — finish entry and move down.
Shift + Enter — finish entry and move up.
Tab / Shift + Tab — right/left.
Ctrl + ; — insert current date.
Ctrl + Shift + ; — insert current time.
Ctrl + Alt + Shift + ; — insert date and time.
F2 — edit cell content.
Esc — cancel entry.

Formatting

Bold/italic/underline: Ctrl + B / Ctrl + I / Ctrl + U
Strikethrough: Alt + Shift + 5 (Mac: ⌘ + Shift + X)
Add borders: Ctrl + Shift + 7
Remove borders: Ctrl + Shift + _
Number format: Ctrl + Shift + 1–6 (1 — standard, 2 — decimal, 3 — currency, 4 — percentage, 5 — date, 6 — time)
Align left/center/right: Ctrl + Shift + L / E / R
Text wrap: Ctrl + Shift + W

Working with Formulas

Start formula: =
Insert function: Shift + F3
Autosum: Alt + Shift + =
Show all formulas: Ctrl + ` (tilde)
Lock reference: F4
Calculate formula: Enter
Enter array formula: Ctrl + Shift + Enter

Working with Sheets

New sheet: Shift + F11
Rename sheet: Alt + Shift + H, then R
Navigate between sheets: Ctrl + Page Up / Ctrl + Page Down
Move sheet: Via keyboard through menu Alt + Shift + M

Filters and Sorting

Enable/disable filter: Ctrl + Shift + L
Open filter menu: Alt + down arrow
Sort ascending: Alt + Shift + ↑
Sort descending: Alt + Shift + ↓

Comments and Notes

Insert comment: Ctrl + Alt + M (Mac: ⌘ + ⌥ + M)
Open comment thread: Ctrl + Alt + Shift + A
Insert note: Shift + F2

Tools and Services

Open menu search: Alt + / (Mac: ⌥ + /)
Version history: Ctrl + Alt + Shift + H (Mac: ⌘ + ⌥ + Shift + H)
Spelling: Ctrl + Alt + X (Mac: ⌘ + ⌥ + X)
Chart: Alt + F1 — on current sheet, F11 — on separate sheet
Side tools panel: Ctrl + Alt + Shift + I

Accessibility

Enable screen reader support: Ctrl + Alt + Z (Mac: ⌘ + ⌥ + Z)
Navigation with audio: Ctrl + Alt + arrow key combinations for movement
Read selected: Ctrl + Alt + R

Conclusion

Google Sheets keyboard shortcuts allow you to speed up virtually all actions: from data entry to complex operations with formulas and filters. Recommended:

Master basic shortcuts (copy, paste, undo, cell navigation).
Make working with filters, formatting, and formulas without mouse a habit.
Use shortcuts for sheets and version history when collaborating.

Thanks to these combinations, you can work with Google Sheets spreadsheets at a professional level, saving time and reducing routine clicks.