Learn how to use keyboard Excel shortcuts instead of a mouse and save plenty of time. This posts covers navigating, formatting and locking cells. These are essential Excel skills no matter what. They are certainly great to impress as a consultant but also just to make any Excel work you do much quicker.
Excel shortcuts for navigation
- Use Ctrl + Arrow Keys to jump at the end of your data. Ctrl + arrow key down jumps to end of your data vertically. Ctrl + right arrow key jumps to the end of your data horizontally. Ctrl + up arrow key jumps to the beginning of your data vertically and Ctrl + left arrow key jumps to the left end horizontally of your data (beginning).
- Use Ctrl + Shift + Arrow Keys to highlight data. Use Ctrl + Shift + arrow key down and then Ctrl + Shift arrow key right to highlight all the data in a table.
- Use Ctrl + Page Down to go from worksheet to the next worksheet.
- Use Ctrl + Page Up to go back to your previous worksheet.
Excel shortcuts for formatting data
- Use Ctrl + Shift + 1 for a number with two decimal places.
- Use Ctrl + Shift + $ for currency.
- Use Ctrl + Shift + 5 for percentage.
- Double click on a cell that contains a function to autofill the whole data column with this function
Excel shorcuts for locking data
- Use the $ to before the letter of a column to lock the column.
- Use the $ bevor the number of the row to lock the row.
- Use F4 to lock the whole cell (on a Mac that is cmd + t)
If you know any other essential Excel shortcuts feel free to share them in our Facebook group.