40 keyboard shortcuts for Google Sheets


Do you use Google Sheets frequently? Here is the list of the most useful keyboard shortcuts to save time on a daily basis.

The list of the best keyboard shortcuts for Google Sheets. © sharafmaksumov – stock.adobe.com

10 essential Google Sheets keyboard shortcuts

  • Ctrl+Espace : select a column
  • Shift + Space: select a line
  • Ctrl+a : select all
  • Ctrl+z : cancel an action
  • Ctrl+y : repeat the previous action
  • Ctrl+f : find items in the worksheet
  • Ctrl+h : find and replace text
  • Ctrl+Maj+v : paste without formatting
  • Ctrl+Alt+v : paste only the format
  • Ctrl+/ : display common keyboard shortcuts

15 classic Google Sheets keyboard shortcuts you should know

  • Ctrl+o : open a document
  • May + F11: insert a sheet
  • Ctrl+c / Ctrl+v / Ctrl+x : copy / paste / cut
  • Ctrl+b / Ctrl+u / Ctrl+i : bold / underlined / italic
  • Alt + May + 5: strikethrough text
  • Ctrl+Maj+e / Ctrl+Maj+l / Ctrl+Maj+r : center / align left or right
  • Ctrl+k : insert link
  • Ctrl+s : save document
  • Ctrl+p : to print

10 Google Sheets keyboard shortcuts to make your navigation easier

  • Orig : reach the start of the line
  • Ctrl+Orig : reach the beginning of the leaf
  • End: reach the end of the line
  • Ctrl + Fin: reach the end of the sheet
  • Ctrl + Backspace: scroll the screen to the active cell
  • Alt + down arrow: go to the next sheet
  • Alt + up arrow: go to the previous sheet
  • Alt + May + k: display a list of all worksheets
  • Alt + Enter: open hyperlink
  • Alt + May + x: open the “Explore” panel

5 Google Sheets keyboard shortcuts to edit ratings and comments

  • May + F2: insert and edit a note
  • Ctrl+Alt+m : insert and modify a comment
  • Ctrl + Alt + May + a: open comments thread
  • Hold down the Ctrl + Alt keys, and press e, then c: open current comment
  • Hold down the Ctrl + Alt keys, and press n, then c: go to next comment

Note: Google also offers a help page with an exhaustive list of all the shortcuts possible on Google Sheets, whether on PC, Mac or mobile.

To read also
40 keyboard shortcuts for Excel

Receive all digital news by email


Categories:   General

Comments