Excel Solutions

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 »

How to Enable and Disable Macros in Your Excel

The security of macro is a key element for the security of Excel. Therefore, today we will talk about how to enable/disable macros in your Excel. Macro is very effective in dealing with complex tasks. However, there will also be dangers in some macro-enabled workbooks. If you run those macros unintentionally, your Excel could be damaged. Hence, correctly enabling/disabling macros macro is rather important. Open the Macro Settings Dialog Before you modify the settings, you need to open the...

Read more »