Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Remove drop down sorting
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2019, 09:54 AM
otuatail otuatail is offline Remove drop down sorting Windows 7 64bit Remove drop down sorting Office 2007
Competent Performer
Remove drop down sorting 		 
Join Date: Jun 2012
Posts: 246
otuatail is on a distinguished road
Default Remove drop down sorting

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.
Reply With Quote
  #2  
Old 06-20-2019, 10:22 AM
ArviLaanemets ArviLaanemets is offline Remove drop down sorting Windows 8 Remove drop down sorting Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
Quote:
Originally Posted by otuatail View Post
All have arrows with drop downs now because I did a sort
No, you didn't

Quote:
Originally Posted by otuatail View Post
I don't want those annoying arrows anymore.
Set autofilter off!
Reply With Quote
  #3  
Old 06-20-2019, 10:27 AM
ArviLaanemets ArviLaanemets is offline Remove drop down sorting Windows 8 Remove drop down sorting Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
Quote:
Originally Posted by otuatail View Post
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 View Post
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!
Reply With Quote
Reply

« Previous Thread | Next Thread »


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
Remove drop down sorting Sorting McC... before MAC Peace Freak Excel 1 10-04-2017 02:59 PM
Remove drop down sorting Drop down lists and pulling data from worksheet based on drop down selection cjoyce73 Excel 5 07-17-2017 07:40 AM
Remove drop down sorting 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:25 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft