Keyboard Shortcuts for Google Sheets
Time is money in today’s world. Google Sheets Keyboard shortcuts can help you get more done in less time. Google Sheets with keyboard shortcuts is your ultimate power move for spreadsheet domination. This applies whether you’re a pro spreadsheet user or a newbie. Keyboard shortcuts are the secret weapons that will transform your Google Sheets experience into a lightning-fast workflow.
Here, we’ll see all the keyboard shortcuts that will help you save time and make your work easy in Google Sheets.
What are Keyboard Shortcuts in Google Sheet?
Keyboard shortcuts also referred to as hotkeys, are powerful combinations of key presses on a computer keyboard. When activated simultaneously, they swiftly execute specific commands or provide rapid access to features.
These shortcuts serve as an efficient alternative to navigating menus and clicking buttons with a mouse. For instance,
- Ctrl+C: Copies text.
- Ctrl+V: Pastes copied content.
Why to Use Keyboard Shortcuts?
Keyboard shortcuts in Google Sheets offer several benefits that can make your life easier. Here are the benefits of using Keyboard Shortcuts given below for your reference,
- Keyboard shortcuts are like secret codes that will allow you to perform tasks quickly.
- These shortcuts will save you time and effort, Also, they will help you work faster and more efficiently.
- Keyboard shortcuts reduce the need for repetitive mouse clicks and menu navigation.
- These shortcuts will you get more done in less time.
- By using these shortcuts, you can increase your overall productivity.
20 Most Important Keyboard Shortcuts for Google Sheets
Here are a few essential Google Sheets shortcuts to get you started on your journey of learning spreadsheets. Check the below given basic shortcuts,
1. Navigation
- Arrow keys: Move around cells, one cell at a time (up, down, left, right).
- Home/End: Jump to the beginning or end of a row/column (Home = beginning, End = end).
- PgUp/PgDn: Move up or down by one screen.
2. Editing
- Ctrl/Cmd + C: Copy the selected cell(s).
- Ctrl/Cmd + V: Paste the copied content.
- Ctrl/Cmd + X: Cut the selected cell(s) (removes and copies).
3. Formatting
- Ctrl/Cmd + B: Bold selected text.
- Ctrl/Cmd + I: Italicize selected text.
- Ctrl/Cmd + U: Underline selected text.
Basic Keyboard Shortcuts for Google Sheets
Here are 21 keyboard shortcuts for Google Sheets that will help you to become a Google Sheet pro. Check the table provided below for your reference,
KEYBOARD SHORTCUTS |
DESCRIPTION |
---|---|
Ctrl + / (Cmd + / on Mac) |
Show keyboard shortcuts |
Ctrl + Enter (Cmd + Enter on Mac) |
Quickly fill down the formula while keeping the cell selected |
Ctrl + Shift + V (Cmd + Shift + V on Mac) |
Paste only values from the clipboard |
Ctrl + Shift + C (Cmd + Shift + C on Mac) |
Copy the value of the currently selected cell |
Ctrl + Shift + V (Cmd + Shift + V on Mac) |
Paste the copied value into the selected cell |
Ctrl + Alt + V (Cmd + Option + V on Mac) |
Open paste special dialog |
Ctrl + Shift + Z (Cmd + Shift + Z on Mac) |
Redo your last action |
Ctrl + ; (Cmd + ; on Mac) |
Insert the current date into the selected cell |
Ctrl + Shift + : (Cmd + Shift + : on Mac) |
Insert the current time into the selected cell |
Ctrl + Page Up (Cmd + Option + Up Arrow on Mac) |
Move to the previous sheet in the workbook |
Ctrl + Page Down (Cmd + Option + Down Arrow on Mac) |
Move to the next sheet in the workbook |
Alt + Enter (Option + Enter on Mac) |
Start a new line within a cell |
Ctrl + Shift + 7 (Cmd + Option + 7 on Mac) |
Apply border formatting to cells |
Ctrl + Shift + 8 (Cmd + Option + 8 on Mac) |
Apply the outline border format to cells |
Ctrl + K (Cmd + K on Mac) |
Insert or edit a hyperlink in the selected cell |
Ctrl + Shift + Arrow Key (Cmd + Shift + Arrow Key on Mac) |
Select an entire row or column based on the direction of the arrow key |
Ctrl + Backspace (Cmd + Delete on Mac) |
Delete the content of the selected cells |
Ctrl + ; (Cmd + ; on Mac) |
Insert the current date into the selected cell |
Ctrl + Shift + : (Cmd + Shift + : on Mac) |
Insert the current time into the selected cell |
Ctrl + Alt + M (Cmd + Option + M on Mac) |
Insert a comment into the selected cell |
Ctrl + Shift + F (Cmd + Shift + F on Mac) |
Open the “Format cells” dialog |
Conclusion
From simple tasks like copying and pasting, to more advanced functions such as formatting cells and applying filters, shortcuts allow you to navigate and manipulate data with unprecedented speed.
Remember, the key to speed in Google Sheets lies in these shortcuts, making them indispensable tools for anyone serious about their data.
Google Sheet Keyboard Shortcuts – FAQs
What are the keyboard shortcuts for Google Sheets?
Here are some essential keyboard shortcuts for Google Sheets:
- Ctrl + C: Copy
- Ctrl + V: Paste
- Ctrl + X: Cut
- Ctrl + Z: Undo
- Ctrl + Y: Redo
- Ctrl + S: Save
- Ctrl + O: Open
- Ctrl + P: Print
- Ctrl + A: Select all
- Ctrl + F: Find
- Ctrl + H: Replace
- Ctrl + Arrow Keys: Navigate
- Ctrl + Shift + L: Toggle filter
- Ctrl + Shift + 1: Format as decimal
- Ctrl + Shift + 4: Format as currency
These shortcuts can significantly speed up your work in Google Sheets.
What is the keyboard shortcut for Format in Google Sheets?
The keyboard shortcut to open the Format menu in Google Sheets is Ctrl + Alt + O.
Can I make a shortcut for Google Sheets?
Google Sheets doesn’t provide a built-in way to create custom keyboard shortcuts. However, you can use third-party tools or extensions to create custom shortcuts for specific actions or macros within Google Sheets.
What is Ctrl R in Google Sheets?
In Google Sheets, Ctrl + R is a keyboard shortcut used to fill data rightward from the selected cell. This means it copies the content from the leftmost cell in the selected range and fills it to the right into adjacent cells.
Contact Us