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
In Excel 2003, select a cell in the list, and choose Datagt; List gt; 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
www.contextures.com/xlSort02.html
jmpruitt wrote:
gt; I think I have seen this before somewhere but I cannot see an easy way to do
gt; it.
gt;
gt; I want to set up a basic spreadsheet with several columns and I would like
gt; to be able to sort them with just a pulldown or something in the header row.
gt; Any ideas or suggestions?
gt; Thanks.
gt; John--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html
- Aug 07 Thu 2008 20:45
Create a sort button?
close
全站熱搜
留言列表
發表留言