Shortcut Keys for Google Sheets - Part 3

 Hello Friends,

This is Amey Kulkarni from Amey Knowledge Hub.

In this Blog I will Share Common Keyboard Short cut for Google Sheets. Google Sheets are the another version of Excel. These sheets automatically gets saved in Google Drive of your Google Account.

So Let's begin...

Navigate spreadsheet
Move to beginning 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	Alt + Down Arrow
Move to previous sheet	Alt + Up Arrow
Display list of sheets	Alt + Shift + k
Open hyperlink	Alt + Enter
Open Explore	Alt + Shift + x
Go to side panel	Ctrl + Alt + .
	Ctrl + Alt + ,
Move focus out of spreadsheet	Ctrl + Alt + Shift + m
Move to quick sum	Alt + Shift + q
(when a range of cells is selected)
Move focus to popup	holding Ctrl + Alt, press e then p
(for links, bookmarks, and images)
Open drop-down menu on filtered cell	Ctrl + Alt + r
Open revision history	Ctrl + Alt + Shift + h
Open chat inside the spreadsheet	Shift + Esc
Close drawing editor	Shift + Esc
Edit notes and comments
Insert/edit note	Shift + F2
Insert/edit comment	Ctrl + Alt + m
Open comment discussion thread	Ctrl + Alt + Shift + a
Enter current comment	holding Ctrl + Alt, press e then c
Move to next comment	holding Ctrl + Alt, press n then c
Move to previous comment	holding Ctrl + Alt, press p then c
Open a menu
File menu	in Google Chrome: Alt + f
	other browsers: Alt + Shift + f
Edit menu	in Google Chrome: Alt + e
	other browsers: Alt + Shift + e
View menu	in Google Chrome: Alt + v
	other browsers: Alt + Shift + v
Insert menu	in Google Chrome: Alt + i
	other browsers: Alt + Shift + i
Format menu	in Google Chrome: Alt + o
	other browsers: Alt + Shift + o
Data menu	in Google Chrome: Alt + d
	other browsers: Alt + Shift + d
Tools menu	in Google Chrome: Alt + t
	other browsers: Alt + Shift + t
Open insert menu	Ctrl + Alt + Shift + =
	Ctrl + Alt + =
	(with cells selected)
Open delete menu	Ctrl + Alt + - (with cells selected)
Form menu	in Google Chrome: Alt + m
(present when the spreadsheet is connected to a form)	other browsers: Alt + Shift + m
Add-ons menu	in Google Chrome: Alt + n
	other browsers: Alt + Shift + n
Help menu	in Google Chrome: Alt + h
	other browsers: Alt + Shift + h
Accessibility menu	in Google Chrome: Alt + a
(present when screen reader support is enabled)	other browsers: Alt + Shift + a
Sheet menu	Alt + Shift + s
(copy, delete, and other sheet actions)
Context menu	Ctrl + Shift + \
Add or change rows and columns
Insert rows above	Ctrl + Alt + Shift + =
	Ctrl + Alt + =
	(with rows selected)
	in Google Chrome: Alt + i, then r
	other browsers: Alt + Shift + i, then r
Insert rows below	in Google Chrome: Alt + i, then w
	other browsers: Alt + Shift + i, then w
Insert columns to the left	Ctrl + 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 right	in Google Chrome: Alt + i, then o
	other browsers: Alt + Shift + i, then o
Delete rows	Ctrl + Alt + - (with rows selected)
	in Google Chrome: Alt + e, then d
	other browsers: Alt + Shift + e, then d
Delete columns	Ctrl + Alt + - (with columns selected)
	in Google Chrome: Alt + e, then e
	other browsers: Alt + Shift + e, then e
Hide row	Ctrl + Alt + 9
Unhide row	Ctrl + Shift + 9
Hide column	Ctrl + Alt + 0
Unhide column	Ctrl + Shift + 0
Group rows or columns	Alt + Shift + Right Arrow
Ungroup rows or columns	Alt + Shift + Left Arrow
Expand grouped rows or columns	Alt + Shift + Down Arrow
Collapse grouped rows or columns	Alt + Shift + Up Arrow
Use formulas
Show all formulas	Ctrl + ~
Insert array formula	Ctrl + Shift + Enter
Collapse an expanded array formula	Ctrl + e
Show/hide formula help	Shift + F1
(when entering a formula)
Full/compact formula help	F1
(when entering a formula)
Absolute/relative references	F4
(when entering a formula)
Toggle formula result previews	F9
(when entering a formula)
Resize formula bar	Ctrl + Up / Ctrl + Down
(move up or down)
Help for screen readers
Turn on screen reader support	Ctrl + Alt + z
Enable braille support	Ctrl + Alt + h
Read column	Ctrl + Alt + Shift + c
Read row	Ctrl + Alt + Shift + r