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

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.

VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel.

Learn how to remove blank rows in Excel automatically with zero clicks using dynamic arrays & advanced formulas. Save time, boost efficiency ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data.

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.