|
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.
1088766
488887
406639
350558
297279
270003
14 hours ago
15 hours ago
17 hours ago Updated!
Yesterday Updated!
Yesterday Updated!
Yesterday Updated!
Latest articles