| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I sort an Excel Doc containing merged & non-merged cells?
I have a doc that contains both merged and unmerged cells and need to be able
to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort an Excel Doc containing merged & non-merged cells?
hi
might be best to get rid of the merged cells. Regards FSt1 "KellyH" wrote: I have a doc that contains both merged and unmerged cells and need to be able to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort an Excel Doc containing merged & non-merged cel
Getting rid of merged cells causes you to lose data. I am using a template
and didn't merge any cells. didn't even know there were any merged cells until I had entered ALL the data and tried to sort. "FSt1" wrote: hi might be best to get rid of the merged cells. Regards FSt1 "KellyH" wrote: I have a doc that contains both merged and unmerged cells and need to be able to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort an Excel Doc containing merged & non-merged cel
No, merging cells causes loss of data. Unmerging cells puts blank cells
where you hadn't noticed them before. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "BarbMac" wrote in message ... Getting rid of merged cells causes you to lose data. I am using a template and didn't merge any cells. didn't even know there were any merged cells until I had entered ALL the data and tried to sort. "FSt1" wrote: hi might be best to get rid of the merged cells. Regards FSt1 "KellyH" wrote: I have a doc that contains both merged and unmerged cells and need to be able to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort an Excel Doc containing merged & non-merged cel
I unmerged and tried to sort. It put my totals in the middle of the page.
"Jon Peltier" wrote: No, merging cells causes loss of data. Unmerging cells puts blank cells where you hadn't noticed them before. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "BarbMac" wrote in message ... Getting rid of merged cells causes you to lose data. I am using a template and didn't merge any cells. didn't even know there were any merged cells until I had entered ALL the data and tried to sort. "FSt1" wrote: hi might be best to get rid of the merged cells. Regards FSt1 "KellyH" wrote: I have a doc that contains both merged and unmerged cells and need to be able to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort an Excel Doc containing merged & non-merged cel
Then you have to select the exact range to sort, without including header
row and total row. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "BarbMac" wrote in message ... I unmerged and tried to sort. It put my totals in the middle of the page. "Jon Peltier" wrote: No, merging cells causes loss of data. Unmerging cells puts blank cells where you hadn't noticed them before. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "BarbMac" wrote in message ... Getting rid of merged cells causes you to lose data. I am using a template and didn't merge any cells. didn't even know there were any merged cells until I had entered ALL the data and tried to sort. "FSt1" wrote: hi might be best to get rid of the merged cells. Regards FSt1 "KellyH" wrote: I have a doc that contains both merged and unmerged cells and need to be able to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort an Excel Doc containing merged & non-merged cells?
You can't.
Get rid of those merged cells that cause so many problems. Gord Dibben MS Excel MVP On Thu, 8 May 2008 05:59:01 -0700, KellyH wrote: I have a doc that contains both merged and unmerged cells and need to be able to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort an Excel Doc containing merged & non-merged cel
Getting rid of merged cells causes you to lose data. I am using a template
and didn't merge any cells. didn't even know there were any merged cells until I had entered ALL the data and tried to sort. "Gord Dibben" wrote: You can't. Get rid of those merged cells that cause so many problems. Gord Dibben MS Excel MVP On Thu, 8 May 2008 05:59:01 -0700, KellyH wrote: I have a doc that contains both merged and unmerged cells and need to be able to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort an Excel Doc containing merged & non-merged cel
Getting rid of merged cells does NOT cause any loss of data.
Merging cells will cause loss of data. Gord Dibben MS Excel MVP On Mon, 9 Jun 2008 06:41:01 -0700, BarbMac wrote: Getting rid of merged cells causes you to lose data. I am using a template and didn't merge any cells. didn't even know there were any merged cells until I had entered ALL the data and tried to sort. "Gord Dibben" wrote: You can't. Get rid of those merged cells that cause so many problems. Gord Dibben MS Excel MVP On Thu, 8 May 2008 05:59:01 -0700, KellyH wrote: I have a doc that contains both merged and unmerged cells and need to be able to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort an Excel Doc containing merged & non-merged cells?
It doesn't mean height and width of the cells, it means number of rows and
columns of cells in a merged cell. I'll be the third to say, get rid of the merged cells. They cause more problems than this. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "KellyH" wrote in message ... I have a doc that contains both merged and unmerged cells and need to be able to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort an Excel Doc containing merged & non-merged cel
Getting rid of merged cells causes you to lose data. I am using a template
and didn't merge any cells. didn't even know there were any merged cells until I had entered ALL the data and tried to sort. "Jon Peltier" wrote: It doesn't mean height and width of the cells, it means number of rows and columns of cells in a merged cell. I'll be the third to say, get rid of the merged cells. They cause more problems than this. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "KellyH" wrote in message ... I have a doc that contains both merged and unmerged cells and need to be able to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort an Excel Doc containing merged & non-merged cel
What data did you lose by unmerging cells? It doesn't work that way. The
data in a merged cell will be retained in the top left cell of the unmerged cells that had been merged. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "BarbMac" wrote in message ... Getting rid of merged cells causes you to lose data. I am using a template and didn't merge any cells. didn't even know there were any merged cells until I had entered ALL the data and tried to sort. "Jon Peltier" wrote: It doesn't mean height and width of the cells, it means number of rows and columns of cells in a merged cell. I'll be the third to say, get rid of the merged cells. They cause more problems than this. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "KellyH" wrote in message ... I have a doc that contains both merged and unmerged cells and need to be able to sort it alphabetically. When I try, I get a message saying that all merged cells need to be sized identically. I have tried resizing the cells, but this does not solve the problem. Any suggestions? |
| 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) | |||
| how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
| How I sort data in Excel, it keeps saying "merged cells must be ID | Excel Worksheet Functions | |||
| Unable to sort in Excel because of merged cells | Excel Discussion (Misc queries) | |||
| Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
Hybrid Mode
