How to Expand and Collapse in Excel 2007. An Excel 2007 spreadsheet may contain very large quantities of data. Individual sections may be unimportant. For example, a sheet that lists your company ...

Double-click the Excel file containing the data for which you want to create a cumulative chart. Click your mouse cursor on the uppermost cell in one of the columns, and then drag the mouse until ...

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.