If this article has caught your eye you are probably a frequent Excel user, like me. To to help you get faster in Excel I prepared a list of 10 shortcuts that will also make you feel more in control, because they all start with CTRL :).
- CTRL + SPACE: select the entire column
- CTRL + SHIFT + {: select all the cells that have been referenced in the cell we are at
- CTRL + ‘: copy the formula from the above cell
- CTRL + 9: hide row; CTRL + 0: hide column
- CTRL + F1: hide / show ribbon
- CTRL + ;: insert the date we are at
- CTRL + SHIFT + :: insert the time
- CTRL + –: delete cell / row / column
- CTRL + SHIFT + u: enlarge / minimize the formula bar
- CTRL + F4: close the workbook that we are in, Excel remains open
Hope they are useful, if you know other useful excel shortcuts please let me know in the comments section.