Shortcuts and Tricks to Save Time in Excel

Excel tricks to save time

Working with Excel worksheets can be time-consuming, but we have put together 5 amazing tricks and shortcuts that will save you a lot of time in Excel

We are going to look at the following

Getting Current Data and Time

Removing duplicates from your data

Flash Fill

Text to columns

Column and Rows auto fit

You can watch the entire video on YouTube

https://youtu.be/nANADksUbnk

Getting Current Data and Time

To get the current Date, Hold the CTRL button and press the semi-colon (;) button. To get the current time, hold the CTRL button, press the SHIFT button, and the semi-colon button (;).

Removing duplicates from your data

To remove duplicates, select the data that you want to clean, go to the data tab, go on “Remove Duplicates”, click next and click ok. Excel will show you how many duplicates have been found and removed and how many unique values remain.

Flash Fill

Flash fill will help you quickly separate your data in one column and fill it in many other columns. Go into the columns that you want to fill, enter the first row manually, then fill the rest of the column by holding the CTRL button and pressing E. Repeat that for each column.

Text to columns

In order to separate your data into two different columns, select the data you are interested in, then go to the data tab, click on “Text to Columns”, then choose delimited. Go ahead and choose a delimiter that will be used to separate your data.

If your data is separated by a comma, space, etc. choose that delimiter and click ok. your data will be separated.

Column and Rows auto fit

if your data is not fitting properly into rows and columns, you can easily make it fit with two simple commands.

Press ALT, H, O, and I to automatically fit your columns

Press ALT, H, O,and A to automatically fit your rows.

Shortcuts and Tricks to Save Time in Excel
Scroll to top