ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sorting in excel (https://www.excelbanter.com/excel-worksheet-functions/99278-sorting-excel.html)

AMH

sorting in excel
 
The colums on top are turned (text going from top-sideways) how do I sort
this information. Like when you sort (using the filter on columns going from
left to right with text the right way).
The text in these columns are tilted and I need to sort so I can see just
ONE row with all the text in this row.

Difficult to explain...

:)


AMH

Dav

sorting in excel
 

It is somewhat unclear, you can sort left to right by choosing data sort
options and left to right. the Alignment of text within cells is just a
format so change the format.

Perhaps you will have to give a little more information

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=561416


Bob Phillips

sorting in excel
 
Surely, the orientation doesn't affect sorting.

Do you mean sorting by rows not columns? If so, there is an option in sort,
click the Options button and then select sort left to right.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AMH" wrote in message
...
The colums on top are turned (text going from top-sideways) how do I sort
this information. Like when you sort (using the filter on columns going

from
left to right with text the right way).
The text in these columns are tilted and I need to sort so I can see just
ONE row with all the text in this row.

Difficult to explain...

:)


AMH





All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com