===========================================
Google Sheets keyboard shortcuts (filtered)
===========================================

First published at 3/18/2018 on https://defkey.com/google-sheets-shortcuts

Google Sheets is a spreadsheet program developed by Google. Its offered in
Google Drive service, together with Docs and Slides. Sheets allows users to
create and edit files online while collaboration with other users in real time.



Common actions
--------------

Ctrl + Space            Select column
Ctrl + H                Find and replace
Ctrl + Enter            Fill range
Ctrl + D                Fill down
Ctrl + Shift + V        Paste values only


Format cells
------------

Ctrl + U                Underline
Alt + Shift + 5         Strikethrough
Ctrl + Shift + ;        Insert time
Ctrl + ;                Insert date
Ctrl + Alt + Shift + ;  Insert date and time


Navigate spreadsheet
--------------------

Ctrl + Backspace        Scroll to active cell
Alt + Shift + X         Open Explore
Alt + Shift + Q         Move to quicksum (when a range of cells is selected)
Ctrl + Alt + R          Open drop-down menu on filtered cell
Ctrl + Alt + Shift + H  Open revision history


Open a menu
-----------

Ctrl + Alt + -          (with cells selected)  Open delete menu
Alt + Shift + N         (in other browsers) Add-ons menu


Insert, delete, hide, or unhide rows or columns
-----------------------------------------------

Ctrl + Alt + =          (with rows selected) Insert rows above
Alt + I then R          (in Google Chrome) Insert rows above
Alt + Shift + I then R  (in other browsers) Insert rows above


Help for screen readers
-----------------------

Source: Google Sheets support page


Last modified on (UTC): Saturday, March 7, 2020
Defkey © All rights reserved.