Warning: Trying to access array offset on value of type bool in /home/mindlptl/digimessiah.com/wp-content/plugins/elementor-pro/modules/dynamic-tags/tags/post-featured-image.php on line 36

Warning: Trying to access array offset on value of type bool in /home/mindlptl/digimessiah.com/wp-content/plugins/elementor-pro/modules/dynamic-tags/tags/post-featured-image.php on line 36

Warning: Trying to access array offset on value of type bool in /home/mindlptl/digimessiah.com/wp-content/plugins/elementor-pro/modules/dynamic-tags/tags/post-featured-image.php on line 36

Warning: Trying to access array offset on value of type bool in /home/mindlptl/digimessiah.com/wp-content/plugins/elementor-pro/modules/dynamic-tags/tags/post-featured-image.php on line 36
101 Google Sheets Shortcuts (Spreadsheet Shortcuts PDF)

Warning: Trying to access array offset on value of type bool in /home/mindlptl/digimessiah.com/wp-content/plugins/elementor-pro/modules/dynamic-tags/tags/post-featured-image.php on line 36

101 Google Sheets Shortcuts – Google Sheets Shortcuts PDF


Here most used Google Sheets Shortcuts that’s useful when you’re working in a Google Spreadsheet. In a simple term, I can state Google Sheet as an online version of Microsoft Excel. Google Sheets is one of the programs of the G-suite device. Learn Top 10 Google Sheets Formulas for Beginners. Google sheets will allow users to create and edit files online, Download Google Sheets Shortcuts PDF. The changes made in the Google Sheet are saved automatically.

Google Sheets Shortcuts List, Google Sheet Shortcut Keys pdf

google-sheets-iconGoogle Spreadsheet also comprises a lot of functions and formulas just like Microsoft Excel. Hence, working with a mouse with all these functions will be quite a difficult task. And so to the rescue comes the Google Sheets Shortcuts. Below are the various Google Sheets shortcuts which will help you to work with Google sheet effectively. You can even download these Google Sheets shortcuts PDF here, Google Sheet Shortcut Keys PDF.


General Shortcuts

ActionShortcut Keys
Open optionsCtrl + O
Undo last actionCtrl + Z
Redo last actionCtrl + Y
Copy selected cellsCtrl + C
Repeat last actionCtrl + Shift + Z or F4
Cut selected cellsCtrl + X
Paste content from clipboardCtrl + V
Display paste special dialog boxCtrl + Shift + V
Display Find optionCtrl + F
Display Find & ReplaceCtrl + H
Save[by default save in Drive]Ctrl + S
PrintCtrl + P
Show common keyboard shortcutsCtrl + /
Insert new sheetShift + F11

Read more

Learn Everything about Google Sheets like How to use, Templates etc.

Borders Shortcuts

ActionShortcut Keys
Apply border outlineAlt + Shift + 7
Add border topAlt + Shift + 1
Add border rightAlt + Shift + 2
Add border bottomAlt + Shift + 3
Add border leftAlt + Shift + 4
Remove bordersAlt + Shift + 6

Formatting Shortcuts

ActionShortcut Keys
Apply bold formattingCtrl + B
Apply italic formattingCtrl + I
Apply underline formattingCtrl + U
Apply strikethrough formattingAlt + Shift + 5
Align centerCtrl + Shift + E
Align leftCtrl + Shift + I
Align rightCtrl + Shift + R
Clear formattingCtrl + \

Read more

The 15 Most Useful Google Sheets Formulas – VLookup and ImportHTML Formulas etc.

Number Formatting

ActionShortcut Keys
Apply number formatCtrl + Shift + 1
Apply time formatCtrl + Shift + 2
Apply Date formatCtrl + Shift + 3
Apply currency formatCtrl + Shift + 4
Apply percentage formatCtrl + Shift + 5
Apply exponent formatCtrl + Shift + 6

Entering Data

ActionShortcut Keys
Move rightTab
Move leftShift + Tab
Enter the same data in multiple cellsCtrl + Enter
Fill down from above cellCtrl + D
Fill right from cell leftCtrl + R
Add hyperlinkCtrl + K
Insert current timeCtrl + Shift + ;
Insert current dateCtrl + ;
Insert current date and timeCtrl + Alt + Shift + ;

Selection Shortcuts

ActionShortcut Keys
Select entire rowShift + Space
Select entire columnCtrl + Space
Select entire google sheetCtrl + A
Select entire google sheetCtrl + Shift + Space
Add adjacent cells to selectionShift + Click
Add non-adjacent cells to selectionCtrl + Click
Scroll to the active cellCtrl + Backspace

Extend Selection Shortcuts

ActionShortcut Keys
Extend selection by one cell rightShift + →
Extend selection by one cell leftShift + ←
Extend selection by one cell upShift + ↑
Extend selection by one cell downShift + ↓
Extend the selection to the last cell rightCtrl + Shift + →
Extend the selection to the last cell leftCtrl + Shift + ←
Extend the selection to the last cell upCtrl + Shift + ↑
Extend the selection to the last cell downCtrl + Shift + ↓
Extend selection up one screenShift + PageUp
Extend selection down one screenShift + PageDown
Extend selection right one screenAlt + Shift + PageDown
Extend selection left one screenAlt + Shift + PageUp


ActionShortcut Keys
Move one cell right
Move one cell left
Move one cell up
Move one cell down
Move one screen rightAlt + PageDown
Move one screen leftAlt + PageUp
Move one screen upPageUp
Move one screen downPageDown
Move to right edge of data regionCtrl + →
Move to left edge of data regionCtrl + ←
Move to top edge of data regionCtrl + ↑
Move to bottom edge of data regionCtrl + ↓
Move to beginning of rowHome
Move to the beginning of sheetCtrl + Home
Move to end of rowEnd
Move to end of sheetCtrl + End

You May Also Like

Keyboard Shortcuts for Google Docs

21 Shortcuts for Google Slides (Windows)

Most useful Google Chrome Shortcuts for Win & Mac

List of Important Spreadsheet Formulas

Best 5 Google Docs Template useful in 2020

Keyboard Shortcuts for Kingsoft Spreadsheets

With all the above Google Sheet Shortcuts you can present your data with colourful charts and graphs. There are Google Sheets Shortcuts for Pivot Tables, conditional formatting and many more which will save time and simplify the task. There are a variety of templates available like a budget template, expense template, schedules and many more. If you want us to customize Google template for you. Feel free to mail here.

After having a look at the Google Sheets Shortcuts, let’s take a look at the Kingsoft Spreadsheet shortcuts which are more or less similar. Hope you have liked our blog on Google Sheets Shortcuts. Suggestions are always welcomed for the blog you looking forward to hearing from us. Connect with us and Take your Office Productivity to Next Level.

Darshan Jain
Darshan Jain

Linkedin | Instagram

Hello Readers, Thank you spending out time in reading this blog. I' Darshan Jain writer of Digi Messiah. My hobbies is Coding and Writing, I am also a writer "Who write books :)"

Read My Post

You may also like:

You Don’t have Authorization to View this Page. HTTP Error 403 (FIXED)
Best Pet Grooming Gloves For Dogs
Digi Messiah