Google Sheets is an online spreadsheet creator that allows users to create and edit spreadsheet files quickly and conveniently. Similar to Google Docs , Google Sheets also has a lot of keyboard shortcuts to help users enter data faster.
So invite you to follow the article below to grasp the list of common shortcuts on Google Sheets spreadsheet application:
Common keyboard shortcuts for Google Sheets on your computer
General action shortcuts:
- Ctrl + Space: Select column.
- Shift + Space: Select row.
- Ctrl + A or Ctrl + Shift + Space: Select all.
- Ctrl + Shift + Backspace: Hide the selected cell Background.
- Ctrl + Z ( Undo) : Return.
- Ctrl + Y or Ctrl + Shift + Z or F4 ( Redo) : Repeat.
- Ctrl + F: Search.
- Ctrl + H: Search and replace.
- Ctrl + Enter: Fill range.
- Ctrl + D: Fill down.
- Ctrl + R: Fill right
- Ctrl + S: Save.
- Ctrl + O: Open the saved file.
- Ctrl + P: Print.
- Ctrl + C: Copy.
- Ctrl + X: Cut.
- Ctrl + V: Paste.
- Ctrl + Shift + V: Paste the value.
- Ctrl + /: Display keyboard shortcuts.
- Shift + F11: Insert a new Sheet.
- Ctrl + Shift + F: Adjust Compact.
- Ctrl + Shift + K: Turns the Input Tool on / off.
- Ctrl + Alt + Shift + K: Select the Input Tool.
Cell format keyboard shortcuts:
- Ctrl + B: Bold.
- Ctrl + U: Underline.
- Ctrl + I: Italicize.
- Alt + Shift + 5: Strikethrough.
- Ctrl + Shift + E: Center .
- Ctrl + Shift + L: Align left.
- Ctrl + Shift + R: Right-align.
- Alt + Shift + 1: Format cell border, table border above.
- Alt + Shift + 2: Format cell border, right table border.
- Alt + Shift + 3: Format cell border, bottom table border.
- Alt + Shift + 4: Format cell border, left table border.
- Alt + Shift + 6: Delete border formatting.
- Alt + Shift + 7: Format cell border, outer table border.
- Ctrl + K: Insert a Hyperlink.
- Ctrl + Shift + ;: Insert time.
- Ctrl + ;: Insert date.
- Ctrl + Shift + 1: Format a decimal number.
- Ctrl + Shift + 2: Format time.
- Ctrl + Shift + 3: Format the date.
- Ctrl + Shift + 4: Curency number format with two decimal places.
- Ctrl + Shift + 5: Percentage number format without decimal places.
- Ctrl + Shift + 6: Exponential type number format with two decimal places.
- Ctrl + \: Delete formatting.
Spreadsheet navigation keyboard shortcuts:
- Home: Move to the top of the row.
- Ctrl + Home: Move to the top of the table.
- End: Move to the end of the row.
- Ctrl + End: Move to the end of the table
- Ctrl + Backspace: Move to the working cell.
- Ctrl + Shift + Page Down: Move to the next panel.
- Ctrl + Shift + Page Up: Move to the previous panel.
- Alt + Shift + K: Display the table list.
- Alt + Enter: Open the Hyperlink link.
- Ctrl + Alt + Shift + M: Move Focus out of the spreadsheet.
- Alt + Shift + Q: Move to Quicksum.
- Hold down Ctrl + Alt, press E, then press P: Move Focus to the Popup Menu.
- Ctrl + Alt + R: Open the menu to filter cell data.
- Ctrl + Alt + Shift + G: Open history.
- Shift + Esc: Open the chat inside the Spreadsheet.
- Shift + Esc: Close the drawing editor.
Comment and comment editing shortcuts:
- Shift + F2: Insert / edit caption.
- Ctrl + Alt + M: Insert / edit comment.
- Ctrl + Alt + Shift + A: Open the discussion topic.
- Hold down Ctrl + Alt, press E, and then press C: Enter current comment.
- Hold down Ctrl + Alt, press N, and then press C: Move to the next comment.
- Hold down Ctrl + Alt, press P, then press C: Move back to previous comment.
Shortcut to open Menu:
Open the File Menu:
- Alt + F: On the Google Chrome browser .
- Alt + Shift + F: In another browser.
Open the Edit Menu:
- Alt + E: On the Google Chrome browser.
- Alt + Shift + E: In another browser.
Open Menu View:
- Alt + V: On the Google Chrome browser.
- Alt + Shift + V: In another browser.
Open the Insert Menu:
- Alt + I: On the Google Chrome browser.
- Alt + Shift + I: In another browser.
Open the Format Menu:
- Alt + O: On Google Chrome browser.
- Alt + Shift + O: In another browser.
Open the Data Menu:
- Alt + D: On the Google Chrome browser.
- Alt + Shift + D: In another browser.
Open Menu Tool:
- Alt + T: On the Google Chrome browser.
- Alt + Shift + T: In another browser.
Open Menu Form:
- Alt + M: On the Google Chrome browser.
- Alt + Shift + M: In another browser.
Open Menu Add-ons:
- Alt + N: On the Google Chrome browser.
- Alt + Shift + N: In another browser.
Open the Help Menu:
- Alt + H: On the Google Chrome browser.
- Alt + Shift + H: In another browser.
Open the Accessibility Menu:
- Alt + A: On the Google Chrome browser.
- Alt + Shift + A: In another browser.
Alt + Shift + S: Open the Sheet Menu.
Ctrl + Shift + \: Open the Context Menu.
Keyboard shortcut for inserting or deleting rows / columns:
Insert the above row:
- Hold Alt + I, then press R: On the Google Chrome browser.
- Hold down Alt + Shift + I, then press R: In another browser.
Insert row below:
- Hold Alt + I, then press W: On the Google Chrome browser.
- Hold down Alt + Shift + I, and then press W: In another browser.
Insert left column:
- Hold Alt + I, and then press C: On the Google Chrome browser.
- Hold down Alt + Shift + I, and then press C: In another browser.
Insert right column:
- Hold Alt + I, then press G: On the Google Chrome browser.
- Hold down Alt + Shift + I, then press G: In another browser.
Delete rows:
- Hold Alt + E, then press D: On the Google Chrome browser.
- Hold down Alt + Shift + E, then press D: In another browser.
Delete columns:
- Hold Alt + E, then press E: On the Google Chrome browser.
- Hold down Alt + Shift + E, then press E: In another browser.
Keyboard shortcuts to open formulas:
- Ctrl + ~: Display all formulas.
- Ctrl + Shift + Enter: Insert an array formula (Array formula).
- Ctrl + E: Collapse the array formula extension.
- Shift + F1: Show / hide the formula assistant menu.
Keyboard shortcuts for screen reading support:
- Ctrl + Alt + Z: Activate the screen reading mode.
- Ctrl + Alt + Shift + C: Read the text in the column.
- Ctrl + Alt + Shift + R: Read the text in the row.