![]() |
Column sort with Ascending / Descending Arrows
I received a worksheet with preset sorts for each column (each has a
ascending/descending arrow). How do you do that? I have looked everywhere and can't find anything that even talks about this. Then again, it may be I don't know what this is called. JT |
Column sort with Ascending / Descending Arrows
You must ave autofilters turned on in the Data Menu - Filter. You should see
a check mark in the filter box if you go to the menu. "JT" wrote: I received a worksheet with preset sorts for each column (each has a ascending/descending arrow). How do you do that? I have looked everywhere and can't find anything that even talks about this. Then again, it may be I don't know what this is called. JT |
Column sort with Ascending / Descending Arrows
Thanks Joel. I had no idea that is what triggered that.
"Joel" wrote: You must ave autofilters turned on in the Data Menu - Filter. You should see a check mark in the filter box if you go to the menu. "JT" wrote: I received a worksheet with preset sorts for each column (each has a ascending/descending arrow). How do you do that? I have looked everywhere and can't find anything that even talks about this. Then again, it may be I don't know what this is called. JT |
Column sort with Ascending / Descending Arrows
I would have guessed that the developer added some up and down arrows to each
cell and then assigned macros to each of these shapes. JT wrote: I received a worksheet with preset sorts for each column (each has a ascending/descending arrow). How do you do that? I have looked everywhere and can't find anything that even talks about this. Then again, it may be I don't know what this is called. JT -- Dave Peterson |
All times are GMT +1. The time now is 11:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com