#1   Report Post  
JohnT
 
Posts: n/a
Default 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   Report Post  
RagDyeR
 
Posts: n/a
Default

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   Report Post  
 
Posts: n/a
Default

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   Report Post  
RagDyeR
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SORTING question Rebecca New Users to Excel 3 February 24th 05 05:35 PM
Colors of columns after sorting data in the supporting table Booger_Boy Charts and Charting in Excel 6 January 24th 05 02:41 PM
Sorting rows AND columns 3D Excel Worksheet Functions 2 January 7th 05 02:15 AM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM
Automatic Sorting of a group of columns. Josh Barbara Excel Worksheet Functions 1 November 15th 04 01:55 AM


All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"