Excel Group feature allows users to group rows or columns. Ungroup is used to ungroup a range of cells or data that were previously grouped.

Microsoft Excel’s sheet view collaboration feature is not new, but now it supports hiding rows and columns and applying groups.

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.

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.

Say I have an Excel worksheet with 100 rows. Each row in column 1 has the name of a manager and each product has 10 employees. I want to use Excel to group those so I can just see 10 rows, and ...