Sorting
 

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

Sorting
 

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

Vaya con Dios,
Chuck, CABGx3

"T. Jenkins" wrote:

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

Sorting
 

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


"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3

"T. Jenkins" wrote:

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

Sorting
 

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



"T. Jenkins" wrote:

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


"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3

"T. Jenkins" wrote:

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