Hi,

The selection will not expand across a totally blank column or row. Just
select all the data, for example A1:H100, and then choose the sort command.

In addition, I am not clear on what you mean by "I checked the prior columns
by
highlighting the entire column. When doing so, the Sort is disabled for all
the columns but the last two." What do you mean by checked the prior columns? Where did you check them? When you say the sort is disabled for all ... what do you mean? If you put your cursor in any single cell of any other column except the last two, are you saying the Sort options in not available? What version of Excel are you using?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Mikki" wrote:

I have a spreadsheet with 9 columns. I want to sort the last column and
first columns. I am highlighting the column and clicking on Sort. I get the
popup asking if I want to expand the selection (which I tell it to expand).
It will only expand the selection to the two columns on the end and will not
include the prior columns. To troubleshoot, I checked the prior columns by
highlighting the entire column. When doing so, the Sort is disabled for all
the columns but the last two.

I've also copied/pasted the contents into a new file and am having the same
problem. I'm out of ideas and am open to suggestions.

I'm running Office 2007 w/SP1.

Thanks in advance!