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 |
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.