Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting Columns
i suppose there is a simple way to do this however the
answer seems to excape me at the moment....i have a simple spreadsheet with names across the top and totals along the bottom....i would like to put the columns in order from highest to lowest....i would like this to be a "live" spreadsheet, the totals may change depending on intermediate data....thankyou. |
#2
|
|||
|
|||
I don't quite understand "live", but to sort your columns, select the entire
datalist. Then, <Data <Sort And click on "Options". Then, click on "Sort Left To Right", then <OK, Then choose you Total row, then <OK. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "JohnT" wrote in message ... i suppose there is a simple way to do this however the answer seems to excape me at the moment....i have a simple spreadsheet with names across the top and totals along the bottom....i would like to put the columns in order from highest to lowest....i would like this to be a "live" spreadsheet, the totals may change depending on intermediate data....thankyou. |
#3
|
|||
|
|||
yes, that works, thankyou.
-----Original Message----- I don't quite understand "live", but to sort your columns, select the entire datalist. Then, <Data <Sort And click on "Options". Then, click on "Sort Left To Right", then <OK, Then choose you Total row, then <OK. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "JohnT" wrote in message ... i suppose there is a simple way to do this however the answer seems to excape me at the moment....i have a simple spreadsheet with names across the top and totals along the bottom....i would like to put the columns in order from highest to lowest....i would like this to be a "live" spreadsheet, the totals may change depending on intermediate data....thankyou. . |
#4
|
|||
|
|||
Thanks for the feed-back.
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- wrote in message ... yes, that works, thankyou. -----Original Message----- I don't quite understand "live", but to sort your columns, select the entire datalist. Then, <Data <Sort And click on "Options". Then, click on "Sort Left To Right", then <OK, Then choose you Total row, then <OK. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "JohnT" wrote in message ... i suppose there is a simple way to do this however the answer seems to excape me at the moment....i have a simple spreadsheet with names across the top and totals along the bottom....i would like to put the columns in order from highest to lowest....i would like this to be a "live" spreadsheet, the totals may change depending on intermediate data....thankyou. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SORTING question | New Users to Excel | |||
Colors of columns after sorting data in the supporting table | Charts and Charting in Excel | |||
Sorting rows AND columns | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Automatic Sorting of a group of columns. | Excel Worksheet Functions |