Who says you can’t have fun while working? With the help of these viral shortcuts, what normally takes you several clicks and scrolls could be done in a matter of nanoseconds. Try out these Microsoft Excel hacks or bookmark this cheat sheet to save yourself valuable time and effort, whether at home or in the workplace.
Here just a few:
- Shift+Space: Select an entire row
- Ctrl+Space: Select an entire column
- Alt+Semicolon: Select visible cells
- Ctrl+Plus: Insert new row or column above or to the left of selected row or column
- Ctrl+Minus: Delete selected row or column
- Alt+Plus: Calculate the sum of selected cells
- Ctrl+N: Open new workbook
- Ctrl+S: Save current workbook
- F4: Repeat last action
- Ctrl+Up/Down Arrow: Move to the first or last cell in a column
- Ctrl+X: Cut data in selected cell(s)
- Ctrl+9: Hide selected rows
- Ctrl+0: Hide selected columns
- Ctrl+T: Create table
- Shift+Arrow key: Add one cell to selection
- Ctrl+Period: Move active cell clockwise
Find out more here.
-via Mental Floss
Photo: EsaRiutta via Needpix
Newest 1 Comment
Old school : try shift + ctrl + F12
Abusive comment hidden.
(Show it anyway.)