ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to sort columns? (https://www.excelbanter.com/excel-discussion-misc-queries/172782-how-sort-columns.html)

John Brown

How to sort columns?
 
New to Excel...
Have telephone book in excel with three columns -
Surname, First Name, Telephone number - at the mo in Surname alphabetical
order.
How to change to telephone number order - smallest number to largest number?
Thanks,
John



Fuzion

How to sort columns?
 
Ho John,

If you highligh all 3 colums, and then got o data tab (in office 2007) and
the click on sort. You will then be able to choose which field you would like
to sort on.

Hope that helps,

Jamie @ Fuzion

"John Brown" wrote:

New to Excel...
Have telephone book in excel with three columns -
Surname, First Name, Telephone number - at the mo in Surname alphabetical
order.
How to change to telephone number order - smallest number to largest number?
Thanks,
John




John Brown

How to sort columns?
 
OK, Cheers, Jamie.
J
========
"Fuzion" wrote in message
...
Ho John,

If you highligh all 3 colums, and then got o data tab (in office 2007) and
the click on sort. You will then be able to choose which field you would
like
to sort on.

Hope that helps,

Jamie @ Fuzion

"John Brown" wrote:

New to Excel...
Have telephone book in excel with three columns -
Surname, First Name, Telephone number - at the mo in Surname alphabetical
order.
How to change to telephone number order - smallest number to largest
number?
Thanks,
John







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

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