| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sort columns within a merged cell header
I have two colums ( A & B) with one header that I put into a merged cell, I
am trying sort the two colums seperately, but it keeps popping up that the cells are merged...help |
|
#2
|
|||
|
|||
|
Diana,
Only sort the data, not the header. If your merged cell is A1&B1 then: Select cells A2:B2 and down to the bottom of your data.(eg, cells A2:B999) Now do a sort. Henry "Diana" wrote in message ... I have two colums ( A & B) with one header that I put into a merged cell, I am trying sort the two colums seperately, but it keeps popping up that the cells are merged...help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link page header with cell contents | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| How to exclude header row from sort button sorts? | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
