Google Sheets Keyboard Shortcuts
Complete keyboard shortcut reference for Google Sheets on MacWindowsLinux.
Selection
| Action | Shortcut |
|---|---|
| Select entire column | CtrlSpaceCtrlSpaceCtrlSpace |
| Select entire row | ShiftSpaceShiftSpaceShiftSpace |
| Select all cells | CmdACtrlACtrlA |
| Extend selection by one cell | ShiftArrowShiftArrowShiftArrow |
| Extend selection to edge of data region | CmdShiftArrowCtrlShiftArrowCtrlShiftArrow |
| Extend selection to beginning of row | ShiftFnLeftShiftHomeShiftHome |
| Extend selection to beginning of sheet | CmdShiftFnLeftCtrlShiftHomeCtrlShiftHome |
| Extend selection to end of sheet | CmdShiftFnRightCtrlShiftEndCtrlShiftEnd |
| Select current and next sheet | CmdShiftPageDownAltShiftPageDownAltShiftPageDown |
| Add adjacent cells to selection | ShiftClickShiftClickShiftClick |
Editing
| Action | Shortcut |
|---|---|
| Edit current cell | F2F2F2 |
| Copy | CmdCCtrlCCtrlC |
| Cut | CmdXCtrlXCtrlX |
| Paste | CmdVCtrlVCtrlV |
| Paste values only | CmdShiftVCtrlShiftVCtrlShiftV |
| Undo | CmdZCtrlZCtrlZ |
| Redo | CmdYCtrlYCtrlY |
| Find | CmdFCtrlFCtrlF |
| Find and replace | CmdHCtrlHCtrlH |
| Fill range down | CmdDCtrlDCtrlD |
| Fill range right | CmdRCtrlRCtrlR |
| Clear cell content | DeleteDeleteDelete |
| Insert link | CmdKCtrlKCtrlK |
| Insert current date | Cmd;Ctrl;Ctrl; |
| Insert current time | CmdShift;CtrlShift;CtrlShift; |
Formatting
| Action | Shortcut |
|---|---|
| Bold | CmdBCtrlBCtrlB |
| Italic | CmdICtrlICtrlI |
| Underline | CmdUCtrlUCtrlU |
| Strikethrough | CmdShiftXAltShift5AltShift5 |
| Center align | CmdShiftECtrlShiftECtrlShiftE |
| Left align | CmdShiftLCtrlShiftLCtrlShiftL |
| Right align | CmdShiftRCtrlShiftRCtrlShiftR |
| Apply top border | AltShift1AltShift1AltShift1 |
| Apply right border | AltShift2AltShift2AltShift2 |
| Apply bottom border | AltShift3AltShift3AltShift3 |
| Apply left border | AltShift4AltShift4AltShift4 |
| Remove borders | AltShift6AltShift6AltShift6 |
| Apply outer border | AltShift7AltShift7AltShift7 |
| Clear formatting | Cmd\Ctrl\Ctrl\ |
Formulas
| Action | Shortcut |
|---|---|
| Insert formula | === |
| Toggle formula display | Ctrl`Ctrl`Ctrl` |
| Insert array formula | CmdShiftEnterCtrlShiftEnterCtrlShiftEnter |
| Toggle absolute/relative reference | F4F4F4 |
| Insert SUM function | CmdShiftTAlt=Alt= |
| Accept autocomplete suggestion | TabTabTab |
| Dismiss autocomplete suggestion | EscapeEscapeEscape |
| Show all formulas | Ctrl`Ctrl`Ctrl` |
| Insert function arguments info | ShiftF1ShiftF1ShiftF1 |
| Toggle formula help | ShiftF1ShiftF1ShiftF1 |
Rows & Columns
| Action | Shortcut |
|---|---|
| Insert rows above | CmdOption=CtrlAlt=CtrlAlt= |
| Insert columns to the left | CmdOption=CtrlAlt=CtrlAlt= |
| Delete rows | CmdOption-CtrlAlt-CtrlAlt- |
| Delete columns | CmdOption-CtrlAlt-CtrlAlt- |
| Hide row | CmdOption9CtrlAlt9CtrlAlt9 |
| Unhide row | CmdShift9CtrlShift9CtrlShift9 |
| Hide column | CmdOption0CtrlAlt0CtrlAlt0 |
| Unhide column | CmdShift0CtrlShift0CtrlShift0 |
| Group rows or columns | OptionShiftRightAltShiftRightAltShiftRight |
| Ungroup rows or columns | OptionShiftLeftAltShiftLeftAltShiftLeft |
| Expand grouped rows or columns | OptionShiftDownAltShiftDownAltShiftDown |
| Collapse grouped rows or columns | OptionShiftUpAltShiftUpAltShiftUp |
Sheet Management
| Action | Shortcut |
|---|---|
| Insert new sheet | ShiftF11ShiftF11ShiftF11 |
| Move to next sheet | CmdShiftPageDownCtrlPageDownCtrlPageDown |
| Move to previous sheet | CmdShiftPageUpCtrlPageUpCtrlPageUp |
| Rename current sheet | F2F2F2 |
| Open sheet list | AltShiftKAltShiftKAltShiftK |
| Open Explore panel | OptionShiftXAltShiftXAltShiftX |
| Open revision history | CmdOptionShiftHCtrlAltShiftHCtrlAltShiftH |
| Toggle input tools | CmdShiftKCtrlShiftKCtrlShiftK |
| Open Apps Script editor | CmdOptionShiftICtrlAltShiftICtrlAltShiftI |
| Turn on screen reader support | CmdOptionZCtrlAltZCtrlAltZ |
No shortcuts found. Try a different search term.
Frequently Asked Questions
How do I view all keyboard shortcuts in Google Sheets?
Press Cmd+/ on Mac or Ctrl+/ on Windows/Linux while in a Google Sheets spreadsheet. This opens the built-in keyboard shortcuts reference panel showing all available shortcuts.
How do I quickly insert the current date or time in Google Sheets?
Press Cmd+; (Mac) or Ctrl+; (Windows/Linux) to insert today's date. For the current time, use Cmd+Shift+; (Mac) or Ctrl+Shift+; (Windows/Linux). These insert static values that do not update automatically.
How do I switch between absolute and relative cell references in a formula?
While editing a formula, place the cursor on a cell reference and press F4 to cycle through reference types: A1 to $A$1 (absolute), then $A1 (mixed column), then A$1 (mixed row), and back to A1 (relative).
What is the fastest way to navigate large spreadsheets in Google Sheets?
Use Cmd+Arrow keys (Mac) or Ctrl+Arrow keys (Windows/Linux) to jump to the edge of data regions. Press Cmd+Home (Mac) or Ctrl+Home (Windows/Linux) to go back to cell A1. You can also press Cmd+G or Ctrl+G to go to a specific cell.
How do I paste only values without formatting in Google Sheets?
Press Cmd+Shift+V on Mac or Ctrl+Shift+V on Windows/Linux to paste values only. This strips all formatting, formulas, and links, pasting only the displayed cell values from the copied range.