sorting excel worksheet
 

How to sort a column of text alphabetically so that the contents of the
relative rows automatically sort with the column?

The A-Z sort function seems only to work with the individual column.

Any help, gratefully received.

Thanks.

sorting excel worksheet
 

Do not use the A-Z icons for sorting. Instead, highlight the range you
want to sort (which may or may not include a header row), then click
Data | Sort and choose the sort field(s) and type (ascend/descend)
then click OK. This will keep data on the same rows together.

Hope this helps.

Pete

On Apr 13, 11:12 am, emmcee wrote:
How to sort a column of text alphabetically so that the contents of the
relative rows automatically sort with the column?

The A-Z sort function seems only to work with the individual column.

Any help, gratefully received.

Thanks.

sorting excel worksheet
 

Select the range that you want to sort, including whichever rows & column
you want sorting, then choose Data/ Sort, and tell it which column to sort
by.
--
David Biddulph

"emmcee" wrote in message
...
How to sort a column of text alphabetically so that the contents of the
relative rows automatically sort with the column?

The A-Z sort function seems only to work with the individual column.

Any help, gratefully received.

Thanks.

sorting excel worksheet
 

select all of the cells you want to sort together
either use data-sort
or
use the tab button to go to the column you want to sort by and use the A-Z
button

"emmcee" wrote:

How to sort a column of text alphabetically so that the contents of the
relative rows automatically sort with the column?

The A-Z sort function seems only to work with the individual column.

Any help, gratefully received.

Thanks.

sorting excel worksheet
 

For additional help with sorting see
http://www.mvps.org/dmcritchie/excel/sorting.htm
but as already pointed out to you the important thing
is to select the area to be included in the sort, and do
not ever rely of the automatic expansion of a single
cell to expand to the current region (Ctrl+SHIFT+*) to
actually define the range you want to work with as you
will surely destroy you data sooner or later.

If you have Excel 2003 or later you cannot rely on Ctrl+A
to select all of the cells either, so again you risk destroying
your data. If you do have Excel 2003 or later see
http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar

In using the A-Z sort you might want to insure that the title
will sort before the rest of column, as Excel's determination
of whether there is a header row involved is very poor, so
be aware of what you have and be ready to use Ctrl+Z if
the sort does not work. Ctrl+Z will not work if you have
used a macro or have an Event macro in place for the worksheet.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"emmcee" wrote in message ...
How to sort a column of text alphabetically so that the contents of the
relative rows automatically sort with the column?

The A-Z sort function seems only to work with the individual column.

Any help, gratefully received.

Thanks.

sorting excel worksheet
 

Many thanks. That solution works
mike (indonesia)

"Pete_UK" wrote:

Do not use the A-Z icons for sorting. Instead, highlight the range you
want to sort (which may or may not include a header row), then click
Data | Sort and choose the sort field(s) and type (ascend/descend)
then click OK. This will keep data on the same rows together.

Hope this helps.

Pete

On Apr 13, 11:12 am, emmcee wrote:
How to sort a column of text alphabetically so that the contents of the
relative rows automatically sort with the column?

The A-Z sort function seems only to work with the individual column.

Any help, gratefully received.

Thanks.

sorting excel worksheet
 

Many thanks for yr help.

That works.

"David Biddulph" wrote:

Select the range that you want to sort, including whichever rows & column
you want sorting, then choose Data/ Sort, and tell it which column to sort
by.
--
David Biddulph

"emmcee" wrote in message
...
How to sort a column of text alphabetically so that the contents of the
relative rows automatically sort with the column?

The A-Z sort function seems only to work with the individual column.

Any help, gratefully received.

Thanks.

sorting excel worksheet
 

Thanks for feeding back, Mike.

Pete

On Apr 16, 12:22 pm, emmcee wrote:
Many thanks. That solution works
mike (indonesia)



"Pete_UK" wrote:
Do not use the A-Z icons for sorting. Instead, highlight the range you
want to sort (which may or may not include a header row), then click
Data | Sort and choose the sort field(s) and type (ascend/descend)
then click OK. This will keep data on the same rows together.

Hope this helps.

Pete

On Apr 13, 11:12 am, emmcee wrote:
How to sort a column of text alphabetically so that the contents of the
relative rows automatically sort with the column?

The A-Z sort function seems only to work with the individual column.

Any help, gratefully received.

Thanks.- Hide quoted text -

- Show quoted text -