Skip to main content

Google sheets shortcut
































































































































































































































































































































































































































































Common actions
Select columnCtrl + Space
Select rowShift + Space
Select allCtrl + a
Ctrl + Shift + Space
UndoCtrl + z
RedoCtrl + y
Ctrl + Shift + z
F4
FindCtrl + f
Find and replaceCtrl + h
Fill rangeCtrl + Enter
Fill downCtrl + d
Fill rightCtrl + r
Save
(every change is saved automatically in Drive)
Ctrl + s
OpenCtrl + o
PrintCtrl + p
CopyCtrl + c
CutCtrl + x
PasteCtrl + v
Paste values onlyCtrl + Shift + v
Show common keyboard shortcutsCtrl + /
Insert new sheetShift + F11
Compact controlsCtrl + Shift + f
Input tools on/off
(available in spreadsheets in non-Latin languages)
Ctrl + Shift + k
Select input toolsCtrl + Alt + Shift + k
Format cells
BoldCtrl + b
UnderlineCtrl + u
ItalicCtrl + i
StrikethroughAlt + Shift + 5
Center alignCtrl + Shift + e
Left alignCtrl + Shift + l
Right alignCtrl + Shift + r
Apply top borderAlt + Shift + 1
Apply right borderAlt + Shift + 2
Apply bottom borderAlt + Shift + 3
Apply left borderAlt + Shift + 4
Remove bordersAlt + Shift + 6
Apply outer borderAlt + Shift + 7

Ctrl + Shift + 7
Insert linkCtrl + k
Insert timeCtrl + Shift + ;
Insert dateCtrl + ;
Insert date and timeCtrl + Alt + Shift + ;
Format as decimalCtrl + Shift + 1
Format as timeCtrl + Shift + 2
Format as dateCtrl + Shift + 3
Format as currencyCtrl + Shift + 4
Format as percentageCtrl + Shift + 5
Format as exponentCtrl + Shift + 6
Clear formattingCtrl + \
Navigate spreadsheet
Move to beginning of rowHome
Move to beginning of sheetCtrl + Home
Move to end of rowEnd
Move to end of sheetCtrl + End
Scroll to active cellCtrl + Backspace
Move to next sheetCtrl + Shift + Page Down
Move to previous sheetCtrl + Shift + Page Up
Display list of sheetsAlt + Shift + k
Open hyperlinkAlt + Enter
Open ExploreAlt + Shift + x
Move focus out of spreadsheetCtrl + Alt + Shift + m
Move to quicksum
(when a range of cells is selected)
Alt + Shift + q
Move focus to popup
(for links, bookmarks, and images)
holding Ctrl + Alt, press e then p
Open drop-down menu on filtered cellCtrl + Alt + r
Open revision historyCtrl + Alt + Shift + h
Open chat inside the spreadsheetShift + Esc
Close drawing editorShift + Esc
Edit notes and comments
Insert/edit noteShift + F2
Insert/edit commentCtrl + Alt + m
Open comment discussion threadCtrl + Alt + Shift + a
Enter current commentholding Ctrl + Alt, press e then c
Move to next commentholding Ctrl + Alt, press n then c
Move to previous commentholding Ctrl + Alt, press p then c
Open a menu
File menuin Google Chrome: Alt + f
other browsers: Alt + Shift + f
Edit menuin Google Chrome: Alt + e
other browsers: Alt + Shift + e
View menuin Google Chrome: Alt + v
other browsers: Alt + Shift + v
Insert menuin Google Chrome: Alt + i
other browsers: Alt + Shift + i
Format menuin Google Chrome: Alt + o
other browsers: Alt + Shift + o
Data menuin Google Chrome: Alt + d
other browsers: Alt + Shift + d
Tools menuin Google Chrome: Alt + t
other browsers: Alt + Shift + t
Open insert menuCtrl + Alt + Shift + =
Ctrl + Alt + = 

(with cells selected)
Open delete menuCtrl + Alt + - (with cells selected)
Form menu
(present when the spreadsheet is connected to a form)
in Google Chrome: Alt + m
other browsers: Alt + Shift + m
Add-ons menuin Google Chrome: Alt + n
other browsers: Alt + Shift + n
Help menuin Google Chrome: Alt + h
other browsers: Alt + Shift + h
Accessibility menu
(present when screen reader support is enabled)
in Google Chrome: Alt + a
other browsers: Alt + Shift + a
Sheet menu
(copy, delete, and other sheet actions)
Alt + Shift + s
Context menuCtrl + Shift + \
Insert, delete, hide, or unhide rows or columns
Insert rows aboveCtrl + Alt + Shift + =
Ctrl + Alt + =

(with rows selected)in Google Chrome: Alt + i, then r
other browsers: Alt + Shift + i, then r
Insert rows belowin Google Chrome: Alt + i, then w
other browsers: Alt + Shift + i, then w
Insert columns to the leftCtrl + Alt + Shift + =
Ctrl + Alt + = 

(with columns selected)in Google Chrome: Alt + i, then c
other browsers: Alt + Shift + i, then c
Insert columns to the rightin Google Chrome: Alt + i, then o
other browsers: Alt + Shift + i, then o
Delete rowsCtrl + Alt + - (with rows selected)

in Google Chrome: Alt + e, then d
other browsers: Alt + Shift + e, then d
Delete columnsCtrl + Alt + - (with columns selected)

in Google Chrome: Alt + e, then e
other browsers: Alt + Shift + e, then e
Hide rowCtrl + Alt + 9
Hide columnCtrl + Alt + 0
Unhide rowCtrl + Shift + 9
Unhide columnCtrl + Shift + 0
Use formulas
Show all formulasCtrl + ~
Insert array formulaCtrl + Shift + Enter
Collapse an expanded array formulaCtrl + e
Show/hide formula help
(when entering a formula)
Shift + F1
Full/compact formula help
(when entering a formula)
F1
Absolute/relative references
(when entering a formula)
F4
Toggle formula result previews
(when entering a formula)
F9
Resize formula bar
(move up or down)
Ctrl + Up / Ctrl + Down
Help for screen readers
Turn on screen reader support
Learn more about using Google Sheets with a screen reader
Ctrl + Alt + z
Read columnCtrl + Alt + Shift + c
Read rowCtrl + Alt + Shift + r

Comments

Popular posts from this blog

Saltstack and Vault integration

First install and configure vault using this tutorial: https://apassionatechie.wordpress.com/2017/03/05/hashicorp-vault/ Use the latest version of vault. Then install salt using the steps given here: https://docs.saltstack.com/en/latest/topics/installation/ If you face any issues then refer these links: https://apassionatechie.wordpress.com/2017/07/31/salt-issues/ https://apassionatechie.wordpress.com/2017/08/03/salt-stack-formulas/ Now let's integrate vault and salt so that we can access vault secrets from inside salt state. First let's add some key values into our vault. vault write secret/ssh/user1 password="abc123" Then you can check it by reading: vault read secret/ssh/user1 To allow salt to access your secrets you must firstly create a policy as follows: salt-policy.hcl [code] path "secret/*" { capabilities = ["read", "list"] } path "auth/*" { capabilities = ["read", "list","sudo",...

Salt stack issues

The function “state.apply” is running as PID Restart salt-minion with command:  service salt-minion restart No matching sls found for ‘init’ in env ‘base’ Add top.sls file in the directory where your main sls file is present. Create the file as follows: 1 2 3 base: 'web*' : - apache If the sls is present in a subdirectory elasticsearch/init.sls then write the top.sls as: 1 2 3 base: '*' : - elasticsearch.init How to execute saltstack-formulas create file  /srv/pillar/top.sls  with content: base : ' * ' : - salt create file  /srv/pillar/salt.sls  with content: salt : master : worker_threads : 2 fileserver_backend : - roots - git gitfs_remotes : - git://github.com/saltstack-formulas/epel-formula.git - git://github.com/saltstack-formulas/git-formula.git - git://github.com/saltstack-formulas/nano-formula.git - git://github.com/saltstack-f...

How to grep the output of cURL?

curl writes the output to stderr, so redirect that and also suppress the progress: curl - v -- silent https :// google . com / 2 >& 1 | grep expire The reason why  curl  writes the information to stderr is so you can do: curl <url> | someprgram  without that information clobbering the input of  someprogram It is possible to use  --stderr -  as parameter, to redirect the output from stderr (default) to stdout. With this option you also should use  --silent  to suppress the progress bar. $ curl - v -- silent https :// google . com / -- stderr - | grep expire * expire date : 2015 - 09 - 01 00 : 00 : 00 GMT