Remove drop down sorting

otuatail · #1 06-20-2019, 09:54 AM

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.

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.

ArviLaanemets · #2 06-20-2019, 10:22 AM

Quote:

Originally Posted by otuatail

All have arrows with drop downs now because I did a sort

No, you didn't

Quote:

Originally Posted by otuatail

I don't want those annoying arrows anymore.

Set autofilter off!

ArviLaanemets · #3 06-20-2019, 10:27 AM

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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop down box list based on response to another drop down box	Phideaux	Excel	16	04-13-2018 03:07 AM
Sorting McC... before MAC	Peace Freak	Excel	1	10-04-2017 02:59 PM
Drop down lists and pulling data from worksheet based on drop down selection	cjoyce73	Excel	5	07-17-2017 07:40 AM
Remove Name From Drop Down After Its's Selected, Office 2013	Justair07	Excel Programming	1	12-12-2015 06:20 PM
Help, auto select drop down by another drop down value?	skrallemand	Word VBA	3	09-11-2013 11:55 AM