# Useful Excel Tips & Tricks You Should Know

Date：2020-11-23

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?

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.

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.

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

Step1: Click [File]

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

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

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

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

### 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]

Step2: Click on [Tools]

Step3: Choose [General Options]