Remove outline worksheet in Excel

For example, I have a WorkSheet that has "Outline" set up as shown below. I would like to remove the same.

excel remove outline worksheet

To do it in Excel, here is the answer:

a) Click on "Ungroup" under "Data". Click on "Clear Outline".

excel remove outline worksheet

b) Outline is cleared and the Table is shown in its original form without any rows hidden.

excel remove outline worksheet


You can find similar Excel Questions and Answer hereunder

1) How to change the color of gridlines in a worksheet in Excel

2) How to protect your worksheet from changes in Excel

3) How can I add a background image to a worksheet?

4) How can I copy and rename a WorkSheet using VBA?

5) How can I add a WorkSheet and name it as required using VBA?

6) What are worksheets events in VBA. Here we explain some of the main one like like activate or deactivate

7) In a Table , how can I remove duplicate records?

8) How can I loop through all WorkSheets and get their names using VBA?

9) Is there any way I can see more region of my WorkSheet?

10) How can I quickly remove all blank cells in a data range?


Here the previous and next chapter