Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet with a sort on the date column (A). All columns (B-K)
correspond with column A. I have a notes section placed on the same sheet which is column K and all of these rows under this column need to be merged but when I do so I can no longer sort ascending or descending. So my question is... Is there any way I can exclude column K from the sort? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select the columns (and, if necessary, the rows) which you want to sort,
before you impose the sort. By the way, you'll find that merging cells is strongly discouraged here. -- David Biddulph "HoganD87" wrote in message ... I have a spreadsheet with a sort on the date column (A). All columns (B-K) correspond with column A. I have a notes section placed on the same sheet which is column K and all of these rows under this column need to be merged but when I do so I can no longer sort ascending or descending. So my question is... Is there any way I can exclude column K from the sort? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort a list with cells referring to others cells | Excel Discussion (Misc queries) | |||
sort spreadsheet, "merged cells" comes up. Find cells? Unmerge ? | Excel Discussion (Misc queries) | |||
How do I sort protected cells? | Excel Discussion (Misc queries) | |||
sort cells with hyphen #####-###-#### | Excel Discussion (Misc queries) | |||
sort cells with hyphen #####-###-#### | Excel Discussion (Misc queries) |