«

»


Google Spreadsheets shortcuts


Keyboard shortcuts for Google spreadsheets surely helps to improve the speed of the work. You feel more easy if you know the excel shortcuts. Almost all shortcut keys are equivalent to microsoft excel shortcuts. Google is in the attempt to make google spreadsheets to compete microsoft excel. Rapidly it is adding powerful features of spreadsheets like google pivot tables.

Google documents

Related : Google Plus keyboard Shortcuts

Movement within worksheets

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

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.

Entering and editing data

Ctrl+A: Select the 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
Crtl+R: Copy the content of the selected cell right
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+spacebar: Select the entire column
Shift+spacebar: Select the entire row
Shift+down, up, left, right arrow key: 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

Miscellaneous google spreadsheet shortcuts

Ctrl+Shift+Enter: Wrap current formula in an ArrayFormula
Alt+Shift+F: Move focus to menu bar
Ctrl+;: Insert current date into cell
Ctrl+:: Insert current time into cell
Ctrl+/: Open keyboard shortcuts help
Ctrl+’: View all formulas

Along with this Google spreadsheets shortcuts you can also read to know useful google spreadsheet tips here.to work more efficiently.


Permanent link to this article: http://www.stepsandtips.com/google/google-spreadsheets-shortcuts/833/

1 comment

  1. Nihar says:

    Thanks for sharing this shortcut keys.

Leave a Reply

Your email address will not be published.

”Bloggers