Google Sheets is as a powerful online spreadsheet application and has indeed revolutionized the way people use spreadsheets for their work. Google sheets has replace traditional offline software such as Excel in several niche domains. For teachers Google Sheets is a versatile tool that holds significant importance in various aspects of one’s work – management, grading, visualization, charting, attendance tracking, and so on.

Solution providers such as Gibbon do provide automations for the above listed tasks, but still educators must learn few important keyboard shortcuts for google sheets to speed up their work. To complement our important Google Doc Important Shortcuts, and Keyboard Shortcuts for Google Slides, important Google Sheet shortcuts are given below.

#1 Google Sheet Keyboard Shortcuts for Windows

Teachers who are using Windows operating system must refer to these Google Sheet shortcuts:

Most Used Google Sheet Shortcuts

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
SaveCtrl + 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/offCtrl + Shift + k
Select input toolsCtrl + Alt + Shift + k
Tool finder Alt + /
Rename sheetAlt + 1
Hurry! Book a FREE Demo

Most Used Google Sheet Shortcuts for Formatting 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 + 7Ctrl + 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 + \

Google Sheet Shortcuts for Navigating Spreadsheets

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 sheetAlt + Down Arrow
Move to previous sheetAlt + Up Arrow
Display list of sheetsAlt + Shift + k
Open hyperlinkAlt + Enter
Open ExploreAlt + Shift + x
Go to side panelCtrl + Alt + .
Ctrl + Alt + ,
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
Close drawing editorShift + Esc
Hurry! Book a FREE Demo

Google Sheet Shortcuts for 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 + \
Shift + F10

Google Sheet Shortcuts for Rows and Columns

nsert 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
Unhide rowCtrl + Shift + 9
Hide columnCtrl + Alt + 0
Unhide columnCtrl + Shift + 0
Group rows or columnsAlt + Shift + Right Arrow
Ungroup rows or columnsAlt + Shift + Left Arrow
Expand grouped rows or columnsAlt + Shift + Down Arrow
Collapse grouped rows or columnsAlt + Shift + Up Arrow
Hurry! Book a FREE Demo

#2 Google Sheet Keyboard Shortcuts for Android

For teachers who are using Android phones or tablets, the Google Sheet keyboard shortcuts are as follows:

Most Used Google Sheet Shortcuts

ActionShortcut
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
PrintCtrl + p
CopyCtrl + c
CutCtrl + x
PasteCtrl + v
Paste values onlyCtrl + Shift + v
Paste format onlyCtrl + Alt + v
Show common keyboard shortcutsCtrl + /
Insert new sheetCtrl + t
Shift + F11
Move to sheet at index #Ctrl + [1-9]

Most Used Google Sheet Shortcuts for Formatting Cells

ActionShortcut
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 automaticCtrl + 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 + \
Insert rowsCtrl + Alt + =
Ctrl + Alt + Shift + = 

(with rows selected)
Insert columnsCtrl + Alt + =
Ctrl + Alt + Shift + = 

(with columns selected)
Delete rowsCtrl + Alt + – (with rows selected)
Delete columnsCtrl + Alt + – (with columns selected)
Hide rowCtrl + Alt + 9
Unhide rowCtrl + Shift + 9
Hide columnCtrl + Alt + 0
Unhide columnCtrl + Shift + 0
Group rows or columnsAlt + Shift + Right arrow
Ungroup rows or columnsAlt + Shift + Left arrow
Expand grouped rows or columnsAlt + Shift + Down arrow
Collapse grouped rows or columnsAlt + Shift + Up arrow
Hurry! Book a FREE Demo

Google Sheet Shortcuts for Navigating Spreadsheets

Move to section boundaryCtrl + Arrow keys
Select from current position to section boundaryCtrl + Shift + Arrow keys
Scroll to active cellCtrl + Backspace
Move to next sheetCtrl + Tab
Alt + Down arrow
Ctrl + Shift + Page Down
Move to previous sheetCtrl + Shift + Tab
Alt + Up arrow
Ctrl + Shift + Page Up
Display list of sheetsAlt + Shift + k
Open hyperlinkAlt + Enter
Open ExploreAlt + Shift + x
Open menu on filtered cellCtrl + Alt + Shift + r
Ctrl + Alt + r
Move to beginning of rowHome
Move to beginning of sheetCtrl + Home
Move to end of rowEnd
Move to end of sheetCtrl + End

Google Sheet Shortcuts for Using Formula

ActionShortcut
Insert array formulaCtrl + Shift + Enter
Show expanded function help (when entering a formula)F1
Toggle formula range selection (when entering a formula)F2
Ctrl + e
Absolute/relative range references (when entering a formula)F4

More Google Sheet Keyboard Shortcuts

Despite the long list given above, there are many more keyboard shortcuts available for Google Sheets. The link for them is given below.

Google Sheet Keyboard Shortcuts

Google Editor Suit Shortcuts

Google has its own software suit for workspace productivity – Google Editor Suit. It comprises of Google Sheet, Google Docs, Google Slides, Google Drawings, Google Form, etc. The shortcuts for Google productivity software are given below.


About Gibbon

Gibbon is a Plug and Play solution offered by EduGorilla, for anyone with a skill to teach. Gibbon helps you to take your classes online and earn independently. Gibbon is Trusted by 3000+ Brands, 10000+ Institutes, 15000+ Creators and 20000+ Educators for Increasing their Revenue by 25X. It’s about time you increase yours.

All the features of Gibbon Plug & Play solution, are given below.

White Label Website & App
Conduct & Record Live Classes
Create & Sell Video Course
LIVE Proctoring Examination
Branded Study Notes/Book
Analytics & Reporting (Online Assessment)
Create/ Upload Content
Ready Made Content for Exams
Hurry! Book a FREE Demo

Write A Comment