Is it possible to SORT a row??

[elephant97]

I have information in rows, numbers 1-6 in one row, and names in another row. I know I can sort by columns, but I need to sort by rows and keep the integrity of the information below corresponding heading. Example:

1 2 3
John Angie Bert
Ships Picks Ships

I would like to be able to sort by name OR number but still keep the information below (and above) the sorting ROW intact. HELP!

 

[Andrew Poulsom]

I am not quite sure what you mean, but you can sort Left to Right instead of the normal Top to Bottom. Click Options in the Sort dialog box.

 

[elephant97]

Thanks! That worked, but I also have cells that are different colors (3 different colors are used). How can I sort my spreadsheet from left to right, by color? Thanks

 

[RichardS]

See

http://www.mrexcel.com/board/viewtopic.php?topic=18513&forum=2

for a start.

Richard

 

[elephant97]

None of these work or address my problem.