Google Sheets Keyboard Shortcuts
Work faster in Google Sheets with essential shortcuts for editing, formulas, formatting, filters, and sheet navigation.
Navigation
Editing
Formatting
Selection & Sheets
Data & Formulas
Navigation
Editing
Formatting
Selection & Sheets
Data & Formulas
Google Sheets Shortcuts — Frequently Asked Questions
How do I see all shortcuts in Google Sheets?
Press Ctrl+/ on Windows or ChromeOS, and Cmd+/ on Mac, to open the full Google Sheets shortcuts panel.
What is the shortcut to paste values only in Google Sheets?
Use Ctrl+Shift+V on Windows/ChromeOS or Cmd+Shift+V on Mac to paste values only.
How do I insert a row or column in Google Sheets with the keyboard?
On Windows and ChromeOS press Alt then I then R to insert a row above, and Alt then I then C to insert a column to the left. On Mac the same sequence starts with Option: Option then I then R, or Option then I then C. These are menu-accelerator sequences, so press the keys one after another rather than together.
How do I create a filter in Google Sheets using a shortcut?
Select your data range and press Ctrl+Shift+L on Windows or ChromeOS, or Cmd+Shift+L on Mac, to toggle filters on and off. The same shortcut removes the filter when one is already applied.
How do I show formulas instead of results in Google Sheets?
Press Ctrl+` on Windows or ChromeOS, or Cmd+` on Mac, to toggle between showing formulas and showing calculated values across the whole sheet. Press the same keys again to switch back.
Are Google Sheets shortcuts the same as Excel shortcuts?
Many core keys match, including Ctrl+B for bold, Ctrl+C and Ctrl+V for copy and paste, and Ctrl+Arrow to jump to the edge of a data range. Sheets differs on browser-level keys and menu accelerators: it uses Alt or Option sequences instead of Excel's ribbon keytips, and Ctrl+/ opens the shortcut list rather than an Excel dialog. Sheets also lets you enable Excel-compatible shortcuts under Help > Keyboard shortcuts. Compare side by side with our Excel shortcuts guide.