Select the array of cells that you want to collapse and expand. Click "Data" in the Excel ribbon. Click "Group" in the ribbon's Outline section to open a pop-up menu.

Hiding lines, or rows, in Microsoft Office Excel 2010 is very simple: Right-click the lines and select "Hide." However, expanding the hidden lines in the Excel spreadsheet is not as simple. To get th ...