I never let excel guess at the range to be sorted. I always select the entire
range to sort, then use data|sort.

Excel can get confused when there are gaps in rows or columns and figure that
the range stops before the gap.



Gillian72 wrote:

I've checked around this site and am unable to find my issue (of which I have
many. Sorry. Too personal.) Anyway, I work daily in a large spreadsheet
that has a growing number of rows and columns to BI (recently added from BA).
Now when I perform a sort, it only sorts from A - BA, with columns BC - BI
staying the same and all the data getting muck a muck. I can sort by
highlighting the specific cells (A - BI and 3 - 193). I'm wondering why the
Data - Sort doesn't automatically recognize the new columns. If I don't
highlight anything and go to Data - Sort, it has a range to BA. If I'm
clicked on a cell such as BG, it highlights only a segment of the sheet
(looks like column 88 to something and BD to BI).
If anyone can assist, that would be great.
Thanks!

--

Dave Peterson