Unable to sort when column is included in range

  • Thread starter Thread starter Trudy
  • Start date Start date
T

Trudy

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.
 
Trudy

The blue-lined column is a "List" from Data>List>Create List

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

Data>List>Convert to Range


Gord Dibben MS Excel MVP
 
Back
Top