Tamara has attended:
Excel Intermediate course
Creating groups and outlines
Where do you start/ what do you select in order to create a group.
RE: Creating groups and outlines
Hi Tamara
Thank you for your question - apologies for the delay in replying. I hope you haven't had any problems with using the outline feature in the meantime.
To create an automatic outline, select the data that you wish to apply the outline to. Then go to Data - Group and Outline - Auto Outline. If Excel can create an automatic outline from your selected data, it will.
If this doesn't work, or you want to group only specific rows or columns within your spreadsheet, then you select the rows or columns you wish to group, then go to Data - Group and Outline - Group. An outline area will appear at the top or side of your screen (depending if you've grouped rows or columns) and you will be able to collapse and expand your group using the outline area.
I hope this is useful.
Amanda
