Excel shortcuts

Excel advanced training

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.