All You Need to Know About

Excel Shortcuts & Tips

Learn the many Excel keyboard shortcuts & tips that will make you faster in Excel.

We have the perfect combination of Excel tips, tricks and shortcuts that you can use to increase your productivity by tenfold. See our best Excel shortcuts below!

333 Excel Shortcuts

This is one of our biggest Excel shortcut keys compilation! Microsoft Excel is a powerful tool which has many Excel keyboard shortcuts to make you more efficient!
Instead of memorizing all of these useful Excel keyboard shortcuts, we have compiled an exhaustive list for you so you can apply to your Excel worksheet straight away.
Check out this free video tutorial to see all of the 333 Excel Keyboard Shortcuts in action! Alongside with the video is we have included a downloadable cheat sheet for you so that you can print out all of the Excel Shortcuts right on your desk!

Remove Formulas in Excel

There are times when I have an Excel worksheet full of formulas and I want to hard code the results and remove the formulas completely. So that the values resulting from the Formulas become permanent even if you change the dependent cell values.
This is very easy to do in Excel with the Paste Special option!
Here is our sample worksheet which has the following formulas in Column E. You can see we have a Replace Formula that modifies the old phone numbers.
Excel Shortcuts | MyExcelOnline.com

STEP 1: Select all the cells that have formulas:

STEP 2:Right click and select Copy:

STEP 3: Right click again and select Paste Values:

Now you will see that the values have now become permanent and the formulas are now gone! This shortcut sure beats having to type in the resulting values one by one!

Add Calculator to the Toolbar

There were times when I had to find my Calculator App while I was doing some quick calculations in Excel.
Did you know that you can have a Calculator right inside of Excel?
Excel has a lot of customizations and the Calculator application is just one of them!
You can literally place it on your Excel window, and it is very easy and handy to open whenever you need it:

STEP 1: Click the down arrow on the Excel Toolbar. Go to More Commands.

STEP 2: Select Commands Not in the Ribbon.

STEP 3: Scroll down and select Calculator. Click Add.
This will add the Calculator option to the Excel Quick Access Toolbar.
You could also explore here that there are a lot of options that you could choose from. Feel free to explore them to add to the Quick Access Toolbar!

STEP 4: Click OK.

STEP 5: Your Calculator icon is now ready. Give it a try and enjoy this Excel shortcut!

Remove Leading and Trailing Spaces

Leading spaces at the start of the text and Trailing spaces at the end of the text usually get in the way when we want to perform operations in Excel.
Imagine trying to compare text, and they look identical however these spaces get in the way of getting the right comparison result.
This is our Excel shortcut tip for you to deal with those annoying spaces in a flash!
For example using the TRIM formula:

The spaces get removed with no issues:

However if we have non-breaking spaces, the TRIM formula will not remove these spaces:

The leading space is still there! What gives?
What are non-breaking spaces you ask?
Sometimes data downloaded as text uses non-breaking spaces for formatting purposes. For example, it prevents an automatic line break in between these spaces.
You could see this as being represented by CHAR(160):

Let us see how we can handle this with Excel formulas!

STEP 1: We will use the SUBSTITUTE Formula to remove the non-breaking spaces depicted by CHAR(160)
The goal is to replace the non-breaking spaces with normal spaces.