Remove an outline

Question

Excel is displaying the outline buttons, indicating there is an outline on my data somewhere. I've tried numerous times and different ways to find it, but to no avail. I've tried to remove the outline, but even the "clear outline" button isn't active.

I know I can hide the outline buttons on the Options menu, however the outline will still technically "be there." Case in point, if I hide the buttons and then try to sort my table, I get the following message:

Can someone please help me remove whatever outline may be hidden/embedded/misapplied in this workbook? We don't need it, we don't want one, and it's driving me nuts trying to undo it! 🤪

TIA!!

Answer 1

Ctrl+A to select entire worksheet.

Then Data>Ungroup rows twice.

Now outlines are removed.

Answer 2

Could you share a test file? Then I can have a try on it.

For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.  *Please make sure you have removed any sensitive or private information in the sample file before uploading.

Answer 3

Our data is very secure, so I'm not sure you'll be able to access the test:

Test Tracker for Outline.xlsx

If not, please let me know how else to share. We don't have dropbox or other file sharing subscriptions; it's against our IT policy.

Thanks.

Answer 4

Your file link need organization account.

You may upload attachment in private message.

Private Messages - Microsoft Community

Answer 5

I swear I tried that! 😆 thank you so much!!