Excel File Recovery

How to Find Invisible Hyperlinks in Your Excel Worksheet via VBA

Invisible hyperlinks will sometimes cause trouble to you. And in this article, we will use VBA to find invisible hyperlinks in your Excel worksheet. In this image below, you can see that all the cells have the same format. But there exist some invisible hyperlinks among those cells. When you need to select a cell, you will certainly use your mouse and click it. But if the cell contains an invisible hyperlink, the computer will immediately launch the browser and open the hyperlink. This is...

Read more »

How to Search for Values via HLOOKUP or VLOOKUP Functions in Your Excel Worksheet

We will introduce HLOOKUP function which will return the cell value in a column whose column header matches a specific criterion. We will also compare it with VLOOKUP, another similar function but searching vertically. HLOOKUP function is a seldom mentioned Excel function. Actually this function is a variant of the standard LOOKUP function, and “H” means horizontal. Given a range of tabular data, the function will search in the top row with the specific criterion, and return the value...

Read more »

3 Useful Methods to Make Negative Numbers Red in Your Excel Worksheet

Sometimes you need to highlight negative numbers. And in this article, we will demonstrate 3 useful methods to fulfill this task. Suppose you are analyzing the sales volume of the last year. To make things easier, you need to make all the negative numbers red. If you do this by changing the font color one by one, you will certainly spend a lot of time. And in the coming article, you may learn about 3 effective methods. Method 1: Change Number Format In this method, you need to change...

Read more »