Excel File Recovery

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 »

4 Quick Methods to Search for Non-Empty Cells in Your Excel Worksheet

Some blank cells in a worksheet are actually not empty. But their existence will make you confused. Therefore, you need to find those non-empty cells in your Excel worksheet. There are many conditions that a cell will be non-empty while the content in it is invisible. For example, a formula will return null value, the font color in the cell is the same as the fill color, or the invisible values that returned by VBA macros. All those reasons can make the content invisible. But actually those...

Read more »

2 Effective Methods to Convert Older Excel File to New Format

In older formats of Excel workbooks, you cannot use some new features. Thus, here we provide two effective methods to convert the file formats. If the format of a file is an older version, you cannot use the new features in newer version of Excel application. However, new features can save you a lot of time and energy. Therefore, in order to use the newer features, you need to convert file formats. And below are two different methods to save Excel workbooks as newer file formats. Method 1:...

Read more »