ExcelShortcutSheetWin · Mac · Printable

Google Sheets Shortcuts Cheat Sheet

Google Sheets has its own keyboard shortcuts, close to Excel's but not identical. Press Ctrl+/ on Windows or ChromeOS, or Command+/ on a Mac, to open Google's built-in list. The tables below cover the shortcuts you use most, with Windows, Mac and ChromeOS keys side by side.

Search inside this page with Ctrl+F (⌘+F on a Mac), or print it from your browser.

Common actions

ActionWindowsMacChromeOS
Show Google's shortcut listCtrl+/⌘+/Ctrl+/
Select columnCtrl+Space⌃+SpaceCtrl+Space
Select rowShift+SpaceShift+SpaceShift+Space
Select allCtrl+A⌘+ACtrl+A
UndoCtrl+Z⌘+ZCtrl+Z
RedoCtrl+Y or Ctrl+Shift+Z⌘+Y or ⌘+Shift+ZCtrl+Y or Ctrl+Shift+Z
FindCtrl+F⌘+FCtrl+F
Find and replaceCtrl+H⌘+Shift+HCtrl+H
Fill rangeCtrl+Enter⌘+EnterCtrl+Enter
Fill downCtrl+D⌘+DCtrl+D
Fill rightCtrl+R⌘+RCtrl+R
Copy / Cut / PasteCtrl+C / X / V⌘+C / X / VCtrl+C / X / V
Paste values onlyCtrl+Shift+V⌘+Shift+VCtrl+Shift+V
Insert new sheetShift+F11Shift+Fn+F11—
Convert range to tableCtrl+Alt+T⌘+⌥+TShift+Alt+T
PrintCtrl+P⌘+PCtrl+P

Format cells

ActionWindowsMacChromeOS
Bold / Italic / UnderlineCtrl+B / I / U⌘+B / I / UCtrl+B / I / U
StrikethroughAlt+Shift+5⌘+Shift+XAlt+Shift+5
Center alignCtrl+Shift+E⌘+Shift+ECtrl+Shift+E
Left alignCtrl+Shift+L⌘+Shift+LCtrl+Shift+L
Right alignCtrl+Shift+R⌘+Shift+RCtrl+Shift+R
Apply outer borderAlt+Shift+7⌥+Shift+7Alt+Shift+7
Remove bordersAlt+Shift+6⌥+Shift+6Alt+Shift+6
Insert linkCtrl+K⌘+KCtrl+K
Insert dateCtrl+;⌘+;Ctrl+;
Insert timeCtrl+Shift+;⌘+Shift+;Ctrl+Shift+;
Format as decimalCtrl+Shift+1⌃+Shift+1Ctrl+Shift+1
Format as dateCtrl+Shift+3⌃+Shift+3Ctrl+Shift+3
Format as currencyCtrl+Shift+4⌃+Shift+4Ctrl+Shift+4
Format as percentageCtrl+Shift+5⌃+Shift+5Ctrl+Shift+5
Clear formattingCtrl+\⌘+\Ctrl+\

Navigate

ActionWindowsMacChromeOS
Move to beginning of sheetCtrl+Home⌘+Fn+←Ctrl+Search+←
Move to end of sheetCtrl+End⌘+Fn+→Ctrl+Search+→
Scroll to active cellCtrl+Backspace⌘+BackspaceCtrl+Backspace
Next sheetAlt+↓⌥+↓Ctrl+Shift+Search+↓
Previous sheetAlt+↑⌥+↑Ctrl+Shift+Search+↑
Display list of sheetsAlt+Shift+K⌥+Shift+KAlt+Shift+K
Open hyperlinkAlt+Enter⌥+EnterAlt+Enter
Open drop-down menu on filtered cellCtrl+Alt+R⌃+⌘+RCtrl+Alt+R
Insert / edit noteShift+F2Shift+F2Shift+Search+2
Insert / edit commentCtrl+Alt+M⌘+⌥+MCtrl+Alt+M

Rows, columns & formulas

ActionWindowsMacChromeOS
Insert rows above (rows selected)Ctrl+Alt+=⌘+⌥+=Ctrl+Alt+=
Delete rows (rows selected)Ctrl+Alt+-⌘+⌥+-Ctrl+Alt+-
Hide rowCtrl+Alt+9⌘+⌥+9Ctrl+Alt+9
Unhide rowCtrl+Shift+9⌘+Shift+9Ctrl+Shift+9
Hide columnCtrl+Alt+0⌘+⌥+0Ctrl+Alt+0
Unhide columnCtrl+Shift+0⌘+Shift+0Ctrl+Shift+0
Group rows or columnsAlt+Shift+→⌥+Shift+→Alt+Shift+→
Ungroup rows or columnsAlt+Shift+←⌥+Shift+←Alt+Shift+←
Show all formulasCtrl+~⌃+~Ctrl+~
Absolute / relative references (in a formula)F4Fn+F4Search+4
Insert array formulaCtrl+Shift+Enter⌘+Shift+EnterCtrl+Shift+Enter

Excel vs Sheets: shortcuts that differ (Windows)

ActionExcelGoogle Sheets
StrikethroughCtrl+5Alt+Shift+5
Show formulasCtrl+`Ctrl+~
Next / previous sheetCtrl+Page Down / Ctrl+Page UpAlt+↓ / Alt+↑
Hide rowCtrl+9Ctrl+Alt+9
Hide columnCtrl+0Ctrl+Alt+0
Insert rows (rows selected)Ctrl+Shift++Ctrl+Alt+=
Delete rows (rows selected)Ctrl+-Ctrl+Alt+-
Create a tableCtrl+TCtrl+Alt+T
Clear formattingAlt+H, E, FCtrl+\
Paste values onlyCtrl+Shift+V (Microsoft 365) or Ctrl+Alt+V, VCtrl+Shift+V

Tip: in Google Sheets you can turn on compatible spreadsheet shortcuts in the keyboard shortcuts dialog (Ctrl+/), so more Excel habits carry over.

FAQ

How do I see all keyboard shortcuts in Google Sheets?

Press Ctrl+/ on Windows or ChromeOS, or Command+/ on a Mac, to open Google Sheets' built-in shortcut list. You can search it by action. In Settings you can also turn on compatible spreadsheet shortcuts, so familiar Excel combinations behave more like they do in Microsoft Excel.

Do Excel shortcuts work in Google Sheets?

Many do, such as Ctrl+C, Ctrl+V, Ctrl+Z, Ctrl+B and Ctrl+Shift+V for paste values. Others differ: strikethrough is Alt+Shift+5 in Sheets but Ctrl+5 in Excel, and hiding a row is Ctrl+Alt+9 instead of Ctrl+9. The table of differences on this page lists the common ones.

What is the Google Sheets shortcut to paste values only?

Press Ctrl+Shift+V on Windows and ChromeOS, or Command+Shift+V on a Mac. It pastes the values without formatting or formulas. In Excel for Microsoft 365 on Windows the same Ctrl+Shift+V combination also pastes values, so the habit carries over between the two apps.

Back to the Excel shortcuts cheat sheet · Excel Paste Special shortcuts

Source: Google Docs Editors Help, Keyboard shortcuts for Google Sheets (PC, Mac and Chrome OS tabs), checked October 20, 2026. Not affiliated with Google. This page is a companion to Excel Shortcut Sheet.

Last updated: