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 »

How to Quickly Access the Frequently Used Search Queries

If you constantly utilize the same search queries when searching items in Outlook, you can utilize the following methods introduced in this article to rapidly access the queries. My mailbox contains a great amount of emails. It is extremely difficult to search out my target emails. Thus I often use Outlook Search Tools. But I’m considerably averse to entering the repeating search queries. Here are my solutions。 Utilize Outlook Recent Searches Outlook provides us with a useful and handy...

Read more »