Excel File Recovery

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 Change the Case & Capitalization of Texts through Excel Functions

Apart from dealing with data, Excel is also able to deal with information. And now follow us and see how the three functions (UPPER, LOWER, PROPER) work. Of course, in your worksheet, there will be a lot of information. And sometimes, for certain words, you should change their cases. besides, conditions also includes that the first letter of a word should be in uppercase. But if there are many words in your worksheet, it will be very inconvenient to change the form. So here you can use the...

Read more »

How to Merge Multiple Worksheets through Excel VBA

Excel is so popular among people mainly because it combines the function of VBA. Sometimes, a few lines of VBA can achieve a lot of functions. Thus, now we will introduce the VBA to merge multiple worksheets with the same format. In your work, sometimes you need to ask many people some questions through the form of Excel. For example, suppose you are a teacher, and you have sent your students the Excel files. And in this file, students need to make choices on different tasks. And now you...

Read more »