Use keyboard shortcuts in Google Sheets to navigate, format and use formulas.
Note: some shortcuts might not work for all languages or keyboards.
To see a list of keyboard shortcuts in Google Sheets, press Ctrl + / (Windows, Chrome OS) or ⌘ + / (Mac).
Tool finder (formerly Search the menus): Press Alt + / (Windows, Chrome OS) or Option + / (Mac).
PC shortcuts
|
Common actions |
|
|---|---|
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Select all | Ctrl + A Ctrl + Shift + Space |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y Ctrl + Shift + Z F4 |
| Find | Ctrl + F |
| Find and replace | Ctrl + H |
| Fill range | Ctrl + Enter |
| Fill down | Ctrl + D |
| Fill right | Ctrl + R |
| Save (every change is saved automatically in Drive) |
Ctrl + S |
| Open | Ctrl + O |
| Ctrl + P | |
| Copy | Ctrl + C |
| Cut | Ctrl + X |
| Paste | Ctrl + V |
| Paste values only | Ctrl + Shift + V |
| Show common keyboard shortcuts | Ctrl + / |
| Insert new sheet | Shift + F11 |
| Compact controls | Ctrl + Shift + F |
| Input tools on/off (available in spreadsheets in non-Latin languages) |
Ctrl + Shift + K |
| Select input tools | Ctrl + Alt + Shift + K |
| Tool finder (formerly Search the menus) |
Alt + / |
| Rename sheet | Alt + 1 |
| Convert range to table | Ctrl + Alt + T |
|
Format cells |
|
| Bold | Ctrl + B |
| Underline | Ctrl + U |
| Italic | Ctrl + I |
| Strikethrough | Alt + Shift + 5 |
| Centre align | Ctrl + Shift + E |
| Left align | Ctrl + Shift + l |
| Right align | Ctrl + Shift + R |
| Apply top border | Alt + Shift + 1 |
| Apply right border | Alt + Shift + 2 |
| Apply bottom border | Alt + Shift + 3 |
| Apply left border | Alt + Shift + 4 |
| Remove borders | Alt + Shift + 6 |
| Apply outer border |
Alt + Shift + 7 Ctrl + Shift + 7 |
| Insert link | Ctrl + K |
| Insert time | Ctrl + Shift + ; |
| Insert date | Ctrl + ; |
| Insert date and time | Ctrl + Alt + 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 | Ctrl + \ |
|
Navigate spreadsheet |
|
| Move to beginning of row | Home |
| Move to beginning of sheet | Ctrl + Home |
| Move to end of row | End |
| Move to end of sheet | Ctrl + End |
| Scroll to active cell | Ctrl + Backspace |
| Move to next sheet | Alt + Down arrow |
| Move to previous sheet | Alt + Up arrow |
| Display list of sheets | Alt + Shift + K |
| Open hyperlink | Alt + Enter |
| Open Explore |
Ctrl + Alt + Shift + I |
| Go to side panel | Ctrl + Alt + . Ctrl + Alt + , |
| Move focus out of spreadsheet | Ctrl + Alt + Shift + M |
| Move to quicksum (when a range of cells is selected) |
Alt + Shift + Q |
| Move focus to pop-up (for links, bookmarks and images) |
holding Ctrl + Alt, press E, then P |
| Open drop-down menu on filtered cell | Ctrl + Alt + R |
| Open revision history | Ctrl + Alt + Shift + H |
| Close drawing editor | Shift + Esc |
|
Edit notes and comments |
|
| Insert/edit note | Shift + F2 |
| Insert/edit comment | Ctrl + Alt + M |
| Open comment discussion thread | Ctrl + Alt + Shift + A |
| Enter current comment | holding Ctrl + Alt, press E, then C |
| Move to next comment | holding Ctrl + Alt, press N, then C |
| Move to previous comment | holding Ctrl + Alt, press P, then C |
|
Use keyboard shortcuts on selected comments |
|
| 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 |
|
| File menu | in Google Chrome: Alt + F Other browsers: Alt + Shift + F |
| Edit menu | in Google Chrome: Alt + E Other browsers: Alt + Shift + E |
| View menu | in Google Chrome: Alt + V Other browsers: Alt + Shift + V |
| Insert menu | in Google Chrome: Alt + I Other browsers: Alt + Shift + I |
| Format menu | in Google Chrome: Alt + O Other browsers: Alt + Shift + O |
| Data menu | in Google Chrome: Alt + D Other browsers: Alt + Shift + D |
| Tools menu | in Google Chrome: Alt + T Other browsers: Alt + Shift + T |
| Open insert menu | Ctrl + Alt + = (with cells selected) |
| Open delete menu | Ctrl + Alt + - (with cells selected) |
| Form menu (present when the spreadsheet is connected to a form) |
in Google Chrome: Alt + M Other browsers: Alt + Shift + M |
| Add-ons menu | in Google Chrome: Alt + N Other browsers: Alt + Shift + N |
| Help menu | in Google Chrome: Alt + H Other browsers: Alt + Shift + H |
| Accessibility menu (present when screen reader support is enabled) |
in Google Chrome: Alt + A Other browsers: Alt + Shift + A |
| Sheet menu (copy, delete and other sheet actions) |
Alt + Shift + S |
| Context menu |
Ctrl + Shift + \ |
| Table column menu | Ctrl + Alt + \ |
|
Add or change rows and columns |
|
| Insert rows above |
Ctrl + Alt + = in Google Chrome: Alt + I, then R, then R |
| Insert rows below | in Google Chrome: Alt + I, then R, then B Other browsers: Alt + Shift + I, then R, then B |
| Insert columns to the left |
Ctrl + Alt + = in Google Chrome: Alt + I, then C, then C |
| Insert columns to the right | in Google Chrome: Alt + I, then C, then O Other browsers: Alt + Shift + I, then C, then O |
| Delete rows |
Ctrl + Alt + - (with rows selected) in Google Chrome: Alt + E, then D, then D |
| Delete columns |
Ctrl + Alt + - (with columns selected) in Google Chrome: Alt + E, then D, then E |
| Hide row | Ctrl + Alt + 9 |
| Unhide row | Ctrl + Shift + 9 |
| Hide column | Ctrl + Alt + 0 |
| Unhide column | Ctrl + Shift + 0 |
| Group rows or columns | Alt + Shift + Right arrow |
| Ungroup rows or columns | Alt + Shift + Left arrow |
| Expand grouped rows or columns | Alt + Shift + Down arrow |
| Collapse grouped rows or columns | Alt + Shift + Up arrow |
|
Use formulas |
|
| Show all formulae | Ctrl + ~ |
| Insert array formula | Ctrl + Shift + Enter |
| Collapse an expanded array formula | Ctrl + E |
| Show/hide formula help (when entering a formula) |
Shift + F1 |
| Full/compact formula help (when entering a formula) |
F1 |
| Absolute/relative references (when entering a formula) |
F4 |
| Toggle formula result previews (when entering a formula) |
F9 |
| Resize formula bar (move up or down) |
Ctrl + Up/Ctrl + Down |
|
Toggle formula range selection |
F2 |
|
Help for screen readers |
|
| Turn on screen reader support Learn more about using Google Sheets with a screen reader |
Ctrl + Alt + Z |
| Enable braille support | Ctrl + Alt + H |
| Read column | Ctrl + Alt + Shift + C |
| Read row | Ctrl + Alt + Shift + R |
Mac shortcuts
|
Common actions |
|
|---|---|
| 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 |
| ⌘ + 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 spreadsheets 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 + * |
| Display or hide the menus | ⌘ + Option + R Ctrl + Shift + F |
| Convert range to table | ⌘ + Alt + T |
|
Format cells |
|
| Bold |
⌘ + B |
| Underline |
⌘ + U |
| Italic | ⌘ + I ⌘ + 3 Ctrl + 3 |
| Strikethrough |
⌘ + Shift + X |
| Centre 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 |
| 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 spreadsheet |
|
| 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 MacBook: |
| Move to previous sheet |
Option + Up arrow MacBook: |
| 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 pop-up (for links, bookmarks and images) |
holding 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' dialogue | Ctrl + G |
| Find and replace with Find tab selected | Ctrl + F |
|
Edit notes and comments |
|
| Insert/edit note | Shift + F2 |
| Insert/edit comment | ⌘ + Option + M |
| Open comment discussion thread | ⌘ + Option + Shift + A |
| Enter current comment | holding Ctrl + ⌘, press E, then C |
| Move to next comment | holding Ctrl + ⌘, press N, then C |
| Move to previous comment | holding Ctrl + ⌘, press P, then C |
|
Use keyboard shortcuts on selected comments |
|
| 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 |
|
| File menu | Ctrl + Option + F |
| Edit menu | Ctrl + Option + E |
| View menu | Ctrl + Option + V |
| Insert menu | Ctrl + Option + I |
| Format menu | Ctrl + Option + O |
| Data menu | Ctrl + Option + D |
| Tools menu | Ctrl + Option + T |
| Open insert menu | ⌘ + Option + = (with cells selected) |
| Open delete menu | ⌘ + Option + - (with cells selected) |
| Form menu (present when the spreadsheet is connected to a form) |
Ctrl + Option + M |
| Add-ons menu | Ctrl + Option + N |
| Help menu | Ctrl + Option + H |
| Accessibility menu (present when screen reader support is enabled) |
Ctrl + Option + A |
| Sheet menu (copy, delete and other sheet actions) |
Option + Shift + S |
| Context menu |
⌘ + Shift + \ |
| Table column menu | ⌘ + Option + \ |
|
Add or change rows and columns |
|
| Insert rows above |
⌘ + Option + = (with rows selected) |
| Insert rows below | Ctrl + Option + I, press R, then B |
| Insert columns to the left |
⌘ + Option + = (with columns selected) |
| Insert columns to the right | Ctrl + Option + I, press C, then O |
| Delete rows | ⌘ + Option + - (with rows selected) Ctrl + Option + E, then D, then D |
| Delete columns | ⌘ + Option + - (with columns selected) Ctrl + Option + E, then D, then E |
| 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 |
|
| Show all formulae | 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 |
|
Help for screen readers |
|
| Turn on screen reader support 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 |
Chrome OS shortcuts
|
Common actions |
|
|---|---|
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Select all | Ctrl + A |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y Ctrl + Shift + Z |
| Find | Ctrl + F |
| Find and replace | Ctrl + H |
| Fill range | Ctrl + Enter |
| Fill down | Ctrl + D |
| Fill right | Ctrl + R |
| Save (every change is saved automatically in Drive) |
Ctrl + S |
| Open | Ctrl + O |
| Ctrl + P | |
| Copy | Ctrl + C |
| Cut | Ctrl + X |
| Paste | Ctrl + V |
| Paste values only | Ctrl + Shift + V |
| Show common keyboard shortcuts | Ctrl + / |
| Compact controls | Ctrl + Shift + F |
| Input tools on/off (available in spreadsheets in non-Latin languages) |
Ctrl + Shift + K |
| Select input tools | Ctrl + Alt + Shift + K |
| Tool finder (formerly Search the menus) | Alt + / |
| Convert range to table | Ctrl + Alt + T |
|
Format cells |
|
| Bold | Ctrl + B |
| Underline | Ctrl + U |
| Italic | Ctrl + I |
| Strikethrough | Alt + Shift + 5 |
| Centre align | Ctrl + Shift + E |
| Left align | Ctrl + Shift + l |
| Right align | Ctrl + Shift + R |
| Apply top border | Alt + Shift + 1 |
| Apply right border | Alt + Shift + 2 |
| Apply bottom border | Alt + Shift + 3 |
| Apply left border | Alt + Shift + 4 |
| Remove borders | Alt + Shift + 6 |
| Apply outer border |
Alt + Shift + 7 |
| Insert link | Ctrl + K |
| Insert time | Ctrl + Shift + ; |
| Insert date | Ctrl + ; |
| Insert date and time | Ctrl + Alt + 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 | Ctrl + \ |
|
Navigate spreadsheet |
|
| Move to beginning of row | Search + Left arrow |
| Move to end of row | Search + Right arrow |
| Move to first cell in row with data | Ctrl + Left arrow |
| Move to top left of sheet | Ctrl + Search + Left arrow |
| Move to last cell in row with data | Ctrl + Right arrow |
| Move to bottom right of sheet | Ctrl + Search + Right arrow |
| Scroll to active cell | Ctrl + Backspace |
| Move to beginning of sheet | Ctrl + Search + Left arrow |
| Move to end of sheet | Ctrl + Search + Right arrow |
| Move to next sheet | Ctrl + Shift + Search + Down arrow |
| Move to previous sheet | Ctrl + Shift + Search + Up arrow |
| Display list of sheets | Alt + Shift + K |
| Open hyperlink | Alt + Enter |
| Open Explore |
Ctrl + Alt + Shift + I |
| Go to side panel | Alt + Shift + . Alt + Shift + , |
| Move focus out of spreadsheet | Ctrl + Alt + Shift + M |
| Move to quicksum (when a range of cells is selected) |
Alt + Shift + Q |
| Move focus to pop-up (for links, bookmarks and images) |
holding Ctrl + Alt, press E, then P |
| Open drop-down menu on filtered cell | Ctrl + Alt + R |
| Open revision history | Ctrl + Alt + Shift + H |
| Close drawing editor | Ctrl + Esc Shift + Esc |
|
Edit notes and comments |
|
| Insert/edit note | Shift + Search + 2 |
| Insert/edit comment | Ctrl + Alt + M |
| Open comment discussion thread | Ctrl + Alt + Shift + A |
| Enter current comment | holding Ctrl + Alt, press E, then C |
| Move to next comment | holding Ctrl + Alt, press N, then C |
| Move to previous comment | holding Ctrl + Alt, press P, then C |
|
Use keyboard shortcuts on selected comments |
|
| 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 |
|
| File menu | Alt + F |
| Edit menu | Alt + E |
| View menu | Alt + V |
| Insert menu | Alt + I |
| Format menu | Alt + O |
| Data menu | Alt + D |
| Tools menu | Alt + T |
| Open insert menu | Ctrl + Alt + = (with cells selected) |
| Open delete menu | Ctrl + Alt + - (with cells selected) |
| Form menu (present when the spreadsheet is connected to a form) |
Alt + M |
| Add-ons menu | Alt + N |
| Help menu | Alt + H |
| Accessibility menu (present when screen reader support is enabled) |
Alt + A |
| Sheet menu (copy, delete and other sheet actions) |
Ctrl + Shift + S |
| Context menu |
Ctrl + Shift + \ |
| Table column menu | Ctrl + Alt + \ |
|
Add or change rows and columns |
|
| Insert rows above | Ctrl + Alt + = (with rows selected) Alt + I, then R, then R |
| Insert rows below | Alt + I, then R, then B |
| Insert columns to the left | Ctrl + Alt + = (with columns selected) Alt + I, then C, then C |
| Insert columns to the right | Alt + I, then C, then O |
| Delete rows | Ctrl + Alt + - (with rows selected) Alt + E, then D, then D |
| Delete columns | Ctrl + Alt + - (with columns selected) Alt + E, then D, then E |
| Hide rows | Ctrl + Alt + 9 |
| Unhide rows | Ctrl + Shift + 9 |
| Hide columns | Ctrl + Alt + 0 |
| Unhide columns | Ctrl + Shift + 0 |
| Group rows or columns | Alt + Shift + Right arrow |
| Ungroup rows or columns | Alt + Shift + Left arrow |
| Expand grouped rows or columns | Alt + Shift + Down arrow |
| Collapse grouped rows or columns | Alt + Shift + Up arrow |
|
Use formulas |
|
| Show all formulae | Ctrl + ~ |
| Insert array formula | Ctrl + Shift + Enter |
| Collapse an expanded array formula | Ctrl + E |
| Show/hide formula help (when entering a formula) |
Shift + Search + 1 |
| Full/compact formula help (when entering a formula) | Search + 1 |
| Absolute/relative references (when entering a formula) | Search + 4 |
| Toggle formula result previews (when entering a formula) | Search + 9 |
| Resize formula bar (move up or down) |
Ctrl + Shift + Up arrow and Ctrl + Shift + Down arrow |
|
Toggle formula range selection (when entering a formula) |
F2 |
|
Help for screen readers |
|
| Turn on screen reader support Learn more about using Google Sheets with a screen reader |
Ctrl + Alt + Z |
| Enable braille support | Ctrl + Alt + H |
| Read column | Ctrl + Alt + Shift + C |
| Read row | Ctrl + Alt + Shift + R |
Use other spreadsheet shortcuts
You can use shortcuts for spreadsheets made by other companies in Google Sheets.
- On your computer, open a spreadsheet at sheets.google.com.
- At the top, click Help
Keyboard shortcuts.
- At the bottom of the window, turn on Enable compatible spreadsheet shortcuts.
Keyboard shortcuts.Related articles