Google Spreadsheet Keyboard Shortcuts – Learn How to work faster

Google spreadsheet is a powerful tool on workplace and using google spreadsheet keyboard shortcuts save your time as well as helps you to work smarter.

Google spreadsheet keyboard shortcuts details are shown below-

1. Movement within worksheet

 

Arrow Keys Move one cell up, down, left, or right
Tab Move one cell to the right
End Move to the end of the row
Shift+Tab Move one cell to the left
Ctrl+Arrow Left / Ctrl+Arrow Right Go to left-most / right-most cell in current row
Ctrl+Arrow Down / Ctrl+Arrow Up Go to bottom-most / to-most cell in current column
Ctrl+Page Down / Ctrl+Page Up Move to next / move to previous worksheet
Alt+Page Down / Alt+Page Up Move one screen to the right / one screen to the left
Ctrl+Backspace Scroll to the active cell when multiple cells are selected
Ctrl+Shift+Page Up/Page Down Switch sheets
Home Move to the beginning of the row

2. Movement within a selected range

Enter Move from top to bottom within the selected range
Shift+Enter Move from bottom to top within the selected range
Tab Move from left to right within the selected range. If cells in a single column are selected, move down.
Shift+Tab Move from right to left within the selected range. If cells in a single column are selected, move up.

3. Entering/Editing data

Ctrl+a Select the all / entire worksheet
Ctrl+b Bold the contents of the selected cell
Ctrl+c Copy the contents of the selected cell
Ctrl+f Find words or phrases within the spreadsheet
Ctrl+i Italicize the contents of the selected cell
Ctrl+p Print
Ctrl+r Copy the content of the selected cell right (used in combo with Shift + arrow)
Ctrl+s Save
Ctrl+u Underline the contents of the selected cell
Ctrl+v Paste the contents of the selected cell
Ctrl+x Cut the contents of the selected cell
Ctrl+y Redo the last action
Ctrl+z Undo the last action.
Enter Complete a cell entry and select the cell below
Shift+Enter Complete a cell entry and select the previous cell above
Alt+Enter Start a new line in the same cell
Ctrl+Enter Insert line break in a cell
Tab Complete a cell entry and select the next cell to the right
Shift+Tab Complete a cell entry and select the previous cell to the left
F2 Edit the active cell and position the insertion point at the end of the cell contents
Shift+F2 Edit comment
Esc Cancel cell entry
Backspace Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents
Delete Delete the character to the right of the insertion point, or delete the selection
Ctrl+Space e Select the entire row
Shift+Arrow Keys Manual select
Ctrl+Shift+s Make a copy of the document
Alt+Shift+5 Strikethrough formatting for the contents of the cell
Alt+Shift+& Apply border outline to selected cells
Alt+Shift+_ Remove border outline from selected cells
Alt+Shift+t Apply or remove top border from the selected cells
Alt+Shift+b Apply or remove bottom border from the selected cells
Alt+Shift+r Apply or remove right border from the selected cells
Alt+Shift+l Apply or remove left border from the selected cells

4. Miscellaneous Shortcuts

Ctrl+Shift+Enter Wrap current formula in an Array Formula
Ctrl+; Insert current date into cell
Ctrl+: Insert current time into cell
Ctrl+/ Open keyboard shortcuts help
Ctrl+’ View all formulas

Try it Yourself Here:-

Wrap up-

The google spreadsheet keyword shortcuts helps you the most to make your work easier. These keyboard shortcuts are proven methodology for the workplace. For more how-tos, tech updates stay tuned with Tech Blook.

 Also read:- Mac Keyboard Shortcuts to Save your hours

 

You may also like...

3 Responses

  1. January 22, 2018

    […] Read more: Google Spreadsheet Keyboard Shortcuts – Learn How to work faster […]

    0

Leave a Reply

Your email address will not be published. Required fields are marked *