Keyboard accelerators
Keyboard accelerators let you open menus using special keyboard shortcuts.
The table lists shortcuts for people using Chrome on Windows/Linux. If you’re working in Internet Explorer or Firefox, replace Alt with Alt+Shift. If you’re working on a Mac, replace Alt with Ctrl+Option.
For example, to open the File menu:
- Chrome on Windows/Linux: Alt+F
- Internet Explorer or Firefox on Windows/Linux: Alt+Shift+F
- On a Mac: Ctrl+Option+F
| Menu name | Keyboard accelerator |
| File | Alt + F |
| Edit | Alt + E |
| View | Alt + V |
| Insert | Alt + I |
| Format | Alt + O |
| Data | Alt + D |
| Forms | Alt + M |
| Tools | Alt + T |
| Table | Alt + B |
| Help | Alt + H |
Mnemonics
A mnemonic lets you choose a menu item with the stroke of a single key, and it’s indicated by an underlined letter in a particular menu. After you open a menu using a keyboard accelerator, use a mnemonic to select an item in the menu.
To navigate and choose a menu item using the keyboard:
- Open a menu using a keyboard accelerator (listed in the table above). For example, press Alt+I to open the Insert menu.
- Press the letter on the keyboard associated with a menu item. The letter you should press is underlined in the menu item. For example, press S to insert a new sheet into your spreadsheet.
Keyboard shortcuts
Keyboard shortcuts let you take a particular action in your spreadsheet by pressing a series of keys on your keyboard. If you use a Mac, you can use the shortcuts below by replacing Ctrl with Command key (or 'Apple' key).
| Editing action | Shortcut |
| Undo | Ctrl + Z |
| Insert time | Ctrl + Shift + : |
| Insert date | Ctrl + ; |
| Fill range | Ctrl + Enter |
| Fill down | Ctrl + D |
| Fill right | Ctrl + R |
| Insert/edit comment | Shift + F2 |
| Redo | Ctrl + Y |
| Edit a cell | F2 or Enter (Fn + F2 on a Mac) |
| Movement action | Shortcut |
| Move to start of row | Home (Fn + Left arrow on a Mac) |
| Move to beginning of sheet | Ctrl + Home (Cmd + Fn + Left arrow on a Mac) |
| Move to end of row | End (Fn + Right arrow on a Mac) |
| Move to end of sheet | Ctrl + End |
| Move to next sheet | Ctrl + Shift + PageDown (Cmd + Shift + Fn + Down arrow on a Mac) |
| Move to previous sheet | Ctrl + Shift + PageUp |
| Scroll to active cell | Ctrl + Backspace |
| Find & replace | Ctrl + F |
| Menus | Shortcut |
| Show context menu | Ctrl + Shift + \ |
| Show sheet list | Alt + Shift + K |
| Display sheet menu | Alt + Shift + S |
| Formatting action | Shortcut |
| Bold | Ctrl + B |
| Underline | Ctrl + U |
| Italic | Ctrl + I |
| Strikethrough | Alt + Shift + 5 |
| Apply outer border | Alt + Shift + 7 |
| Remove borders | Alt + Shift + 6 |
| Apply top border | Alt + Shift + 1 |
| Apply bottom border | Alt + Shift + 3 |
| Apply left border | Alt + Shift + 4 |
| Apply right border | Alt + Shift + 2 |
| Format as currency | Ctrl + Shift + 4 |
| Format as percentage | Ctrl + Shift + 5 |
| Format as exponent | Ctrl + Shift + 6 |
| Format as date | Ctrl + Shift + 3 |
| Format as time | Ctrl + Shift + 2 |
| Format as decimal | Ctrl + Shift + 1 |
| Selection action | Shortcut |
| Select column | Ctrl + Space (Mac and PC) |
| Select row | Shift + Space |
| Select all | Ctrl + Shift + Space |
| Select active region | Ctrl + Shift + 8 |
| Insertion action | Shortcut |
| Insert array formula | Ctrl + Shift + Enter |
| Add new sheet | Shift + F11 |
| File commands | Shortcut |
| Save | Ctrl + S |
| Open | Ctrl + O |
| Make a copy | Ctrl + Shift + S |
| Ctrl + P |
| View | Shortcut |
| Show all formulas | Ctrl + ` (Mac and PC) |
| Compact controls | Ctrl + Shift + F (Mac and PC) |
| Navigation | Shortcut |
| Chat | Shift + Esc |
| Open hyperlink | Alt + Enter |
| Help | Shortcut |
| Open documentation (new window) | Shift + F1 |
| Show shortcuts help pop-up | Ctrl + / |
| Enable ARIA/JAWS screenreader | Alt + Shift + ~ |