Google Sheets Keyboard Shortcuts (Windows, Mac & Chromebook)
Every Google Sheets shortcut for Windows, Mac and Chromebook, with a note wherever Excel uses different keys.
Google Sheets keyboard shortcuts — freetoolsforweb.com
Last verified: against Google Docs Editors Help (PC, Mac and Chrome OS tables). 126 shortcuts.
- Press Control plus slash (⌘/ on a Mac) inside any spreadsheet to see Google’s own list.
- Coming from Excel? In Sheets, open Help > Keyboard shortcuts and turn on Enable compatible spreadsheet shortcuts to use shortcuts from other spreadsheet apps. Rows below marked “Excel:” show where Excel’s default keys differ.
- On a Chromebook, Search or Launcher key is the Search or Launcher key; it stands in for Home, End and the F-keys.
Showing all 126 shortcuts in 8 categories
Common actions#
| Action | Windows | Mac | Chromebook | Copy |
|---|---|---|---|---|
| Show the list of keyboard shortcuts | Control plus slash | Command plus slash | Control plus slash | |
| Tool finder (search the menus)Excel: Alt+Q jumps to the ribbon Search box. | Alt plus slash | Option plus slash | Alt plus slash | |
| Select column | Control plus Space bar | Control plus Space bar | Control plus Space bar | |
| Select row | Shift plus Space bar | Shift plus Space bar | Shift plus Space bar | |
| Select all | Control plus Aor Control plus Shift plus Space bar | Command plus Aor Shift plus Command plus Space bar | Control plus A | |
| Select the current region around the selected cell | No default shortcut | Shift plus Command plus asteriskor Control plus Shift plus asterisk | No default shortcut | |
| Undo | Control plus Z | Command plus Z | Control plus Z | |
| Redo | Control plus Yor Control plus Shift plus Zor F4 | Command plus Yor Shift plus Command plus Zor Fn or Globe plus F4 | Control plus Yor Control plus Shift plus Z | |
| Find | Control plus F | Command plus F | Control plus F | |
| Find and replace | Control plus H | Shift plus Command plus H | Control plus H | |
| Find and replace, opened on the Find tab | No default shortcut | Control plus F | No default shortcut | |
| Show the "Go to range" dialog | No default shortcut | Control plus G | No default shortcut | |
| Fill range (enter the value in every selected cell) | Control plus Enter | Command plus Enter | Control plus Enter | |
| Fill down | Control plus D | Command plus D | Control plus D | |
| Fill right | Control plus R | Command plus R | Control plus R | |
| Save (changes save automatically to Drive) | Control plus S | Command plus S | Control plus S | |
| Open | Control plus O | Command plus O | Control plus O | |
| Control plus P | Command plus P | Control plus P | ||
| Copy | Control plus C | Command plus C | Control plus C | |
| Cut | Control plus X | Command plus X | Control plus X | |
| Paste | Control plus V | Command plus V | Control plus V | |
| Paste values onlyExcel: Ctrl+Alt+V, then V, then Enter (Paste Special > Values) on Windows. | Control plus Shift plus V | Shift plus Command plus V | Control plus Shift plus V | |
| Insert new sheet | Shift plus F11 | Fn or Globe plus Shift plus F11 | No default shortcut | |
| Rename sheet | Alt plus 1 | No default shortcut | No default shortcut | |
| Compact controls (hide the menus) | Control plus Shift plus F | Control plus Shift plus F | Control plus Shift plus F | |
| Show or hide the menus | No default shortcut | Option plus Command plus R | No default shortcut | |
| Turn input tools on or off (non-Latin languages) | Control plus Shift plus K | Shift plus Command plus K | Control plus Shift plus K | |
| Select input tools | Control plus Alt plus Shift plus K | Option plus Shift plus Command plus K | Control plus Alt plus Shift plus K | |
| Convert range to tableExcel: Ctrl+T (Windows) or Cmd+T (Mac) creates a table. | Control plus Alt plus T | Option plus Command plus T | Shift plus Alt plus T |
Format cells#
| Action | Windows | Mac | Chromebook | Copy |
|---|---|---|---|---|
| Bold | Control plus B | Command plus Bor Command plus 2or Control plus 2 | Control plus B | |
| Underline | Control plus U | Command plus Uor Command plus 4or Control plus 4 | Control plus U | |
| Italic | Control plus I | Command plus Ior Command plus 3or Control plus 3 | Control plus I | |
| StrikethroughExcel: Ctrl+5 on Windows, Cmd+Shift+X on Mac. | Alt plus Shift plus 5 | Shift plus Command plus Xor Command plus 5or Control plus 5 | Alt plus Shift plus 5 | |
| Center alignExcel: Alt+H, A, C on Windows; Cmd+E on Mac. | Control plus Shift plus E | Shift plus Command plus E | Control plus Shift plus E | |
| Left alignExcel: Ctrl+Shift+L toggles filters in Excel, not alignment. | Control plus Shift plus L | Shift plus Command plus L | Control plus Shift plus L | |
| Right align | Control plus Shift plus R | Shift plus Command plus R | Control plus Shift plus R | |
| Apply top border | Alt plus Shift plus 1 | Option plus Shift plus 1 | Alt plus Shift plus 1 | |
| Apply right border | Alt plus Shift plus 2 | Option plus Shift plus 2 | Alt plus Shift plus 2 | |
| Apply bottom border | Alt plus Shift plus 3 | Option plus Shift plus 3 | Alt plus Shift plus 3 | |
| Apply left border | Alt plus Shift plus 4 | Option plus Shift plus 4 | Alt plus Shift plus 4 | |
| Remove bordersExcel: Ctrl+Shift+_ (Windows), Cmd+Option+- (Mac). | Alt plus Shift plus 6 | Option plus Shift plus 6 | Alt plus Shift plus 6 | |
| Apply outer borderExcel: Ctrl+Shift+& (the same keys as Ctrl+Shift+7) on Windows; Cmd+Option+0 on Mac. | Alt plus Shift plus 7or Control plus Shift plus 7 | Option plus Shift plus 7or Shift plus Command plus 7or Control plus Shift plus 7 | Alt plus Shift plus 7or Control plus Shift plus 7 | |
| Insert link | Control plus K | Command plus K | Control plus K | |
| Insert the current timeExcel: Ctrl+Shift+: on Windows (the same keys); Cmd+; on Mac. | Control plus Shift plus semicolonIn Portugal, Italy, Germany and Spain: Ctrl+Shift+H. | Shift plus Command plus semicolonIn Portugal, Italy, Germany and Spain: Ctrl+Shift+H. | Control plus Shift plus semicolon | |
| Insert today’s dateExcel: Ctrl+; on both Windows and Mac. On a Mac, Cmd+; inserts the time in Excel. | Control plus semicolonIn Portugal, Italy, Germany and Spain: Ctrl+Shift+D. | Command plus semicolonIn Portugal, Italy, Germany and Spain: Ctrl+Shift+D. | Control plus semicolon | |
| Insert date and time | Control plus Alt plus Shift plus semicolonIn Portugal, Italy, Germany and Spain: Ctrl+Alt+Shift+N. | Option plus Shift plus Command plus semicolonIn Portugal, Italy, Germany and Spain: Ctrl+Option+Shift+N. | Control plus Alt plus Shift plus semicolon | |
| Format as decimal (number)Excel: Ctrl+Shift+! – the same keys. | Control plus Shift plus 1 | Control plus Shift plus 1 | Control plus Shift plus 1 | |
| Format as timeExcel: Ctrl+Shift+@ – the same keys. | Control plus Shift plus 2 | Control plus Shift plus 2 | Control plus Shift plus 2 | |
| Format as dateExcel: Ctrl+Shift+# – the same keys. | Control plus Shift plus 3 | Control plus Shift plus 3 | Control plus Shift plus 3 | |
| Format as currencyExcel: Ctrl+Shift+$ – the same keys. | Control plus Shift plus 4 | Control plus Shift plus 4 | Control plus Shift plus 4 | |
| Format as percentageExcel: Ctrl+Shift+% – the same keys. | Control plus Shift plus 5 | Control plus Shift plus 5 | Control plus Shift plus 5 | |
| Format as exponent (scientific)Excel: Ctrl+Shift+^ – the same keys. | Control plus Shift plus 6 | Control plus Shift plus 6 | Control plus Shift plus 6 | |
| Clear formatting | Control plus backslash | Command plus backslash | Control plus backslash |
Add, hide and group rows and columns#
| Action | Windows | Mac | Chromebook | Copy |
|---|---|---|---|---|
| Insert rows aboveExcel: Ctrl+Shift+Plus (Windows), Ctrl+Shift+= (Mac). Ctrl+Alt+= (Cmd+Option+= on Mac) works with whole rows selected. | Control plus Alt plus equalsor Alt plus I then R then RIn browsers other than Chrome: Alt+Shift+I, then R, then R. | Option plus Command plus equalsor Control plus Option plus I then R then R | Control plus Alt plus equalsor Alt plus I then R then R | |
| Insert rows below | Alt plus I then R then BIn browsers other than Chrome: Alt+Shift+I, then R, then B. | Control plus Option plus I then R then B | Alt plus I then R then B | |
| Insert columns to the leftCtrl+Alt+= (Cmd+Option+= on Mac) works with whole columns selected. | Control plus Alt plus equalsor Alt plus I then C then CIn browsers other than Chrome: Alt+Shift+I, then C, then C. | Option plus Command plus equalsor Control plus Option plus I then C then C | Control plus Alt plus equalsor Alt plus I then C then C | |
| Insert columns to the right | Alt plus I then C then OIn browsers other than Chrome: Alt+Shift+I, then C, then O. | Control plus Option plus I then C then O | Alt plus I then C then O | |
| Delete rowsExcel: Ctrl+- (Windows), Cmd+- (Mac). Ctrl+Alt+- (Cmd+Option+- on Mac) works with whole rows selected. | Control plus Alt plus hyphenor Alt plus E then D then DIn browsers other than Chrome: Alt+Shift+E, then D, then D. | Option plus Command plus hyphenor Control plus Option plus E then D then D | Control plus Alt plus hyphenor Alt plus E then D then D | |
| Delete columnsCtrl+Alt+- (Cmd+Option+- on Mac) works with whole columns selected. | Control plus Alt plus hyphenor Alt plus E then D then EIn browsers other than Chrome: Alt+Shift+E, then D, then E. | Option plus Command plus hyphenor Control plus Option plus E then D then E | Control plus Alt plus hyphenor Alt plus E then D then E | |
| Hide rowExcel: Ctrl+9. | Control plus Alt plus 9 | Option plus Command plus 9 | Control plus Alt plus 9 | |
| Unhide row | Control plus Shift plus 9 | Shift plus Command plus 9 | Control plus Shift plus 9 | |
| Hide columnExcel: Ctrl+0. | Control plus Alt plus 0 | Option plus Command plus 0 | Control plus Alt plus 0 | |
| Unhide column | Control plus Shift plus 0 | Shift plus Command plus 0 | Control plus Shift plus 0 | |
| Group rows or columns | Alt plus Shift plus Right arrow | Option plus Shift plus Right arrow | Alt plus Shift plus Right arrow | |
| Ungroup rows or columns | Alt plus Shift plus Left arrow | Option plus Shift plus Left arrow | Alt plus Shift plus Left arrow | |
| Expand grouped rows or columns | Alt plus Shift plus Down arrow | Option plus Shift plus Down arrow | Alt plus Shift plus Down arrow | |
| Collapse grouped rows or columns | Alt plus Shift plus Up arrow | Option plus Shift plus Up arrow | Alt plus Shift plus Up arrow |
Formulas#
| Action | Windows | Mac | Chromebook | Copy |
|---|---|---|---|---|
| Show all formulasExcel: Ctrl+` (grave accent). | Control plus tilde | Control plus tilde | Control plus tilde | |
| Insert array formula | Control plus Shift plus Enter | Shift plus Command plus Enter | Control plus Shift plus Enter | |
| Collapse an expanded array formula | Control plus E | Command plus E | Control plus E | |
| Show or hide formula help (while typing a formula) | Shift plus F1 | Fn or Globe plus Shift plus F1 | Shift plus Search or Launcher key plus 1 | |
| Full or compact formula help (while typing a formula) | F1 | Fn or Globe plus F1 | Search or Launcher key plus 1 | |
| Toggle absolute/relative references (while typing a formula) | F4 | Fn or Globe plus F4 | Search or Launcher key plus 4 | |
| Toggle formula result previews (while typing a formula) | F9 | Fn or Globe plus F9 | Search or Launcher key plus 9 | |
| Resize the formula bar (up or down) | Control plus Up arrowor Control plus Down arrow | Control plus Option plus Up arrowor Control plus Option plus Down arrow | Control plus Shift plus Up arrowor Control plus Shift plus Down arrow | |
| Toggle formula range selection (while typing a formula) | F2or Control plus E | F2or Control plus E | F2or Control plus E |
Screen reader help#
| Action | Windows | Mac | Chromebook | Copy |
|---|---|---|---|---|
| Turn on screen reader support | Control plus Alt plus Z | Option plus Command plus Z | Control plus Alt plus Z | |
| Turn on braille support | Control plus Alt plus H | Option plus Command plus H | Control plus Alt plus H | |
| Read column | Control plus Alt plus Shift plus C | Option plus Shift plus Command plus C | Control plus Alt plus Shift plus C | |
| Read row | Control plus Alt plus Shift plus R | Option plus Shift plus Command plus R | Control plus Alt plus Shift plus R |
Sources (2 official pages)
Everything runs in your browser; searches are not sent anywhere. Shortcuts are checked against Google Docs Editors Help. Browse all free tools.
Found a problem, or something that could be better? We read every message and we fix things quickly.
This Google Sheets shortcuts cheat sheet lists every keyboard shortcut Google documents for Sheets, with the Windows, Mac and Chromebook keys in one table: Ctrl+Shift+V to paste values only, Alt+Shift+5 for strikethrough, Ctrl+Alt+M for a comment, Alt+Down Arrow to jump to the next sheet. If you come from Excel, the notes on each row show where Excel uses different keys, so you don't have to learn by trial and error.
The list was checked on 2026-10-18 against Google's "Keyboard shortcuts for Google Sheets" help page, which has separate tables for PC, Mac and Chrome OS. Google writes the menu shortcuts for Chrome (Alt+F for File) and notes that other browsers need Alt+Shift; both are shown. Some shortcuts depend on your keyboard language; the date and time ones, for example, change in Portugal, Italy, Germany and Spain.
How to use
- Find your system's column: Windows, Mac or Chromebook.
- Search by what you want to do ("hide row", "comment") or by keys ("ctrl alt 9").
- Read the "Excel:" note on a row to see how the same action works in Excel.
- Click Copy to copy a shortcut, or the action name to share a link to it.
- Use "Print / Save as PDF" for a paper copy.
Frequently asked questions
How do I see all keyboard shortcuts in Google Sheets?
Press Ctrl+/ on Windows or a Chromebook, or Cmd+/ on a Mac, while a spreadsheet is open. Sheets shows its shortcut list, which you can search. Alt+/ (Option+/ on Mac) opens the Tool finder, where you can type the name of any menu command.
Can I use Excel shortcuts in Google Sheets?
Partly. Many basics are the same (Ctrl+C, Ctrl+Z, Ctrl+D, F4, Ctrl+Shift+4 for currency). For the rest, open Help > Keyboard shortcuts in Sheets and turn on "Enable compatible spreadsheet shortcuts", which lets Sheets accept shortcuts from other spreadsheet programs. The "Excel:" notes on this page show where the default keys differ.
What is the shortcut to paste values only in Google Sheets?
Ctrl+Shift+V on Windows and Chromebook, Cmd+Shift+V on a Mac. It pastes the values without formulas or formatting. Excel has no single key for this; there you open Paste Special with Ctrl+Alt+V and press V.
How do I switch between sheets (tabs) with the keyboard?
Alt+Down Arrow moves to the next sheet and Alt+Up Arrow to the previous one on Windows. On a Mac use Option+Down and Option+Up (Option+Right and Option+Left on a MacBook). On a Chromebook use Ctrl+Shift+Search+Down or Up. Alt+Shift+K (Option+Shift+K on Mac) shows a list of all sheets.
What is the strikethrough shortcut in Google Sheets?
Alt+Shift+5 on Windows and Chromebook. On a Mac, Cmd+Shift+X, Cmd+5 or Ctrl+5 all work. In Excel the Windows shortcut is Ctrl+5 instead.
How do I insert today's date or the current time?
Ctrl+; inserts today's date and Ctrl+Shift+; the current time (Cmd+; and Cmd+Shift+; on a Mac). Ctrl+Alt+Shift+; inserts both. In Portugal, Italy, Germany and Spain Google uses Ctrl+Shift+D, Ctrl+Shift+H and Ctrl+Alt+Shift+N instead.
Google Sheets vs Excel: the shortcuts that differ
Most editing keys match, but these trip up people who switch between the two:
• Paste values: Ctrl+Shift+V in Sheets; Ctrl+Alt+V, V, Enter in Excel.
• Next / previous sheet: Alt+Down / Alt+Up in Sheets; Ctrl+Page Down / Page Up in Excel. In Excel, Alt+Down opens a drop-down instead.
• Hide rows and columns: Ctrl+Alt+9 and Ctrl+Alt+0 in Sheets; Ctrl+9 and Ctrl+0 in Excel. Unhiding is Ctrl+Shift+9 / 0 in both.
• Strikethrough: Alt+Shift+5 in Sheets; Ctrl+5 in Excel.
• Alignment: Ctrl+Shift+L / E / R align left, center, right in Sheets. In Excel, Ctrl+Shift+L toggles filters.
• Comments: Ctrl+Alt+M in Sheets; Ctrl+Shift+F2 in Excel. Notes are Shift+F2 in both.
• Alt+Enter: opens a link in Sheets, but starts a new line inside the cell in Excel.
• Number formats: Sheets uses Ctrl+Shift+1 to 6, which are physically the same keys as Excel's Ctrl+Shift+! @ # $ % ^, and they do the same things.
Menu shortcuts in Chrome, other browsers and on a Mac
Google Sheets runs in a browser, and browsers reserve some Alt keys for themselves. In Chrome on Windows, Alt plus a letter opens a Sheets menu: Alt+F File, Alt+E Edit, Alt+V View, Alt+I Insert, Alt+O Format, Alt+D Data, Alt+T Tools, Alt+N Extensions, Alt+H Help. In Firefox, Edge and other browsers, add Shift (Alt+Shift+F).
On a Mac the menus use Ctrl+Option plus the same letter (Ctrl+Option+I for Insert). Chaining letters works like a path through the menu: Alt+I, then R, then R inserts a row above, and Alt+E, then D, then D deletes the row.
Google Sheets on a Chromebook
Chromebook keyboards have no Home, End or F-keys, so Google maps them to the Search (Launcher) key: Search+Left and Search+Right go to the start and end of a row, Ctrl+Search+Left jumps to the top of the sheet, and Search+4 is the F4 key for toggling $ references while you write a formula. Switching sheets needs Ctrl+Shift+Search with the Up or Down arrow.
Everything else in the Chromebook column matches Windows. For system-wide Chromebook shortcuts (screenshots, Caps Lock, desks) see the Chromebook shortcuts cheat sheet.
Related free tools
- Excel Shortcuts — Every Excel shortcut for Windows and Mac side by side: navigation, formatting, formulas, Paste Special and Alt key tips.
- Chromebook Shortcuts — Every ChromeOS shortcut: screenshots, Caps Lock, snapping windows, desks, text editing and the Search key explained.
- Percentage Calculator — Every common percentage question on one page, each showing the formula with your numbers. Plus fraction ↔ decimal ↔ percent.
- Online Calculator — A clean, iPhone-style calculator that works with your keyboard and numpad. Percent, sign, history, copy — no ads, nothing installed.
- Mac Keyboard Shortcuts — Every macOS shortcut with ⌘ ⌥ ⌃ ⇧ symbols explained: screenshots, window tiling, Finder, Safari and special characters.
Notes and comments#