Excel Solutions

How to Merge Multiple Workbooks to One Workbook via Excel VBA

When you need to collect information from other people, you will receive multiple Excel workbooks. And in this article, we will introduce the methods to merge multiple workbooks by using Excel macro. When you have received multiple workbooks, you will find it hard to manage those files. All the information is separate in those different files. In the image below, you can see that there are several workbooks. In each file, there are the sales volumes of this month. Now you need to input...

Read more »

2 Effective Methods to Spell Check Contents in Your Excel Worksheet

Excel will not add additional mark for incorrect contents. Therefore, you can use the 2 methods in this article to spell check contents in your Excel worksheet. In a word file, you will see some red wavy lines or green wavy lines in certain words. And those lines tell you that there may be some incorrect words or usages. However, in Excel, there is no such mark. In the image below, there is no additional mark in the worksheet. However, this doesn’t mean that all the words in this...

Read more »

3 Methods to Use Checkbox to Show or Hide the Cell Contents in Excel

Sometimes you need to use checkboxes to assist your work. And show certain contents in certain cells according to the values of checkboxes can show information clearer. In this article, we will show you 3 effective methods to show or hide cell contents. In this image below, we have input the checkboxes into the worksheet. And now you need to show certain contents in certain cells. When you check one checkbox, the certain cell needs to hide or show certain contents. And below are 3...

Read more »