Office File Recovery

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 »

3 Quick Methods to Paste Multiple Lines into One Cell in Your Excel Worksheet

Copy and paste is the most ordinary process in Excel. And in this article, we will introduce 3 methods to paste multiple lines into one cell in your Excel. When working with Excel worksheet, you will certainly copy external contents into Excel cells. And sometimes you need to copy multiple lines into one cell. For example, in the image below, we now want to paste the contents into a cell. If you directly copy the contents and then press the shortcut keys “Ctrl + V” on the keyboard,...

Read more »