Sorting

[Guest]

I'm having trouble with using the "A-Z" sort button from the toolbar. I use
these buttons all the time, and I thought that as long as I was in the column
I wanted to sort, and that the data was formatted properly (i.e., contiguous,
no blank rows/columns, no extraneous text in adjacent cells, etc.), the sort
button would work.

However, I have a file that doesn't seem to conform to that model. When I
hit the sort button, Excel selects several rows above the data set, and the
sort fails. The row above the data is clear, and when I hit
ctrl-shift-asterisk, it selects the contiguous data. Any idea why Excel
thinks it should select additional cells in this situation?

Thanks,
Todd

 

[Guest]

The entire row above may not actually be blank.........maybe do a
clearcontents on it to be sure..........

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

I used Clear/All for the entire row, which I assumed would resolve the
problem. Shoudl that do it?

 

[Guest]

I dunno.......I've never used that procedure........maybe try putting a row
full of 1's or something, and then doing ClearContents......might be some
invisible character that's messing things up.........

Vaya con Dios,
Chuck, CABGx3