If every day you need to prepare the same report for your manager 😴, you spend an endless amount of time working on it ⏰, all by clicking on the mouse 🖱 and not using any excel shortcut⌨️ … and you enjoy being non-efficient at all 📉. I must say, you are in the wrong place ❌.
On the other hand,
- If you want to considerably reduce the amount of time you spend on your reports,
- You are willing to implement shortcuts that will allow you to navigate faster in excel
- And move from being a rookie into becoming an experienced excel user
This is your place👌
Excel shortcut Keys
Best excel shortcuts
This article will cover the five most important Excel shortcuts you can start to implement today.
My recommendation is NOT to implement all shortcuts at once.
Go step by step and try to implement one shortcut per day.
By the end of your working week, you would have 5 new excel shortcuts in your set of skills.
Excel insert row shortcut
While working on an excel report, you may need to insert a new row in your existing file for various reasons (supporting calculation, missing data … you name it).
There are a few ways to insert a row in excel.
I will show you both the Rookie way and the Expert way.
Select a row > Right click > Insert
Select row (Shift + Space bar) > Add row (Ctrl + “+”)
The new row will appear immediately above the row that you selected.
Delete row shortcut excel
While working on an excel report, opposite in the previous case, you may need to delete a row in your existing sheet.
There are a few ways to delete a row in excel.
See below how you can do it in a Rookie way and – the way I encourage you – how to do it in an advanced way.
Select a row > Right click > Delete
Select row (Shift + Space bar) > Delete row (Ctrl + “-”)
The row that will be deleted will be the one you selected while using the shortcut (Shift + Space bar).
Select all in excel
Working on data and you realized that you must delete all the content on the sheet due to the wrong calculation in one of the formulas.
Learn with me how to select all data in an excel file:
Click on the top left corner – see the red square.
All the cells in the sheet will be selected
Click anywhere on the excel sheet and Ctrl + a
All cells in the excel sheet will be selected and you are able to perform any action – for example, Delete.
Click on the key Delete on your keyboard.
New sheet in excel shortcut
Imagine you are working on fresh data from the current week,
and you want to compare this data vs data from the previous week on the same file
and later, you will be performing some VLOOKUPs (if you want to learn more about vlookup click here)
Click on + button on the bottom left side of the excel – see red square below
Shift + F11 – simple shortcut
A new sheet will appear on the left side of the currently active sheet.
If you did not create any new sheet before, it will appear under the name Sheet2:
Switch between sheets in excel
Imagine you have three excel sheets called, Sheet1, Sheet2 and Sheet3.
If you want to navigate through the sheets, you can do it in several ways.
Clicking with your mouse on the different excel sheets
If you want to go from Sheet1 to Sheet2 use Ctrl + Page Down
If you want to go from Sheet2 to Sheet1 use Ctrl + Page Up
See below where you can find these keys (Ctrl + Page Down , Ctrl + Page Up) on your keyboard:
If you want to learn more excel shortcuts – click here.