How to Remove the Password of an Encrypted Outlook Data File

Given much potential risks nowadays, it’s highly suggested to encrypt your Outlook data file with password. However, if you forget it, you cannot access the file any more. In this case, follow the methods in this article to remove or recover it. Outlook allows us to protect Outlook data files via passwords. Unquestionably, in face of increasingly sophisticated viruses and spyware, we have to pay attention to the security of Outlook file, which must contain a myriad of our own privacy....

Read more »

How to Add Check Boxes and Option Buttons in Your Excel Worksheets

Excel allows people to set options in worksheets. Thus, today we have the usage of adding check boxes and option buttons into Excel. One of the functions of Excel is questionnaire. For example, if you are a teacher, and you need to know what your student want to do and what fruit they like, you can use the Excel files to collect the result. So you can use the check boxes and option buttons to finish the worksheet. Add Developer Tab in the Ribbon Before you add the check boxes or option...

Read more »

How to Consolidate the Values in Multiple Worksheets

In Excel worksheets, many related values may spread among multiple worksheets. And in this article, we will introduce how to consolidate such values. In an Excel file, there will certainly be many worksheets. For example, in this Excel file, you can see that this is the sales volume of different sellers. Besides, there are five months in the worksheet. And for each month, there is an independent worksheet. But now you want to know the total sales volume of each person. If you add those...

Read more »