Skip to content
CtrlKFind a shortcut

Google Sheet Shortcut Keys

WordGoogle SheetsChecked with GoogleChecked 2 Nov 2026

Show all shortcuts

Ctrl/

Paste values only

CtrlShiftV

Insert comment

CtrlAltM

Mac

Command/

These google sheet shortcut keys are checked against Google's own shortcut list for Windows. The most useful starting point is Ctrl + /, which shows every shortcut inside Sheets itself. After that, Ctrl + Shift + V pastes values only, Ctrl + Alt + M adds a comment, and Ctrl + Alt + = inserts rows or columns when they are selected.

Many Excel keys work in Sheets too, but some differ. For example, Ctrl + Shift + L aligns text left in Sheets rather than adding a filter. Mac users swap Ctrl for Command throughout.

Quick facts

  • Shortcut list

    Ctrl + /

  • Paste values

    Ctrl + Shift + V

  • Insert rows or columns

    Ctrl + Alt + =

  • Delete rows or columns

    Ctrl + Alt + Minus

  • Next and previous sheet

    Alt + Down, Alt + Up

  • Mac

    Command for Ctrl

Google sheet shortcut keys for editing

Editing keys
ActionKeys
Show the shortcut listCtrl + /
Paste values onlyCtrl + Shift + V
Insert commentCtrl + Alt + M
Insert linkCtrl + K
Insert today's dateCtrl + ;
Insert current timeCtrl + Shift + ;
FindCtrl + F
Find and replaceCtrl + H
UndoCtrl + Z
RedoCtrl + Y
Clear formattingCtrl + \

Rows, columns and sheets

Structure keys
ActionKeys
Select columnCtrl + Space
Select rowShift + Space
Insert rows or columns (selected)Ctrl + Alt + =
Delete rows or columns (selected)Ctrl + Alt + Minus
Hide rowCtrl + Alt + 9
Unhide rowCtrl + Shift + 9
Hide columnCtrl + Alt + 0
Unhide columnCtrl + Shift + 0
Next sheetAlt + Down
Previous sheetAlt + Up

Formatting keys

Format keys
ActionKeys
Bold, italic, underlineCtrl + B, Ctrl + I, Ctrl + U
StrikethroughAlt + Shift + 5
Align left, centre, rightCtrl + Shift + L, Ctrl + Shift + E, Ctrl + Shift + R
Outer borderCtrl + Shift + 7
Number formatCtrl + Shift + 1
Currency formatCtrl + Shift + 4
Percent formatCtrl + Shift + 5
The currency format uses the spreadsheet's locale. Set File, Settings, Locale to India to get the rupee sign and Indian digit grouping.

Shortcut for filter in Google Sheets

Google's list has no single key to create a filter. Use Data, then Create a filter, or the filter icon in the toolbar. Once a filter exists, select a header cell and press Ctrl + Alt + R to open its drop down menu. Many websites suggest Ctrl + Shift + L, but in Google Sheets that key aligns text to the left. Excel filter keys are covered separately in Excel filter shortcut.

When Sheets shortcuts do not work

Problems and fixes
ProblemFix
Browser does something elseThe browser grabbed the key; click inside the sheet first
Excel keys behave differentlyCheck the list with Ctrl + /
Compatible shortcutsTurn on Enable compatible spreadsheet shortcuts in the Ctrl + / panel for more Excel style keys
Mac keys differUse Command, and Option in place of Alt
A small business owner tracks orders in Google Sheets on her laptop. She pastes figures from emails with Ctrl + Shift + V so they keep the sheet's format, and inserts new rows with Ctrl + Alt + = as orders arrive.

Sheets on phones and tablets

Keyboard shortcuts work in Google Sheets in a computer browser. On phones and tablets, most of them only work if a physical keyboard is connected. Phone users rely on long press menus instead: long press a cell to copy, paste or insert rows. Editing large sheets is much faster on a laptop for this reason, so plan heavy data entry for a computer where these keys work.

Frequently asked questions

How do I see all Google Sheets shortcuts?

Press Ctrl + / inside a sheet.

How do I paste only values in Google Sheets?
Ctrl + Shift + V.
Is there a shortcut for filter in Google Sheets?

No single key creates one; use Data, Create a filter. Ctrl + Alt + R opens a filter menu.

How do I insert a row in Google Sheets?

Select a row and press Ctrl + Alt + =.

Do Excel shortcuts work in Google Sheets?

Many do, and you can enable compatible spreadsheet shortcuts for more.

How do I move to the next sheet?
Alt + Down.