He has over two years of experience writing and editing technology-related articles.

This is helpful if you have a large document with lots of data.

You can group and outline data in Excel on both Windows and Mac platforms.

Youll find this option on the far-right side of the Data ribbon.

In most cases, doing this will only display the final line of the data.

This will ungroup and unhide any data that was minimized or grouped previously.

Its in the left side of the green ribbon at the top of Excel.

Make sure Show outline symbols if an outline is applied is selected.

This is necessary for every sheet where there are outlinesgroupings applied.

The new columns will be added to the left of the selected columns.

Then place an asterisk or other sortable value into an extra column.

If you do, other users wont be able to expand and collapse the rows.

Open the Excel document.

Click Data 3. Click Group 4.

Click Auto Outline 5.

By continuing to use our site, you agree to our cookie policy.

What Is Outline In Excel For Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

What Is Outline In Excel For Mac