Common keyboard shortcuts for Google Sheets

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.

• Download Google Sheets for Android.
• Download Google Sheets for iOS.
• Access Google Sheets.

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.