Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

Having an incorrect row or column in your INDEX formula can trigger the #REF error, for instance, in the photo above, we have an incorrect row (7) and an incorrect column (4).

How to Change Columns Into Rows in Excel 2007. If you've ever entered a long list of business data and realized you need this information across a row instead of down a column, you can take ...

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.

You can use Apple’s Numbers app for sophisticated spreadsheet work. But where it falls short—as does Microsoft Excel—is at cleaning up data that’s in the spreadsheet. Where Microsoft Word ...