| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a sort button?
I think I have seen this before somewhere but I cannot see an easy way to do
it. I want to set up a basic spreadsheet with several columns and I would like to be able to sort them with just a pulldown or something in the header row. Any ideas or suggestions? Thanks. John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create a sort button?
In Excel 2003, select a cell in the list, and choose Data List Create
List From the dropdown arrow at the top of each column, select Sort Ascending or Sort Descending. For earlier versions, you can use programming, as Dave Peterson describes he http://www.contextures.com/xlSort02.html jmpruitt wrote: I think I have seen this before somewhere but I cannot see an easy way to do it. I want to set up a basic spreadsheet with several columns and I would like to be able to sort them with just a pulldown or something in the header row. Any ideas or suggestions? Thanks. John -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a button to sort | Excel Worksheet Functions | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| How can I create a button to save one worksheet into a new workshe | Excel Discussion (Misc queries) | |||
| Can I create a button in Excel that generates a task in Outlook? | Excel Discussion (Misc queries) | |||
| Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
