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.

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.

Adding additional columns in Excel is very similar to adding additional rows. Just as adding rows will move rows in Excel down, adding columns will move subsequent rows to the right.

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 case, you’ll need a second subtotal row. How to add a second subtotal row to a PivotTable in Excel The default PivotTable is useful, but you might need more information.

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

Want to transpose Rows into Columns in Excel or Google Sheets? This post shows how to switch or swap Columns and Rows in Excel and Google Sheets.

How to Hide Columns and Rows in Excel Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide. Then, right-click on ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

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 ...