ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting (https://www.excelbanter.com/excel-discussion-misc-queries/111236-sorting.html)

sara

Sorting
 
I need to change an excel table to alphabetical order. I have 9 columns and
121 rows. I've tried with the sort button but nothing happens. Could
somebody please give me some light in this?

Thank you.

tim m

Sorting
 
It should sort alphabetically for you. What column are you sorting on? (You
need to choose at least one column to use to sort from. do you have any
spaces before the text perhaps?)

"Sara" wrote:

I need to change an excel table to alphabetical order. I have 9 columns and
121 rows. I've tried with the sort button but nothing happens. Could
somebody please give me some light in this?

Thank you.


James Silverton

Sorting
 
Hello, Sara!
You wrote on Fri, 22 Sep 2006 13:20:01 -0700:

S I need to change an excel table to alphabetical order. I
S have 9 columns and 121 rows. I've tried with the sort
S button but nothing happens. Could somebody please give me
S some light in this?

You've got to select a column or subset of a column before
pressing the button.

Otherwise, select a cell in your table, then Data Sort. AFAIK,
a cell must be selected for reasons that escape me :-)

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not



All times are GMT +1. The time now is 07:35 AM.

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