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

First published at 3/20/2018 on
https://defkey.com/google-sheets-mac-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
Shift + Space           Select row
Cmd + A                 Select all
Fn + F4                 Redo
Cmd + Enter             Fill range
Cmd + R                 Fill right
Cmd + Shift + V         Paste values only


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

Cmd + Shift + R         Right align
Option + Shift + 4      Apply left border
Option + Shift + 7      Apply outer border
Cmd + K                 Insert link
Cmd + ;                 Insert date
Ctrl + Shift + 6        Format as exponent


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

Cmd + Fn + Left arrow   Move to beginning of sheet


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

Ctrl + Option + I then R (with rows selected) Insert rows above
Cmd + Option + -        (with rows selected) Delete rows


Use formulas
------------

Ctrl + ~                Show all formulas
Fn + F1                 (when entering a formula) Full / compact formula help
Fn + F4                 (when entering a formula) Absolute/relative references
Fn + F9                 (when entering a formula) Toggle formula result previews


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

Source: Google Sheets support page


Last modified on (UTC): Friday, January 17, 2020
Defkey © All rights reserved.