Forum Discussion
i need help!!!
How to remove these? i need help
2 Replies
- 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 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.
