Google Sheets is a powerful and user-friendly spreadsheet application enabling users to organize and analyze data easily. To boost productivity with Google Sheets, it is very important to master Google Sheets keywords. This blog post presents 100+ Google Sheets shortcuts for Windows PC and Mac users. These collections of Google Sheets shortcuts will help you easily navigate, format, edit and perform various tasks. Let’s dive in!
Sheets Keyboard Shortcuts
Below is the list of 100+ Google Sheets shortcuts, which are categorized by their default functions for both Windows and Mac users;
Navigation Keyboard Shortcuts
Functionality
Windows Shortcut
Mac Shortcut
Move Up
Up Arrow
Up Arrow
Move Down
Down Arrow
Down Arrow
Move Left
Left Arrow
Left Arrow
Move Right
Right Arrow
Right Arrow
Go to First Row
Home
⌘ + Up Arrow
Go to Last Row
End
⌘ + Down Arrow
Go to First Column
Control + Home
⌘ + Left Arrow
Go to Last Column
Control + End
⌘ + Right Arrow
Go to Next Sheet
Control + Page Down
Control + Page Down
Go to Previous Sheet
Control + Page Up
Control + Page Up
Table 1: Navigation Google Sheets Keyboard Shortcuts for Windows and Mac.
Selection Keyboard Shortcuts
Functionality
Windows Shortcut
Mac Shortcut
Select Row
Shift + Space
Shift + Space
Select Column
Control + Space
⌘ + Space
Select Entire Sheet
Control + A
⌘ + A
Extend Selection Up
Shift + Up Arrow
Shift + Up Arrow
Extend Selection Down
Shift + Down Arrow
Shift + Down Arrow
Extend Selection Left
Shift + Left Arrow
Shift + Left Arrow
Extend Selection Right
Shift + Right Arrow
Shift + Right Arrow
Table 2: Selection Google Sheets Keyboard Shortcuts Mac and Windows.
Formatting Keyboard Shortcuts
Functionality
Windows Shortcut
Mac Shortcut
Bold
Control + B
⌘ + B
Italic
Control + I
⌘ + I
Underline
Control + U
⌘ + U
Strikethrough
Control + Shift + X
⌘ + Shift + X
Increase Font Size
Control + Shift + >
⌘ + Shift + >
Decrease Font Size
Control + Shift + <
⌘ + Shift + <
Table 3: Formatting Google Sheets Keyboard Shortcuts for Windows and Mac.
Editing Google Sheets Shortcuts
Functionality
Windows Shortcut
Mac Shortcut
Edit Cell
F2
F2
Insert Comment
Control + Alt + M
⌘ + Option + M
Insert Row Above
Control + Shift + +
⌘ + Shift + +
Insert Row Below
Control + +
⌘ + +
Insert Column Before
Control + Shift + +
⌘ + Shift + +
Insert Column After
Control + +
⌘ + +
Delete Row
Control + –
⌘ + –
Delete Column
Control + –
⌘ + –
Table 4: Editing shortcuts for Windows and Mac.
Cell Navigation Sheets Shortcuts
Functionality
Windows Shortcut
Mac Shortcut
Go to Next Editable Cell
Enter
Enter
Go to Previous Editable Cell
Shift + Enter
Shift + Enter
Move to Next Cell in Row
Tab
Tab
Move to Previous Cell in Row
Shift + Tab
Shift + Tab
Table 5: Cell Navigation Shortcuts for Windows and Mac.
Formula Related Sheets Shortcuts
Functionality
Windows Shortcut
Mac Shortcut
Start a Formula
Equal (=)
Equal (=)
Toggle Absolute Reference
F4
F4
Auto Sum
Alt + Shift + =
Option + Shift + =
Table 6: Formula and google sheets auto sum shortcut related Shortcuts for Windows and Mac.
Other Common Sheets Shortcuts
Functionality
Windows Shortcut
Mac Shortcut
Undo
Control + Z
⌘ + Z
Redo
Control + Y
⌘ + Y
Copy
Control + C
⌘ + C
Cut
Control + X
⌘ + X
Paste
Control + V
⌘ + V
Fill Down
Control + D
⌘ + D
Find
Control + F
⌘ + F
Replace
Control + H
⌘ + H
Table 7: Commonly used Google Sheets Shortcuts for Windows and Mac.
Using keyboard shortcuts can enhance your efficiency and productivity with Google Sheets. By using these 100+ Google Sheets shortcuts, you can do the tasks faster with very few clicks. So go ahead and start using these shortcuts in your work!