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.

Q: I use Excel’s Group tool to expand and collapse our employees’ weekly timesheet data, but it takes forever to group each section individually for each of my 300-plus employees. Can you tell me how ...