Outline Group Data In A Worksheet. Tip: If you select entire rows instead of If you don't see the outline symbols , , and , go to File > Options > Advanced, and then under the Display options for this worksheet section, select. The Subtotal command can be used to outline your worksheet in several ways.
For example, a sheet that lists your company's sales figures may include last year's figures, copied from a different sheet. The Worksheets are the actual parts where you enter the data. The first thing we should recognize is that the default setting in Excel is for individual cells to be locked.
Combining the ranges on different sheets and in different books.
To view and compare data in a worksheet.
Changing worksheet colors, fonts, and effects. Microsoft Support: Outline (Group) Data in a Worksheet. The image below shows the pivot table in a worksheet.