Excel shortcuts 1

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.

🎓Rookie way

Select a row > Right click > Insert

excel shortcuts excel shortcut keys excel shortcut keys pdf excel insert row shortcut New sheet in excel shortcut New sheet in excel shortcut select all add row delete row pivot table vlookup

💻Expert way

Select row (Shift + Space bar) > Add row (Ctrl + “+”)

excel shortcuts excel shortcut keys excel shortcut keys pdf excel insert row shortcut New sheet in excel shortcut New sheet in excel shortcut select all add row delete row pivot table vlookup

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.

🎓Rookie way

Select a row > Right click > Delete

excel shortcuts excel shortcut keys excel shortcut keys pdf excel insert row shortcut New sheet in excel shortcut New sheet in excel shortcut select all add row delete row pivot table vlookup

💻Expert way

Select row (Shift + Space bar) > Delete row (Ctrl + “-”)

excel shortcuts excel shortcut keys excel shortcut keys pdf excel insert row shortcut New sheet in excel shortcut New sheet in excel shortcut select all add row delete row pivot table vlookup

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:

🎓Rookie way

Click on the top left corner – see the red square.

All the cells in the sheet will be selected

excel shortcuts excel shortcut keys excel shortcut keys pdf excel insert row shortcut New sheet in excel shortcut New sheet in excel shortcut select all add row delete row pivot table vlookup

💻Expert way

Click anywhere on the excel sheet and Ctrl + a

excel shortcuts excel shortcut keys excel shortcut keys pdf excel insert row shortcut New sheet in excel shortcut New sheet in excel shortcut select all add row delete row pivot table vlookup

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)

🎓Rookie way

Click on + button on the bottom left side of the excel – see red square below

excel shortcuts excel shortcut keys excel shortcut keys pdf excel insert row shortcut New sheet in excel shortcut New sheet in excel shortcut select all add row delete row pivot table vlookup

💻Expert way

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:

excel shortcuts excel shortcut keys excel shortcut keys pdf excel insert row shortcut New sheet in excel shortcut New sheet in excel shortcut select all add row delete row pivot table vlookup

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.

🎓Rookie way

Clicking with your mouse on the different excel sheets

excel shortcuts excel shortcut keys excel shortcut keys pdf excel insert row shortcut New sheet in excel shortcut New sheet in excel shortcut select all add row delete row pivot table vlookup

💻Expert way

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

excel shortcuts excel shortcut keys excel shortcut keys pdf excel insert row shortcut New sheet in excel shortcut New sheet in excel shortcut select all add row delete row pivot table vlookup

See below where you can find these keys (Ctrl + Page Down , Ctrl + Page Up) on your keyboard:

Keyboard Page up Page down Pg Up Pg Dn

If you want to learn more excel shortcuts – click here.

Leave a Comment