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
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.
