SOLVED

How do you remove the extra boxes from a paste

Copper 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
best response confirmed by bopeep (Copper Contributor)
Solution

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

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

Hi! Pleasure to help! Have a good week & enjoy excel :smiling_face_with_smiling_eyes:
1 best response

Accepted Solutions
best response confirmed by bopeep (Copper Contributor)
Solution

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

View solution in original post