Accessibility‎ > ‎

Google Spreadsheet Keyboard Shortcuts - Mac

To access menus:
Menu Name Shortcut for Chrome Shortcut for Safari or Firefox
Open File menu Option+F Option+Shift+F
Open Edit menu Option+E Option+Shift+E
Open View menu Option+V Option+Shift+V
Open Insert menu Option+I Option+Shift+I
Open Format menu Option+O Option+Shift+O
Open Data menu Option+D Option+Shift+D
Open Forms menu Option+M Option+Shift+M
Open Tools menu Option+T Option+Shift+T
Open Help menu Option+H Option+Shift+H
Open any submenu Press the underlined letter in the menu; e.g., press S to insert a new sheet. Press the underlined letter in the menu; e.g., press S to insert a new sheet.
Show context menu  +Shift+\ +Shift+\
Show sheet list Option+Shift+K Option+Shift+K
Display sheet menu Option+Shift+S Option+Shift+S
To edit a spreadsheet:
Action Shortcut
Undo +Z
Insert time +Shift+:
Insert date +;
Fill range +Enter
Fill down +D
Fill right +R
Insert/edit comment Shift+F2
Redo +Y
Edit a cell Fn+F2
Ignore changes Escape


To navigate within a spreadsheet or between spreadsheets: 
Action Shortcut
Move among cells    Up, down, left, and right arrow keys
Move to the next cell that has data +any arrow key
Move up within a selected range Shift+Enter
Move down within a selected range Enter
Move left within a selected range Shift+Tab
Move right within a selected range Tab
Move to start of row Home
Move to beginning of sheet +Home
Move to end of row End
Move to end of sheet +End
Move to next sheet +Shift+PageDown
Move to previous sheet +Shfit+PageUp
Scroll to active cell +Backspace


To format a spreadsheet: 
Action Shortcut
Bold  +B
Underline +U
Italic +I
Strikethrough Option+Shift+5
Add outer border Option+Shift+7
Add right border Option+Shift+2
Add left border Option+Shift+4
Remove borders Option+Shift+6
Format number as currency +Shift+4
Format number as percentage +Shift+5
Format number as exponent +Shift+6
Format number as date +Shift+3
Format number as time +Shift+2
Format number as decimal +Shift+1


To select and insert text within a spreadsheet: 
Action Shortcut
Select column (does not work in Firefox or Internet Explorer) +Space
Select row Shift+Space
Select all +Shift+Space
Select a range of cells Shift+arrow keys
Select active region (does not work in Firefox or Internet Explorer) +Shift+8
Insert array formula +Shift+Enter


Miscellaneous commands: 
Action Shortcut
Chat Shift+Esc
Add new sheet Shift+F11
Find & replace +F
Save +S
Open +O
Make a copy +Shift+S
Print +P
Show all formulas +` (accent mark, not apostrophe)
Show/hide controls (toggle) +Shift+F
Open documentation in a new window Shift+F1
Show shortcuts help in a popup window +/


Your Input

Please use the form below to ask questions about topics that are not covered here, or to send new or corrected information.
Please note that your inquiry will be sent to the University of Michigan, not to Google.

If you wish to contact Google directly, we recommend using their accessibility feedback form or joining the Accessibility Google Group.

Accessibility Feedback