|
Select column |
|
|
|
Select row |
|
|
|
Select all |
|
|
or
|
|||
|
Undo |
|
|
|
Redo |
|
|
or
|
|||
or
|
|||
|
Find |
|
|
|
Find and replace |
|
|
|
Fill range |
|
|
|
Fill down |
|
|
|
Fill right |
|
|
|
Save (every change is saved automatically in Drive) |
|
|
|
Open |
|
|
|
|
|
|
|
Copy |
|
|
|
Cut |
|
|
|
Paste |
|
|
|
Paste values only |
|
|
|
Show common keyboard shortcuts |
|
|
|
Compact controls |
|
|
|
Input tools on/off (available in spreadsheets in non-Latin languages) |
|
|
|
Select input tools |
|
Advertisement
|
Bold |
|
|
|
Underline |
|
|
|
Italic |
|
|
|
Strikethrough |
|
|
|
Center align |
|
|
|
Left align |
|
|
|
Right align |
|
|
|
Apply top border |
|
|
|
Apply right border |
|
|
|
Apply bottom border |
|
|
|
Apply left border |
|
|
|
Remove borders |
|
|
|
Apply outer border |
|
|
or
|
|||
|
Insert link |
|
|
|
Insert time |
|
|
|
Insert date |
|
|
|
Insert date and time |
|
|
|
Format as decimal |
|
|
|
Format as time |
|
|
|
Format as date |
|
|
|
Format as currency |
|
|
|
Format as percentage |
|
|
|
Format as exponent |
|
|
|
Clear formatting |
|
|
Move to beginning of row |
|
|
|
Move to beginning of sheet |
|
|
|
Move to end of row |
|
|
|
Move to end of sheet |
|
|
|
Scroll to active cell |
|
|
|
Move to next sheet |
|
|
|
Move to previous sheet |
|
|
|
Display list of sheets |
|
|
Advertisement |
|||
|
Open hyperlink |
|
|
|
Open Explore |
|
|
|
Move focus out of spreadsheet |
|
|
|
Move to quicksum (when a range of cells is selected) |
|
|
|
Move focus to popup (for links, bookmarks, and images) |
|
|
|
Open drop-down menu on filtered cell |
|
|
|
Open revision history |
|
|
|
Open chat inside the spreadsheet |
|
|
|
Close drawing editor |
|
|
or
|
|
Insert/edit note |
|
|
|
Insert/edit comment |
|
|
|
Open comment discussion thread |
|
|
|
Enter current comment |
|
|
|
Move to next comment |
|
|
|
Move to previous comment |
|
|
File menu |
|
|
|
Edit menu |
|
|
|
View menu |
|
|
|
Insert menu |
|
|
|
Format menu |
|
|
|
Data menu |
|
|
|
Tools menu |
|
|
|
(with cells selected) Open insert menu |
|
|
|
(with cells selected) Open delete menu |
|
|
|
Form menu |
|
|
|
Add-ons menu |
|
|
|
(in Google Chrome) Help menu |
|
|
|
(in other browsers) Help menu |
|
|
|
Accessibility menu |
|
|
|
(present when screen reader support is enabled) Accessibility menu |
|
|
|
Sheet menu (copy, delete, and other sheet actions) |
|
|
|
Context menu |
|
|
(with rows selected) Insert rows above |
|
|
or
|
|||
|
Insert rows below |
|
|
|
(with columns selected) Insert columns to the left |
|
|
or
|
|||
|
Insert columns to the right |
|
|
|
(with rows selected) Delete rows |
|
|
or
|
|||
or
|
|||
or
|
|||
|
(with columns selected) Delete columns |
|
|
|
(with columns selected) Delete columns |
|
|
|
Hide row |
|
|
|
Hide column |
|
|
Show all formulas |
|
|
|
Insert array formula |
|
|
|
Collapse an expanded array formula |
|
|
|
(when entering a formula) Show/hide formula help |
|
|
|
(when entering a formula) Full / compact formula help |
|
|
|
(when entering a formula) Absolute/relative references |
|
|
|
(when entering a formula) Toggle formula result previews |
|
|
|
Resize formula bar |
|
|
Turn on screen reader support |
|
|
|
Read column |
|
|
|
Read row |
|
|
Source: Google Sheets support page
|
What is your favorite Google Sheets (Mac) hotkey? Do you have any useful tips for it? Let other users know below.
1031652 167
470029 6
387394 363
312049 4
264184 5
254301 30
Yesterday
3 days ago
4 days ago
4 days ago Updated!
5 days ago
6 days ago Updated!
Latest articles