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.

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows.

If you are using Microsoft Excel for your business, you may need to add an additional row or several rows to accommodate new data in a spreadsheet. You can also draw lines within the spreadsheet ...

Want to transpose Rows into Columns in Excel or Google Sheets? If yes then this post will show you how to switch or swap Columns and Rows in Excel and Google Sheets.

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

The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.