Find and replace

`Ctrl` + `H`

All hotkeys for Google Sheets

Common actions Select column	`Ctrl` + `Space`
Common actions Select row	`↑ Shift` + `Space`
Common actions Select all	`Ctrl` + `A`
Common actions Select all	`Ctrl` + `↑ Shift` + `Space`
Common actions Undo	`Ctrl` + `Z`
Common actions Redo	`Ctrl` + `Y`
Common actions Redo	`Ctrl` + `↑ Shift` + `Z`
Use formulas (when entering a formula) Absolute/relative references	`F4`
Common actions Find	`Ctrl` + `F`
Common actions Find and replace	`Ctrl` + `H`
Common actions Fill range	`Ctrl` + `⤶ Enter`
Common actions Fill down	`Ctrl` + `D`
Common actions Fill right	`Ctrl` + `R`
Common actions Save (every change is saved automatically in Drive)	`Ctrl` + `S`
Common actions Open	`Ctrl` + `O`
Common actions Print	`Ctrl` + `P`
Common actions Copy	`Ctrl` + `C`
Common actions Cut	`Ctrl` + `X`
Common actions Paste	`Ctrl` + `V`
Common actions Paste values only	`Ctrl` + `↑ Shift` + `V`
Common actions Show common keyboard shortcuts	`Ctrl` + `/`
Common actions Insert new sheet	`↑ Shift` + `F11`
Common actions Compact controls	`Ctrl` + `↑ Shift` + `F`
Common actions Input tools on/off (available in spreadsheets in non-Latin languages)	`Ctrl` + `↑ Shift` + `K`
Common actions Select input tools	`Ctrl` + `Alt` + `↑ Shift` + `K`
Format cells Bold	`Ctrl` + `B`
Format cells Underline	`Ctrl` + `U`
Format cells Italic	`Ctrl` + `İ`
Format cells Strikethrough	`Alt` + `↑ Shift` + `5`
Format cells Center align	`Ctrl` + `↑ Shift` + `E`
Format cells Left align	`Ctrl` + `↑ Shift` + `L`
Format cells Right align	`Ctrl` + `↑ Shift` + `R`
Format cells Apply top border	`Alt` + `↑ Shift` + `1`
Format cells Apply right border	`Alt` + `↑ Shift` + `2`
Format cells Apply bottom border	`Alt` + `↑ Shift` + `3`
Format cells Apply left border	`Alt` + `↑ Shift` + `4`
Format cells Remove borders	`Alt` + `↑ Shift` + `6`
Format cells Apply outer border	`Alt` + `↑ Shift` + `7`
Format cells Apply outer border	`Ctrl` + `↑ Shift` + `7`
Format cells Insert link	`Ctrl` + `K`
Format cells Insert time	`Ctrl` + `↑ Shift` + `;`
Format cells Insert date	`Ctrl` + `;`
Format cells Insert date and time	`Ctrl` + `Alt` + `↑ Shift` + `;`
Format cells Format as decimal	`Ctrl` + `↑ Shift` + `1`
Format cells Format as time	`Ctrl` + `↑ Shift` + `2`
Format cells Format as date	`Ctrl` + `↑ Shift` + `3`
Format cells Format as currency	`Ctrl` + `↑ Shift` + `4`
Format cells Format as percentage	`Ctrl` + `↑ Shift` + `5`
Format cells Format as exponent	`Ctrl` + `↑ Shift` + `6`
Format cells Clear formatting	`Ctrl` + `\`
Navigate spreadsheet Move to beginning of row	`Home`
Navigate spreadsheet Move to beginning of sheet	`Ctrl` + `Home`
Navigate spreadsheet Move to end of row	`End`
Navigate spreadsheet Move to end of sheet	`Ctrl` + `End`
Navigate spreadsheet Scroll to active cell	`Ctrl` + `⬅ Backspace`
Navigate spreadsheet Move to next sheet	`Ctrl` + `Shift` + `Page Down`
Navigate spreadsheet Move to previous sheet	`Ctrl` + `Shift` + `Page Up`
Navigate spreadsheet Display list of sheets	`Alt` + `↑ Shift` + `K`
Navigate spreadsheet Open hyperlink	`Alt` + `⤶ Enter`
Navigate spreadsheet Open Explore	`Alt` + `↑ Shift` + `X`
Navigate spreadsheet Move focus out of spreadsheet	`Ctrl` + `Alt` + `↑ Shift` + `M`
Navigate spreadsheet Move to quicksum (when a range of cells is selected)	`Alt` + `↑ Shift` + `Q`
Navigate spreadsheet Move focus to popup (for links, bookmarks, and images)	`Ctrl` + `Alt` then `E` then `P`
Navigate spreadsheet Open drop-down menu on filtered cell	`Ctrl` + `Alt` + `R`
Navigate spreadsheet Open revision history	`Ctrl` + `Alt` + `↑ Shift` + `H`
Navigate spreadsheet Close drawing editor	`↑ Shift` + `Esc`
Edit notes and comments Insert/edit note	`↑ Shift` + `F2`
Edit notes and comments Insert/edit comment	`Ctrl` + `Alt` + `M`
Edit notes and comments Open comment discussion thread	`Ctrl` + `Alt` + `↑ Shift` + `A`
Edit notes and comments Enter current comment	`Ctrl` + `Alt` then `E` then `C`
Edit notes and comments Move to next comment	`Ctrl` + `Alt` then `N` then `C`
Edit notes and comments Move to previous comment	`Ctrl` + `Alt` then `P` then `C`
Open a menu (in Google Chrome) File menu	`Alt` + `F`
Open a menu (in other browsers) File menu	`Alt` + `↑ Shift` + `F`
Open a menu (in Google Chrome) Edit menu	`Alt` + `E`
Open a menu (in other browsers) Edit menu	`Alt` + `↑ Shift` + `E`
Open a menu (in Google Chrome) View menu	`Alt` + `V`
Open a menu View menu (in other browsers)	`Alt` + `↑ Shift` + `V`
Open a menu (in Google Chrome) Insert menu	`Alt` + `I`
Open a menu (in other browsers) Insert menu	`Alt` + `↑ Shift` + `İ`
Open a menu Format menu (in Google Chrome)	`Alt` + `O`
Open a menu (in other browsers) Format menu	`Alt` + `↑ Shift` + `O`
Open a menu Data menu (in Google Chrome)	`Alt` + `D`
Open a menu (in other browsers)	`Alt` + `↑ Shift` + `D`
Open a menu Tools menu (in Google Chrome)	`Alt` + `T`
Open a menu (in other browsers)	`Alt` + `↑ Shift` + `T`
Insert, delete, hide, or unhide rows or columns (with columns selected) Insert columns to the left	`Ctrl` + `Alt` + `↑ Shift` + `=`
Insert, delete, hide, or unhide rows or columns (with columns selected) Insert columns to the left	`Ctrl` + `Alt` + `=`
Insert, delete, hide, or unhide rows or columns (with columns selected) Delete columns	`Ctrl` + `Alt` + `-`
Open a menu (in Google Chrome) Form menu	`Alt` + `M`
Open a menu (other browsers. Present when the spreadsheet is connected to a form) Form menu	`Alt` + `↑ Shift` + `M`
Open a menu (in Google Chrome) Add-ons menu	`Alt` + `N`
Open a menu (in other browsers) Add-ons menu	`Alt` + `↑ Shift` + `N`
Open a menu (in Google Chrome) Help menu	`Alt` + `H`
Open a menu (in other browsers) Help menu	`Alt` + `↑ Shift` + `H`
Open a menu (in Google Chrome) Accessibility menu	`Alt` + `A`
Open a menu (in other browsers. Present when screen reader support is enabled) Accessibility menu	`Alt` + `↑ Shift` + `A`
Open a menu Sheet menu (copy, delete, and other sheet actions)	`Alt` + `↑ Shift` + `S`
Open a menu Context menu	`Ctrl` + `↑ Shift` + `\`
Insert, delete, hide, or unhide rows or columns (in Google Chrome) Insert rows above	`Alt` + `I` then `R`
Insert, delete, hide, or unhide rows or columns (in other browsers) Insert rows above	`Alt` + `↑ Shift` + `I` then `R`
Insert, delete, hide, or unhide rows or columns (in Google Chrome) Insert rows below	`Alt` + `I` then `W`
Insert, delete, hide, or unhide rows or columns (in other browsers) Insert rows below	`Alt` + `↑ Shift` + `I` then `W`
Insert, delete, hide, or unhide rows or columns (in Google Chrome, with columns selected) Insert columns to the left	`Alt` + `I` then `C`
Insert, delete, hide, or unhide rows or columns (in other browsers, with columns selected) Insert columns to the left	`Alt` + `↑ Shift` + `I` then `C`
Insert, delete, hide, or unhide rows or columns (in Google Chrome) Insert columns to the right	`Alt` + `I` then `O`
Insert, delete, hide, or unhide rows or columns (in other browsers) Insert columns to the right	`Alt` + `↑ Shift` + `I` then `O`
Insert, delete, hide, or unhide rows or columns (in Google Chrome, with rows selected) Delete rows	`Alt` + `E` then `D`
Insert, delete, hide, or unhide rows or columns (in other browsers, with rows selected) Delete rows	`Alt` + `↑ Shift` + `E` then `D`
Insert, delete, hide, or unhide rows or columns (in Google Chrome, with columns selected) Delete columns	`Alt` + `E` then `E`
Insert, delete, hide, or unhide rows or columns (in Google Chrome, with columns selected) Delete columns	`Alt` + `↑ Shift` + `E` then `E`
Insert, delete, hide, or unhide rows or columns Hide row	`Ctrl` + `Alt` + `9`
Insert, delete, hide, or unhide rows or columns Hide column	`Ctrl` + `Alt` + `0`
Insert, delete, hide, or unhide rows or columns Unhide row	`Ctrl` + `↑ Shift` + `9`
Insert, delete, hide, or unhide rows or columns Unhide column	`Ctrl` + `↑ Shift` + `0`
Use formulas Show all formulas	`Ctrl` + `~`
Use formulas Insert array formula	`Ctrl` + `↑ Shift` + `⤶ Enter`
Use formulas Collapse an expanded array formula	`Ctrl` + `E`
Use formulas (when entering a formula) Show/hide formula help	`↑ Shift` + `F1`
Use formulas (when entering a formula) Toggle formula result previews	`F9`
Use formulas Resize formula bar	`Ctrl` + `↑ ↓`
Help for screen readers Turn on screen reader support	`Ctrl` + `Alt` + `Z`
Help for screen readers Read column	`Ctrl` + `Alt` + `↑ Shift` + `C`
Help for screen readers Read row	`Ctrl` + `Alt` + `↑ Shift` + `R`