I'd select the whole range and do the sort. I never let excel guess.

It scares me too much.

KarenF wrote:

It so happens I DO have an empty column 65, with more scattered throughout.
Now it makes perfect sense - Excel doesn't realize there's more data after
that. I solved the problem by adding a blank (" ") as the column header.

Thank you!

"Bernie Deitrick" wrote:

Karen,

No, there isn't any limit (at least, none that I am aware of.) Are you sure you don't have a hidden
column that's blank (column 65 or, appropriately enough, column BM)? Excel will sort the
currentregion of the activecell, so any fully blank columns will cause that kind of disconnect.

HTH,
Bernie
MS Excel MVP


"KarenF" wrote in message
...
We've recently made a very long spreadsheet with about 80 columns. BAD
things happen!

When people do a lazy sort - that is, ctrl home, Sort and use the populated
defaults, Excel only "selects" 64 columns. Of course this totally pooches
the data and creates disconnects.

No problems when the user selects the whole spreadsheet (by selecting the
upper lefthand corner), sorts and fills in the criteria themselves.

My question is, is this for real or am I imagining it? Is there a limit of
64 columns in Excel on that lazy sort? We're dealing with the workaround, I
just want to know I'm not crazy.

Karen F.




--

Dave Peterson