Excel spreadsheet top data row won't alphabetize

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ironhorse88 - 25 Aug 2006 16:02 GMT

i load data in spreadsheet, but when i try to sort the rows alphabetically
the top one or two rows don't move. I have had this problem on multiple
versions of Excel.

Reply to this Message

kassie - 26 Aug 2006 09:50 GMT

If the top row does not sort, it is because Excel took it as a header row.
To sort this, click on Data|Sort, make sure that the option at the bottom
under My List Has "No Header Row" is ticked, and that you actually sort by a
column, before you click on OK

> i load data in spreadsheet, but when i try to sort the rows alphabetically
> the top one or two rows don't move. I have had this problem on multiple
> versions of Excel.

Reply to this Message

Ironhorse88 - 27 Aug 2006 00:41 GMT

Thanks

> If the top row does not sort, it is because Excel took it as a header row.
> To sort this, click on Data|Sort, make sure that the option at the bottom
[quoted text clipped - 4 lines]
> > the top one or two rows don't move. I have had this problem on multiple
> > versions of Excel.

Reply to this Message