Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.

Discovering these differences can be important if values in one cell should match values in another. Excel has a tool that highlights differences between a row's cells regardless of the worksheet ...

Combine INDEX and MATCH: Use MATCH to find the row or column number and INDEX to retrieve the value at that position.

When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...

The example tells Excel to look in column "B" for each row and determine if the values are less than zero. If a value is less than zero, the conditional formatting is applied to that row.