Wednesday, 29 October 2014

Popular keyboard shortcuts for Gsheet

Popular keyboard shortcuts for Gsheet
Editing
Undo
Ctrl + Z
Insert time
Ctrl + Shift + ;
Insert date
Ctrl + ;
Fill range
Ctrl + Enter
Fill down
Ctrl + D
Fill right
Ctrl + R
Insert/edit note
Shift + F2
Insert/edit comment
Ctrl + Alt + M
Redo
Ctrl + Y
Absolute/relative references
F4
Input tools on/off
Ctrl + Shift + K
Select input tools
Ctrl + Alt + Shift + K
Movement
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
Scroll to active cell
Ctrl + Backspace
Move to next sheet
Ctrl + Shift + PageDown
Move to previous sheet
Ctrl + Shift + PageUp
Find
Ctrl + F
Find and replace
Ctrl + H
Menus
Show context menu
Ctrl + Shift + \
File Menu
Alt + F
Edit Menu
Alt + E
View Menu
Alt + V
Insert Menu
Alt + I
Format Menu
Alt + O
Data Menu
Alt + D
Form Menu
Alt + M
Tools Menu
Alt + T
Add-ons Menu
Alt + N
Help Menu
Alt + H
Accessibility Menu
Alt + A
Show sheet list
Alt + Shift + K
Display sheet menu
Alt + Shift + S
Formatting
Bold
Ctrl + B
Underline
Ctrl + U
Italic
Ctrl + I
Strikethrough
Alt + Shift + 5
Align center
Ctrl + Shift + E
Align left
Ctrl + Shift + L
Align right
Ctrl + Shift + R
Apply top border
Alt + Shift + 1
Apply right border
Alt + Shift + 2
Apply bottom border
Alt + Shift + 3
Apply left border
Alt + Shift + 4
Remove borders
Alt + Shift + 6
Apply outer border
Alt + Shift + 7
Format as decimal
Ctrl + Shift + 1
Format as time
Ctrl + Shift + 2
Format as date
Ctrl + Shift + 3
Format as currency
Ctrl + Shift + 4
Format as percentage
Ctrl + Shift + 5
Format as exponent
Ctrl + Shift + 6
Selection
Select column
Ctrl + Space
Select row
Shift + Space
Select all
Ctrl + A
Select active region
Ctrl + Shift + 8
Screenreader
Read column
Ctrl + Alt + Shift + C
Read row
Ctrl + Alt + Shift + R
Insertion
Insert array formula
Ctrl + Shift + Enter
Add new sheet
Shift + F11
File Commands
Open
Ctrl + O
Print
Ctrl + P
View
Show all formulas
Ctrl + `
Compact controls
Ctrl + Shift + F
Navigation
Move to top of application
Ctrl + Alt + Shift + M
Chat
Shift + Esc
Open hyperlink
Alt + Enter
Revisions
Ctrl + Alt + Shift + G
Focus quicksum
Alt + Shift + Q
Focus pop up
Ctrl + Alt + E then Ctrl + Alt + P
Open filter dropdown menu
Ctrl + Alt + R
Help
Open documentation (new window)
Shift + F1
Show shortcuts help popup
Ctrl + /
Enable screen reader support
Ctrl + Alt + Z


No comments:

Post a Comment