Sorting / format question

  • Thread starter Thread starter markholt
  • Start date Start date
M

markholt

Something has happened to my file that causes Excel 2007 to select PART of my
file when I sort. I've looked at everything & can't figure why it's doing
this. When I click sort - I want the whole sheet sorted.

No fields or columns are hidden.

If I work fast I risk getting my info all srewed up ....

Mark
 
Any blank rows or columns?

I have found over the years and several versions of Excel to not let Excel
guess the range,

Select all columns to be sorted before hitting the Sort button.


Gord Dibben MS Excel MVP
 
The software should sort the entire page. Is it normal for this problem - I
don't know what is causing it but Excel is limiting the columns to A through
L. Also if you use the AZ quick sort button it does the same. It doesn't
work properly. I thought it was something with my sheet....
 
Actually - I did have a column blank !! I was using it as a working column
to identify needed changes & it was currently blank. I removed that column &
now it sorts fine.

I guess MS did this to make it fast....I didn't know this. Learned
something today !!
 
Thanks for the feedback.

Now you see why I select all columns prior to the sort<g>


Gord
 
Yes, you got it right !!

They should really make reference to this in the Excel help - seems like it
was done on purpose to keep the sort faster - but it's NOT user friendly &
can cause A LOT of head ache. When this 1st happened it mixed all my info. -
I wasn't paying attention to the way it highlights & especially when you use
the quick sort button.

This can be DANGEROUS !!
 
Back
Top