How to Expand All Hidden Lines in an Excel Spreadsheet. Hiding lines, or rows, in Microsoft Office Excel 2010 is very simple: Right-click the lines and select "Hide." However, expanding the hidden ...

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

If you want to hide and unhide columns and rows in Microsoft Excel, then know it is easier than you might have thought. We explain how.

The larger a spreadsheet gets, the more likely you'll want to start hiding rows or columns or maybe you've been given a sheet that has hidden rows or columns.

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.