How to Expand Collapse in Excel 2007

Hide Rows and Columns
1. Open the saved Excel document.
2. Click on the rows or columns you wish to hide from view.
3. Click on the 'Home' tab on the Ribbon.
4. Click on the 'Format' button in the 'Cells' group. A drop-down list will appear.
5. Point to the 'Hide Unhide' section to display a list.
6. Click on the 'Hide Rows' or 'Hide Columns' option. The selected rows or columns and the respective headers are temporarily removed. A short, bold line between the row or column headers indicates where the rows or columns are hidden. For example, a line between headers A and C indicates column B is hidden.
Unhide Rows and Columns
7. Open the saved document.
8. Click on the two headers adjacent to the hidden rows or columns. For example, if rows 10 to 15 are hidden, click on row headers nine and 16.
9. Click on the 'Home' tab.
10. Click the 'Format' button in the 'Cells' group. A drop-down list will appear.
11. Point to the 'Hide Unhide' section. A list of commands will appear.
12. Click either 'Unhide Rows' or 'Unhide Columns'. The hidden rows or columns will appear. The spreadsheet will expand.