Accessibility‎ > ‎

Google Spreadsheet Keyboard Shortcuts - Windows

To access menus:
Menu Name Shortcut for Chrome Shortcut for Internet Explorer or Firefox
Open File menu Alt+F Alt+Shift+F
Open Edit menu Alt+E Alt+Shift+E
Open View menu Alt+V Alt+Shift+V
Open Insert menu Alt+I Alt+Shift+I
Open Format menu Alt+O Alt+Shift+O
Open Data menu Alt+D Alt+Shift+D
Open Forms menu Alt+M Alt+Shift+M
Open Tools menu Alt+T Alt+Shift+T
Open Help menu Alt+H Alt+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  Ctrl+Shift+\ Ctrl+Shift+\
Show sheet list Alt+Shift+K Alt+Shift+K
Display sheet menu Alt+Shift+S Alt+Shift+S
 
To edit a spreadsheet:
Action Shortcut
Undo Ctrl+Z
Insert time Ctrl+Shift+:
Insert date Ctrl+;
Fill range Ctrl+Enter
Fill down Ctrl+D
Fill right Ctrl+R
Insert/edit comment Shift+F2
Redo Ctrl+Y
Edit a cell F2 or Enter
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 Ctrl+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 Ctrl+Home
Move to end of row End
Move to end of sheet Ctrl+End
Move to next sheet Ctrl+Shift+PageDown
Move to previous sheet Ctrl+Shfit+PageUp
Scroll to active cell Ctrl+Backspace

 

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

 

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

 

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

 

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