Jan 03 2022 02:31 AM
Remove an outline
Outline (group) data in a worksheet
Note: No data is deleted when you hide or remove an outline.
Hide an outline
Go to File > Options > Advanced, and then under the Display options for this worksheet section, uncheck the Show outline symbols if an outline is applied check box.
Remove an outline
Click the worksheet.
One the Data tab, in the Outline group, click Ungroup and click Clear Outline.
Important: If you remove an outline while the detail data is hidden, the detail rows or columns may remain hidden. To display the data, drag across the visible row numbers or column letters adjacent to the hidden rows and columns. On the Home tab, in the Cells group, click Format, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Jan 03 2022 02:57 AM