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 |
|
Format cells |
|
| Bold | Ctrl b |
| Underline | Ctrl u |
| Italic | Ctrl i |
| Strikethrough | Alt Shift 5 |
| Center 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 popup (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 formulas | 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 * |
| Displays or hides the menus | ⌘ Option R Ctrl Shift F |
|
Format cells |
|
| Bold |
⌘ b |
| Underline |
⌘ u |
| Italic | ⌘ i ⌘ 3 Ctrl 3 |
| Strikethrough |
⌘ Shift x |
| 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 |
| 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 popup (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" dialog | 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 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 |
|
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 / |
|
Format cells |
|
| Bold | Ctrl b |
| Underline | Ctrl u |
| Italic | Ctrl i |
| Strikethrough | Alt Shift 5 |
| Center 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 popup (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 formulas | 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.
Related articles