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 |