Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
3D
 
Posts: n/a
Default Sorting rows AND columns

Hi,

I have a spreadsheet with both rows and columns of info. I wish to sort
one of the rows in ascending order and have the corresponding column info
follow the sort.

How can I do this???

Thanks for any assistance,
3D
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
not really sure what you want to sort and which columns? then should follow.
Could you give an example?

--
Regards
Frank Kabel
Frankfurt, Germany
"3D" schrieb im Newsbeitrag
...
Hi,

I have a spreadsheet with both rows and columns of info. I wish to sort
one of the rows in ascending order and have the corresponding column info
follow the sort.

How can I do this???

Thanks for any assistance,
3D



  #3   Report Post  
CLR
 
Posts: n/a
Default

Highlight your data field, then

Data Sort Options check "Sort left to right" OK then pick which
row you want to sort on and whether Ascending or Decending, then OK

Vaya con Dios,
Chuck, CABGx3



"3D" wrote in message
...
Hi,

I have a spreadsheet with both rows and columns of info. I wish to

sort
one of the rows in ascending order and have the corresponding column info
follow the sort.

How can I do this???

Thanks for any assistance,
3D



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
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. JamesR Excel Discussion (Misc queries) 3 January 12th 05 03:18 PM
repeated transpose from rows to columns with unequal groups kraymond Excel Discussion (Misc queries) 3 December 20th 04 03:39 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 06:40 PM
Rows and columns Loi New Users to Excel 0 November 30th 04 08:42 PM
sumif columns and rows Paul Clough Excel Worksheet Functions 2 November 22nd 04 06:01 PM


All times are GMT +1. The time now is 07:26 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"