Excel Solutions

How to Customize the Filter for Your Data in Excel

The filter feature in Excel is very useful. And in this article, we will talk about how to customize the filter for your data in excel. The filter feature is one of the most frequently used features in Excel. It can help you quickly sort out the target area. What’s more, you can also customize the filter intervals. With this feature, your can improve your work efficiency greatly. In this image above, you can see that the date in the first column is totally in a mess. This may be happen...

Read more »

How to Track Changes of Your Workbook in Excel

Excel has many useful features for users. Here we will discuss about the feature track changes in Excel. If your Excel has been modified by other people, you will certainly want to know which cell has changed. And you need to evaluate whether the change is acceptable or not. Thus, you can use the track changes feature in Excel to help you achieve this function. Track Changes Click “File” in the ribbon. And then click “Options”. In the “Excel Options” window, click...

Read more »

2 Methods to Password Protect Your Excel Workbooks (Part II)

In the previous article, we have discussed the first method to set password for Excel. Here we will continue this topic. Except for the first method to set password, you can also use the following way. And we will show you the detail steps. Set Passwords: Method 2 Click “File” in the ribbon. Next click “Protect Workbook”. In the new menu, click the option “Encrypt with Password”. And then input the password into the new pop-up window. Next click “OK”. ...

Read more »