Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merged Cell Sorting
I'm working with a table that tracks my activities and projects each week.
My supervisor asked me to add in at the bottom a list of meetings I've held with the various groups I support. The report I'm updating tracks about 10 columns. I need twelve for the months and a 13th for the departments name. Being cleaver, I added the columns I needed, then merged the cells to make the appearance the same as before, but with the ability to add my meeting tracking below. I have verified that all the rows in Excel are the same, each with the same merged cells. But now, I cannot sort! I'm advised that the "operation requries the merged cells to be identically sized." Even if I only select two rows, I get the same message. I promise they are the same size! In every respect! The only way I can sort now is to unmerge all the cells, then sort, then remerge. This just can't be right. Does anyone have an idea about what I'm overlooking or why I'm so challenged? I'd sure appreciate the help! -- Thanks, Randy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merged Cell Sorting
hi
another reason not to use merged cells. my thoughts Regards FSt1 "Randy Rich" wrote: I'm working with a table that tracks my activities and projects each week. My supervisor asked me to add in at the bottom a list of meetings I've held with the various groups I support. The report I'm updating tracks about 10 columns. I need twelve for the months and a 13th for the departments name. Being cleaver, I added the columns I needed, then merged the cells to make the appearance the same as before, but with the ability to add my meeting tracking below. I have verified that all the rows in Excel are the same, each with the same merged cells. But now, I cannot sort! I'm advised that the "operation requries the merged cells to be identically sized." Even if I only select two rows, I get the same message. I promise they are the same size! In every respect! The only way I can sort now is to unmerge all the cells, then sort, then remerge. This just can't be right. Does anyone have an idea about what I'm overlooking or why I'm so challenged? I'd sure appreciate the help! -- Thanks, Randy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Sorting merged cells | Excel Worksheet Functions | |||
sorting merged cell question | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |