| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Are Hidden Rows/ Columns Included in a Sort? | Excel Discussion (Misc queries) | |||
| how many columns are included in a standard sort in Excel? | Excel Discussion (Misc queries) | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| prevent column from being included in sort in Excel | Excel Discussion (Misc queries) | |||
| Header included in sort | Excel Worksheet Functions | |||
Linear Mode
