Quote:
Originally Posted by otuatail
I have done a sort on the spread sheet. Now I have annoying drop downs on the top row. I can not remove the drop downs.
|
No, you didn't
Quote:
Originally Posted by othttps://www.msofficeforums.com/images/smilies/tongue.gifuatail
Just to be clear. the top row (Row 1). All have arrows with drop downs now because I did a sort. I don't want those annoying arrows anymore.
|
Set autofilter off!
Of-course you may also a Table defined, then autofilter is added too. But It is not very easy to create a Table accidentally instead sorting data. Confusing autofilter with sort is much easier.
Somehow the forum saved edited post as new one!