ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Column sort with Ascending / Descending Arrows (https://www.excelbanter.com/excel-worksheet-functions/187925-column-sort-ascending-descending-arrows.html)

JT

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

joel

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


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


Dave Peterson

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