Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

Useful Excel Tips & Tricks You Should Know

Date:2020-11-23 Author:Sandra

This is a perfect and excellent article If you still use Excel frequently in your work or study, The so-called multi-skills are not pressure. So, today, the author will share some useful Excel tricks. Come and learn!

Skill 1:How to Make Your Excel Data More Intuitive?

Useful Excel Tips & Tricks You Should Know

When you first look at this table, can you quickly find the largest and smallest sales data? You would check and compare these data carefully. And it will take you several seconds.

Useful Excel Tips & Tricks You Should Know

How about this table. You must can quickly find which is the largest data and which is the smallest data. It’s easier than the first table, right? Let’s get to know how to make it.

Step1: Use mouse to select the data.

Step2: Click the [Conditional Formatting] in tool bar.

Step3:Click [Data Bars]

Step4:Choose the color you like or the color you want to make the data be.

Useful Excel Tips & Tricks You Should Know

Skill 2: How to Quickly Enter Recurring Content?

Have you ever encountered this situation? You need to enter the same content repeatedly. You have to type again and again or keep copying and pasting. Actually, we can use the function of autocorrect. For example, every time we enter a URL in a cell, the Excel cell will automatically display https://www.myofficetricks.com

Useful Excel Tips & Tricks You Should Know

Step1: Click [File]

Useful Excel Tips & Tricks You Should Know

Step2: Click the [Option] in the pop-up Window

Useful Excel Tips & Tricks You Should Know

Step3: Click [Proofing] in the Excel Options, and choose [AutoCorrect Options]

Useful Excel Tips & Tricks You Should Know

Step4: Enter the information you need to automatically correct into the corresponding box. Then click [Add] and OK. These all the steps.

Useful Excel Tips & Tricks You Should Know

Skill 3: How to Remove Extra Blank Lines?

Will you delete the blank lines one by one? The author wants to teach you a simple method that even doesn’t need to delete. The way we used is Data Sort. Detailed steps are in the Gif below.

Useful Excel Tips & Tricks You Should Know
Useful Excel Tips & Tricks You Should Know
Useful Excel Tips & Tricks You Should Know
Useful Excel Tips & Tricks You Should Know

Skill 4: How Do You Encrypt Excel Form?

If you have some documents that need to be kept secret or data that you cannot disclose temporarily. It is recommended that you encrypt your form. This can protect your data.

Step1: Click [Save As]

Useful Excel Tips & Tricks You Should Know

Step2: Click on [Tools]

Useful Excel Tips & Tricks You Should Know

Step3: Choose [General Options]

Useful Excel Tips & Tricks You Should Know

Step4: Enter the password.

Useful Excel Tips & Tricks You Should Know
Useful Excel Tips & Tricks You Should Know

Hope these useful Excel tips can help you.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *