Segmentation Using Excel 2007

By Ryan Menezes

Use segmentation to organize awkward collections of data.
i Comstock Images/Comstock/Getty Images

An Excel 2007 spreadsheet may contain far more data than you can view at once. For example, if a spreadsheet tracks all of your company's transactions, the long list of figures will keep you from noting broad data trends. One solution for this problem is to segment data into small groups that you can expand and collapse. Excel will display the totals for each segment's columns of numbers but will hide individual items unless you choose to show them.

Click and drag over the cells that contain the data you want to segment.

Click "Group" in the ribbon's Data tab to open a pop-up menu.

Click "Group" to open the Group dialog box.

Click the "Rows" radio button to collapse each segment's rows.

Click "OK" to carry out segmentation.