close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()