Excel doesn’t save hidden rows or columns or groups with a sheet view. However, if you save a grouping, the ability to collapse and expand will be immediately available to other collaborators.

You can insert blanks rows above or below another in Excel, and you can even add them between each row that has data.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.