How to Expand and Collapse in Excel 2007. An Excel 2007 spreadsheet may contain very large quantities of data. ... Click "Columns" if you want to collapse several columns.

To return your columns to their original states, or to leave certain data visible when you collapse other groups, you can use Excel's Ungroup button. First, select the grouped columns you want to ...

Double click to reveal the column or click and drag to manually expand the hidden column. How to unhide all hidden columns in Excel. 1. Open Microsoft Excel on your PC or Mac computer. 2.