i need help!!!

Occasional Visitor



How to remove these? i need help

2 Replies


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 FileOptions > 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

  1. Click the worksheet.

  2. 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.

This happens when you group data.

1. select all the cells in excel if you don't remember which ones you grouped
2. go to data tab and click on ungroup in the outline section. Select either rows or columns

If you want to remove completely this completely, do the same for rows and columns