Boost your productivity with our detailed guide to Google Sheets Mac keyboard shortcuts. Whether you’re dealing with basic navigation or intricate data handling, these shortcuts are a significant aid for those aiming to optimize their workflow.
Google Sheets shortcuts for:
- Common Actions
- Format Cells
- Navigate the Spreadsheet
- Edit Notes and Comments
- Use Keyboard Shortcuts on Selected Comments
- Open a Menu
- Add or Change Rows and Columns
- Use Formulas
- Help for Screen Readers
Common Actions
| Action |
Shortcut |
| Select column |
Ctrl + Space |
| Select row |
Shift + Space |
| Select all |
⌘ + A, ⌘ + Shift + Space |
| Undo |
⌘ + Z |
| Redo |
⌘ + Y, ⌘ + Shift + Z, Fn + F4 |
| Find |
⌘ + F |
| Find and replace |
⌘ + Shift + H |
| Fill range |
⌘ + Enter |
| Fill down |
⌘ + D |
| Fill right |
⌘ + R |
| Save (every change is saved automatically in Drive) |
⌘ + S |
| Open |
⌘ + O |
| Print |
⌘ + P |
| Copy |
⌘ + C |
| Cut |
⌘ + X |
| Paste |
⌘ + V |
| Paste values only |
⌘ + Shift + V |
| Show common keyboard shortcuts |
⌘ + / |
| Insert new sheet |
Shift + Fn + F11 |
| Compact controls |
Ctrl + Shift + F |
| Input tools on/off (available in non-Latin languages) |
⌘ + Shift + K |
| Select input tools |
⌘ + Option + Shift + K |
| Tool finder (formerly Search the menus) |
Option + / |
| Select current region around selected cell |
⌘ + Shift + *, Ctrl + Shift + * |
| Displays or hides the menus |
⌘ + Option + R, Ctrl + Shift + F |
Format Cells
| Action |
Shortcut 1 |
Shortcut 2 |
Shortcut 3 |
| Bold |
⌘ + B |
⌘ + 2 |
Ctrl + 2 |
| Underline |
⌘ + U |
⌘ + 4 |
Ctrl + 4 |
| Italic |
⌘ + I |
⌘ + 3 |
Ctrl + 3 |
| Strikethrough |
⌘ + Shift + X |
⌘ + 5 |
Ctrl + 5 |
| Center align |
⌘ + Shift + E |
|
|
| Left align |
⌘ + Shift + L |
|
|
| Right align |
⌘ + Shift + R |
|
|
| Apply top border |
Option + Shift + 1 |
|
|
| Apply right border |
Option + Shift + 2 |
|
|
| Apply bottom border |
Option + Shift + 3 |
|
|
| Apply left border |
Option + Shift + 4 |
|
|
| Remove borders |
Option + Shift + 6 |
|
|
| Apply outer border |
Option + Shift + 7 |
⌘ + Shift + 7 |
Ctrl + Shift + 7 |
| Insert link |
⌘ + K |
|
|
| Insert time |
⌘ + Shift + ; |
|
|
| Insert date |
⌘ + ; |
|
|
| Insert date and time |
⌘ + Option + Shift + ; |
|
|
| Format as decimal |
Ctrl + Shift + 1 |
|
|
| Format as time |
Ctrl + Shift + 2 |
|
|
| Format as date |
Ctrl + Shift + 3 |
|
|
| Format as currency |
Ctrl + Shift + 4 |
|
|
| Format as percentage |
Ctrl + Shift + 5 |
|
|
| Format as exponent |
Ctrl + Shift + 6 |
|
|
| Clear formatting |
⌘ + | |
|
|
Navigate the Spreadsheet
| Action |
Shortcut |
Shortcut(Macbook) |
| Move to beginning of row |
Fn + Left Arrow |
|
| Move to beginning of sheet |
⌘ + Fn + Left Arrow |
|
| Move to end of row |
Fn + Right Arrow |
|
| Move to end of sheet |
⌘ + Fn + Right Arrow |
|
| Scroll to active cell |
⌘ + Backspace |
|
| Move to next sheet |
Option + Down Arrow |
Option + Right Arrow |
| Move to previous sheet |
Option + Up Arrow |
Option + Left Arrow |
| Display list of sheets |
Option + Shift + K |
|
| Open hyperlink |
Option + Enter |
|
| Open Explore |
⌘ + Option + Shift + I |
|
| Go to side panel |
⌘ + Option + . / ⌘ + Option + , |
|
| Move focus out of spreadsheet |
Ctrl + ⌘ + Shift + M |
|
| Move to quicksum (when a range of cells is selected) |
Option + Shift + Q |
|
| Move focus to popup (for links, bookmarks, images) |
hold Ctrl + ⌘, press E then P |
|
| Open drop-down menu on filtered cell |
Ctrl + ⌘ + R |
|
| Open revision history |
⌘ + Option + Shift + H |
|
| Close drawing editor |
⌘ + Esc / Shift + Esc |
|
| Show “Go to range” dialog |
Ctrl + G |
|
| Find and replace with Find tab selected |
Ctrl + F |
|
Edit Notes and Comments
| Action |
Macbook |
| Insert/edit note |
Shift + F2 |
| Insert/edit comment |
⌘ + Option + M |
| Open comment discussion thread |
⌘ + Option + Shift + A |
| Enter current comment |
hold Ctrl + ⌘, press E then C |
| Move to next comment |
hold Ctrl + ⌘, press N then C |
| Move to previous comment |
hold Ctrl + ⌘, press P then C |
Use Keyboard Shortcuts on Selected Comments
| Action |
Macbook |
| Reply to current comment |
R |
| Move to next comment |
J |
| Move to previous comment |
K |
| Resolve current comment |
E |
| Exit current comment |
U |
Open a Menu
| Open File menu |
Ctrl + Option + F |
| Open Edit menu |
Ctrl + Option + E |
| Open View menu |
Ctrl + Option + V |
| Open Insert menu |
Ctrl + Option + I |
| Open Format menu |
Ctrl + Option + O |
| Open Data menu |
Ctrl + Option + D |
| Open Tools menu |
Ctrl + Option + T |
| Open insert menu (with cells selected) |
⌘ + Option + = |
| Open delete menu (with cells selected) |
⌘ + Option + – |
| Open Form menu (when connected to a form) |
Ctrl + Option + M |
| Open Add-ons menu |
Ctrl + Option + N |
| Open Help menu |
Ctrl + Option + H |
| Open Accessibility menu (screen reader support) |
Ctrl + Option + A |
| Open Sheet menu (copy, delete, other sheet actions) |
Option + Shift + S |
| Open Context menu |
⌘ + Shift + \ or Shift + F10 |
Add or Change Rows and Columns
| Action |
Shortcut |
| Insert rows above |
⌘ + Option + = (with rows selected) |
| Insert rows below |
|
| Insert columns to the left |
⌘ + Option + = (with columns selected) |
| Insert columns to the right |
|
| Delete rows |
⌘ + Option + – (with rows selected) |
| Delete columns |
⌘ + Option + – (with columns selected) |
| Hide row |
⌘ + Option + 9 |
| Unhide row |
⌘ + Shift + 9 |
| Hide column |
⌘ + Option + 0 |
| Unhide column |
⌘ + Shift + 0 |
| Group rows or columns |
Option + Shift + Right Arrow |
| Ungroup rows or columns |
Option + Shift + Left Arrow |
| Expand grouped rows or columns |
Option + Shift + Down Arrow |
| Collapse grouped rows or columns |
Option + Shift + Up Arrow |
Use Formulas
| Action |
Shortcut |
| Show all formulas |
Ctrl + ~ |
| Insert array formula |
⌘ + Shift + Enter |
| Collapse an expanded array formula |
⌘ + E |
| Show/hide formula help (when entering a formula) |
Shift + Fn + F1 |
| Full/compact formula help (when entering a formula) |
Fn + F1 |
| Absolute/relative references (when entering a formula) |
Fn + F4 |
| Toggle formula result previews (when entering a formula) |
Fn + F9 |
| Resize formula bar (move up or down) |
Ctrl + Option + Up and Ctrl + Option + Down |
| Toggle formula range selection (when entering a formula) |
F2, Ctrl + E |
Help for Screen Readers
| Action |
Shortcut |
| Turn on screen reader support |
⌘ + Option + Z |
| Learn more about using Google Sheets with a screen reader |
⌘ + Option + Z |
| Enable braille support |
⌘ + Option + H |
| Read column |
⌘ + Option + Shift + C |
| Read row |
⌘ + Option + Shift + R |
Happy learning!
2 Likes
