SOLVED

How do you remove the extra boxes from a paste

Highlighted
New Contributor

Screenshot of what to removeScreenshot of what to removeHow do I remove these kinds of fields from an excel file. I tried Data validation, Clear All and nothing happened.  Help Appreciated. Thank you!

3 Replies
Solution

hello! Select these cells and deactivate or activate the filter format with shortcut CTRL - Shift - L (the L stands vor "List") Greets, Eva.

Highlighted

Thank you, Eva!!! (That's really been bugging me). :)

Highlighted
Hi! Pleasure to help! Have a good week & enjoy excel 😊