Office Solutions

How to Find Values in Other Worksheets via VLOOKUP Function

In your worksheet, you will certainly create multiple worksheets in an Excel file. And sometimes certain values need to be used in another sheet. Therefore, you may use the VLOOKUP function to quickly find the values in other worksheets. In an Excel file, the data in worksheets is sometimes not independent. And in one worksheet, you will need to use the values in other sheets. Copy and paste is one way. However, if you need to find certain values in a huge amount of data, you will spend a...

Read more »

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 »