Unable to sort when column is included in range
 

We have a spreadsheet that when a specific column is included in a selected
range, the sorting tools are disabled. The problem column can be sorted by
itself and the surrounding columns can be sorted when it is not included in
the selection. The problem column also is surrounded by a blue border that
can be resized like a drawn object.

Thanks for your help.

Unable to sort when column is included in range
 

Trudy

The blue-lined column is a "List" from DataListCreate List

To change it back to a regular column...................

DataListConvert to Range


Gord Dibben MS Excel MVP

On Mon, 7 Jul 2008 17:32:01 -0700, Trudy
wrote:

We have a spreadsheet that when a specific column is included in a selected
range, the sorting tools are disabled. The problem column can be sorted by
itself and the surrounding columns can be sorted when it is not included in
the selection. The problem column also is surrounded by a blue border that
can be resized like a drawn object.

Thanks for your help.