ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2002 Worksheet: Can I sort the columns ? (https://www.excelbanter.com/excel-discussion-misc-queries/161015-excel-2002-worksheet-can-i-sort-columns.html)

Mr. Low

Excel 2002 Worksheet: Can I sort the columns ?
 
Dear Sir,

I am very familiar in sorting the rows in ascending or descending order.


By taking the following worksheet example :

A102 A106 A098 A125 A108
xxx
Xxx

May I know is there a way to sort the columns in ascending and descending
order ?

Thanks

Low


--
A36B58K641

Pete_UK

Excel 2002 Worksheet: Can I sort the columns ?
 
In the sort dialogue box there is an Options button - click on this
and you then have the option to sort left-to-right instead of top-to-
bottom.

Hope this helps.

Pete

On Oct 5, 2:16 pm, Mr. Low wrote:
Dear Sir,

I am very familiar in sorting the rows in ascending or descending order.

By taking the following worksheet example :

A102 A106 A098 A125 A108
xxx
Xxx

May I know is there a way to sort the columns in ascending and descending
order ?

Thanks

Low

--
A36B58K641




Mr. Low

Excel 2002 Worksheet: Can I sort the columns ?
 
Hello Pete,

Thanks for your tip.

Low


--
A36B58K641


"Pete_UK" wrote:

In the sort dialogue box there is an Options button - click on this
and you then have the option to sort left-to-right instead of top-to-
bottom.

Hope this helps.

Pete

On Oct 5, 2:16 pm, Mr. Low wrote:
Dear Sir,

I am very familiar in sorting the rows in ascending or descending order.

By taking the following worksheet example :

A102 A106 A098 A125 A108
xxx
Xxx

May I know is there a way to sort the columns in ascending and descending
order ?

Thanks

Low

--
A36B58K641





Pete_UK

Excel 2002 Worksheet: Can I sort the columns ?
 
You're welcome.

Pete

On Oct 6, 12:40 am, Mr. Low wrote:
Hello Pete,

Thanks for your tip.

Low

--
A36B58K641



"Pete_UK" wrote:
In the sort dialogue box there is an Options button - click on this
and you then have the option to sort left-to-right instead of top-to-
bottom.


Hope this helps.


Pete


On Oct 5, 2:16 pm, Mr. Low wrote:
Dear Sir,


I am very familiar in sorting the rows in ascending or descending order.


By taking the following worksheet example :


A102 A106 A098 A125 A108
xxx
Xxx


May I know is there a way to sort the columns in ascending and descending
order ?


Thanks


Low


--
A36B58K641- Hide quoted text -


- Show quoted text -





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

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