How do you remove the extra boxes from a paste

New Contributor

Capture.JPGScreenshot 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

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 😊
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies