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.

When you're working on an especially chunky spreadsheet in Microsoft Excel or Google Sheets, it can get annoying to have to scroll up, down, and around to keep track of where all the information ...

Spreadsheet applications like Excel enable you to insert, delete or rearrange entire rows of business data in ways that are difficult or messy to do with old-fashioned pencil and paper ledgers ...

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

Adjusting the row height in Excel can help you create tables and spreadsheets that are easy to read at a glance.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Q: I read your colleague David Einstein's description of how to make row and column headings repeat on each page of an Excel spreadsheet in Windows. The Mac version appears to be just a bit ...

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.