100+ Google Sheets Shortcuts Keys Download in PDF & Excel File

Google Sheets is a web-based program that allows users to create, update, and alter spreadsheets as well as share data in real-time online.

Google’s spreadsheet app includes standard spreadsheet functions such as the ability to add, delete, and sort rows and columns. Unlike other spreadsheet tools, however, Google Sheets allows many geographically scattered users to work on a spreadsheet at the same time and talk using the built-in instant messaging program. Spreadsheets can be uploaded straight from computers or mobile devices. Every update is automatically saved, and users may see the changes of other users as they are made.

1 What is the purpose of Google Sheets?

Google Sheets is commonly used to collaborate on spreadsheets across multiple locations. A Google Sheets document can be modified by several users in real-time, with each user’s modifications being monitored.

The Google Sheets online spreadsheet program allows users to organize and analyze data by creating, editing, and formatting spreadsheets online. Because both applications are used for comparable reasons, Google Sheets is frequently compared to Microsoft Excel. Google Sheets is essentially Google’s cloud-based equivalent of the core functionality of Microsoft Excel.

2 What are Favorite ways to use Google Sheets?

Google Sheets is an online browser application that allows users to create and modify spreadsheets, as well as mobile devices that run on iOS or Android. To use Google Sheets, you must have a valid email address

3 Users can perform the following with Google Sheets

Spreadsheets can be edited and formatted-Google Sheets allows you to add, modify, format, and apply spreadsheet items to formulas and functions.

Analyze-Spreadsheet data may be shown in charts, graphs, and tables using Google Sheets.

Share- By sharing Google Sheets documents and folders, users may interact in real-time.

Print and save the file- Google Sheets files can be opened and imported into various document formats such as Microsoft Excel, Word, PowerPoint, Adobe PDF, and PNG (Portable Network Graphics).

Google Sheets has a number of functions.

4 The following are the main features of Google Sheets

Editing and formatting spreadsheets. This comprises data entry, data summary, text translation, data import, and data validation procedures and functions.

Visualization of data Users can create graphs, charts, and other forms of diagrams from spreadsheet data and embed them in websites.

Features that are based on machine learning. Machine learning is used in the Explore function to make charts, pivot tables, and answer questions about the data.

Editing can be done offline. Sheets can be edited offline even if you aren’t connected to the internet, and changes will be updated once you reconnect.

Compatibility. Excel (XLS), Apache OpenOffice, PDF, Text, HTML, and comma-separated values (CSV) are all compatible with Sheets documents (CSV).

Integration with Google products. Other Google services, such as Drawing, Finance, Form, and Translate, can be connected with Google Sheets.
Google Sheet is an online free program from Google that you can use anywhere. You just need an email id of Google and an internet connection. If you are using the chrome browser you can work on Google Sheets offline also. You can use it on your cell phone as well as on your computer as well. Doesn’t matter which operating system you use, and neither does the bowser matter.  Google Sheets is part of Google Workspace. The Google Workspace consists of various tools similar to word, excel, PowerPoint, etc. There is one more powerful tool that is Google ForMicrosoft available for users too.


जब आप Google Spreadsheet में काम कर रहे होते हैं, तब Google sheet shortcut  का सबसे अधिक उपयोग किया जाता है। एक साधारण शब्द में, मैं Google Sheet को Microsoft Excel के online version   के रूप में जाना जाता है। Google Sheet G-Suite Device के कार्यक्रमों में से एक है।Google Spreadsheet में Microsoft Excel की तरह ही बहुत सारे Function  और Formulas  शामिल हैं। इसलिए, इन सभी कार्यों के साथ एक माउस के साथ काम करना काफी मुश्किल काम होता है। और इसलिए बचाव के लिए Google Sheet  shortcuts आते हैं। नीचे Google शीट के विभिन्न shortcuts  दिए गए हैं जो आपको प्रभावी रूप से Google शीट के साथ काम करने में मदद करेंगे। आप इन Google शीट शॉर्टकट PDF को निचे डाउनलोड कर सकते हैं।

Action Shortcut Keys
Open options Ctrl + O
Undo last action Ctrl + Z
Redo last action Ctrl + Y
Copy selected cells Ctrl + C
Repeat last action Ctrl + Shift + Z or F4
Cut selected cells Ctrl + X
Paste content from clipboard Ctrl + V
Display paste special dialog box Ctrl + Shift + V
Display Find option Ctrl + F
Display Find & Replace Ctrl + H
Save[by default save in Drive] Ctrl + S
Print Ctrl + P
Show common keyboard shortcuts Ctrl + /
Insert new sheet Shift + F11

Borders Shortcuts

Apply border outline Alt + Shift + 7
Add border top Alt + Shift + 1
Add border right Alt + Shift + 2
Add border bottom Alt + Shift + 3
Add border left Alt + Shift + 4
Remove borders Alt + Shift + 6

Formatting Shortcuts

Apply bold formatting Ctrl + B
Apply italic formatting Ctrl + I
Apply underline formatting Ctrl + U
Apply strikethrough formatting Alt + Shift + 5
Align center Ctrl + Shift + E
Align left Ctrl + Shift + I
Align right Ctrl + Shift + R
Clear formatting Ctrl + \

Number Formatting

Apply number format Ctrl + Shift + 1
Apply time format Ctrl + Shift + 2
Apply Date format Ctrl + Shift + 3
Apply currency format Ctrl + Shift + 4
Apply percentage format Ctrl + Shift + 5
Apply exponent format Ctrl + Shift + 6

Entering Data

Move right Tab
Move left Shift + Tab
Enter the same data in multiple cells Ctrl + Enter
Fill down from above cell Ctrl + D
Fill right from cell left Ctrl + R
Add hyperlink Ctrl + K
Insert current time Ctrl + Shift + ;
Insert current date Ctrl + ;
Insert current date and time Ctrl + Alt + Shift + ;

Selection Shortcuts

Select entire row Shift + Space
Select entire column Ctrl + Space
Select entire google sheet Ctrl + A
Select entire google sheet Ctrl + Shift + Space
Add adjacent cells to selection Shift + Click
Add non-adjacent cells to selection Ctrl + Click
Scroll to the active cell Ctrl + Backspace

Extend Selection Shortcuts

Extend selection by one cell right Shift + →
Extend selection by one cell left Shift + ←
Extend selection by one cell up Shift + ↑
Extend selection by one cell down Shift + ↓
Extend the selection to the last cell right Ctrl + Shift + →
Extend the selection to the last cell left Ctrl + Shift + ←
Extend the selection to the last cell up Ctrl + Shift + ↑
Extend the selection to the last cell down Ctrl + Shift + ↓
Extend selection up one screen Shift + Page Up
Extend selection down one screen Shift + Page Down
Extend selection right one screen Alt + Shift + Page Down
Extend selection left one screen Alt + Shift + Page Up

Navigation

Move one cell right
Move one cell left
Move one cell up
Move one cell down
Move one screen right Alt + Page Down
Move one screen left Alt + Page Up
Move one screen up Page Up
Move one screen down Page Down
Move to right edge of data region Ctrl + →
Move to left edge of data region Ctrl + ←
Move to top edge of data region Ctrl + ↑
Move to bottom edge of data region Ctrl + ↓
Move to beginning of row Home
Move to the beginning of sheet Ctrl + Home
Move to end of row End
Move to end of sheet Ctrl + End

धन्यवाद दोस्तों! अगर आपको ये आर्टिक्ल पसंद आया हैं तो इसको सोशल मीडिया पर अपने दोस्तो के साथ जरूर से शेयर कीजिए, जिससे उनको भी ये जानकारी प्राप्त हो सके।

 Download Button पर  Click कर के PDF फ़ाइल डाउनलोड करें

Download Button पर  Click कर के Excel फ़ाइल डाउनलोड करें

Related Articles:

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group
Nazim Khan - Author Image

Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]

Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.

Leave a Comment