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.
| 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 |
| 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 PDF
Download Excel File
Join Our WhatsApp Group
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.
