Share via

"extra" columns in excel

Anonymous
2021-04-13T17:19:23+00:00

hi there, I have some "extra columns" in excel (not sure what they are called) - how do I get rid of this? it's like columns 1.2.3 before column a, and they can be expanded and contracted

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2021-04-13T17:26:34+00:00

    That's an Outline as described here:
    https://support.microsoft.com/en-us/office/outline-group-data-in-a-worksheet-08ce98c4-0063-4d42-8ac7-8278c49e9aff

    Select the rows, click Ungroup in the Data tab.

    Andreas.

    0 comments