In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

How to Use the Multiple Rows Function in Excel. In addition to listing data, you can also use Excel to manipulate data. For example, you can compute sales, determine inventory or calculate nearly ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

You probably use VLOOKUP() function to find exact matches in Microsoft Excel, but you can also find the closest value when you don't know the exact value.

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

How to delete rows with Find in Excel It might have occurred to you at this point, that this feature might provide a quick way to delete cell values and even records.

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

Microsoft Excel: How to Find Missing Numbers in a Sequence. Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate ...

Excel's lookup formulas can save you time and trouble. Because they extract data from a table, they update if the data changes. And they return exactly the details requested every time.