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