![]() Once the outline is removed, you won't be able to get it back by clicking the Undo button or pressing the Undo shortcut ( Ctrl + Z).To display the rows, use any of the methods described in How to unhide rows in Excel. If you remove an outline with some collapsed rows, those rows might remain hidden after the outline is cleared.Removing outline in Excel does not delete any data.Go to the Data tab > Outline group, click the arrow under Ungroup, and then click Clear Outline. nested groups), then ungroup the selected rows. If you want to remove just some of the row groups (e.g. In case you want to remove all row groups at once, then clear the outline. Or click the plus sign for the collapsed group of rows that you want to expand: To expand the rows within a certain group, click any cell in the visible summary row, and then click the Show Detail button on the Data tab, in the Outline group: ![]() The following screenshot demonstrates the outline collapsed to level 3.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |