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

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows.