If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problems sorting spreadsheet - Please Help
Hello,
I was sent a spreadsheet that when I try to sort and expand selection it gives me a message: This operation requires the merged cells to be identically sized. When I click on show help it says to unmerge all cells or make cells the same size as merge cells. I looked in the help and could not find anything on unmerging cells. So how do I get this report to sort?? I need to sort it by the Loam Amount Column. Any help would be most appreciated!!! |
#2
|
|||
|
|||
Problems sorting spreadsheet - Please Help
Click in the top left hand corner (above row 1, and to the left of column A)
to select the whole sheet. Then Format/ Cells/ Alignment, and unselect "Merge cells", (and swear a solemn vow never to merge cells again). -- David Biddulph "Stockwell43" wrote in message ... Hello, I was sent a spreadsheet that when I try to sort and expand selection it gives me a message: This operation requires the merged cells to be identically sized. When I click on show help it says to unmerge all cells or make cells the same size as merge cells. I looked in the help and could not find anything on unmerging cells. So how do I get this report to sort?? I need to sort it by the Loam Amount Column. Any help would be most appreciated!!! |
#3
|
|||
|
|||
Problems sorting spreadsheet - Please Help
Hi David,
Thank you for replying. That worked great, thanks! One more thing, on the left side of the spreadsheet next to A are 2 little buttons that say 1 and 2. Below those are little boxess with + signs. How can I get rid of those? Thanks! "David Biddulph" wrote: Click in the top left hand corner (above row 1, and to the left of column A) to select the whole sheet. Then Format/ Cells/ Alignment, and unselect "Merge cells", (and swear a solemn vow never to merge cells again). -- David Biddulph "Stockwell43" wrote in message ... Hello, I was sent a spreadsheet that when I try to sort and expand selection it gives me a message: This operation requires the merged cells to be identically sized. When I click on show help it says to unmerge all cells or make cells the same size as merge cells. I looked in the help and could not find anything on unmerging cells. So how do I get this report to sort?? I need to sort it by the Loam Amount Column. Any help would be most appreciated!!! |
#4
|
|||
|
|||
Problems sorting spreadsheet - Please Help
hi
this sounds like sub totals. 2003 on the menubar.....Datasubtotalremoveallok Regards FSt1 "Stockwell43" wrote: Hi David, Thank you for replying. That worked great, thanks! One more thing, on the left side of the spreadsheet next to A are 2 little buttons that say 1 and 2. Below those are little boxess with + signs. How can I get rid of those? Thanks! "David Biddulph" wrote: Click in the top left hand corner (above row 1, and to the left of column A) to select the whole sheet. Then Format/ Cells/ Alignment, and unselect "Merge cells", (and swear a solemn vow never to merge cells again). -- David Biddulph "Stockwell43" wrote in message ... Hello, I was sent a spreadsheet that when I try to sort and expand selection it gives me a message: This operation requires the merged cells to be identically sized. When I click on show help it says to unmerge all cells or make cells the same size as merge cells. I looked in the help and could not find anything on unmerging cells. So how do I get this report to sort?? I need to sort it by the Loam Amount Column. Any help would be most appreciated!!! |
#5
|
|||
|
|||
Problems sorting spreadsheet - Please Help
Hi FSt1,
Thank you for your reply. I tried what you said and when I clicked remove all, the box closed but nothing happened to the spreadsheet. The little boxes with the 1 and 2 and all the little boxes underneath with the plus signs are still there. However, you are correct about the subtotals because it did show up on the menu when I click on subtotals. "FSt1" wrote: hi this sounds like sub totals. 2003 on the menubar.....Datasubtotalremoveallok Regards FSt1 "Stockwell43" wrote: Hi David, Thank you for replying. That worked great, thanks! One more thing, on the left side of the spreadsheet next to A are 2 little buttons that say 1 and 2. Below those are little boxess with + signs. How can I get rid of those? Thanks! "David Biddulph" wrote: Click in the top left hand corner (above row 1, and to the left of column A) to select the whole sheet. Then Format/ Cells/ Alignment, and unselect "Merge cells", (and swear a solemn vow never to merge cells again). -- David Biddulph "Stockwell43" wrote in message ... Hello, I was sent a spreadsheet that when I try to sort and expand selection it gives me a message: This operation requires the merged cells to be identically sized. When I click on show help it says to unmerge all cells or make cells the same size as merge cells. I looked in the help and could not find anything on unmerging cells. So how do I get this report to sort?? I need to sort it by the Loam Amount Column. Any help would be most appreciated!!! |
#6
|
|||
|
|||
Problems sorting spreadsheet - Please Help
DataGroup and OutlineUngroup
Gord Dibben MS Excel MVP On Thu, 6 Nov 2008 11:44:01 -0800, Stockwell43 wrote: Hi FSt1, Thank you for your reply. I tried what you said and when I clicked remove all, the box closed but nothing happened to the spreadsheet. The little boxes with the 1 and 2 and all the little boxes underneath with the plus signs are still there. However, you are correct about the subtotals because it did show up on the menu when I click on subtotals. "FSt1" wrote: hi this sounds like sub totals. 2003 on the menubar.....Datasubtotalremoveallok Regards FSt1 "Stockwell43" wrote: Hi David, Thank you for replying. That worked great, thanks! One more thing, on the left side of the spreadsheet next to A are 2 little buttons that say 1 and 2. Below those are little boxess with + signs. How can I get rid of those? Thanks! "David Biddulph" wrote: Click in the top left hand corner (above row 1, and to the left of column A) to select the whole sheet. Then Format/ Cells/ Alignment, and unselect "Merge cells", (and swear a solemn vow never to merge cells again). -- David Biddulph "Stockwell43" wrote in message ... Hello, I was sent a spreadsheet that when I try to sort and expand selection it gives me a message: This operation requires the merged cells to be identically sized. When I click on show help it says to unmerge all cells or make cells the same size as merge cells. I looked in the help and could not find anything on unmerging cells. So how do I get this report to sort?? I need to sort it by the Loam Amount Column. Any help would be most appreciated!!! |
#7
|
|||
|
|||
Problems sorting spreadsheet - Please Help
Hi Gord,
You were correct except instead of Ungroup it was Clear Outline but you got me to where I needed to go as I never dealt with this before but now I gain another piece of knowledge on Excel, Thank you!!!!! "Gord Dibben" wrote: DataGroup and OutlineUngroup Gord Dibben MS Excel MVP On Thu, 6 Nov 2008 11:44:01 -0800, Stockwell43 wrote: Hi FSt1, Thank you for your reply. I tried what you said and when I clicked remove all, the box closed but nothing happened to the spreadsheet. The little boxes with the 1 and 2 and all the little boxes underneath with the plus signs are still there. However, you are correct about the subtotals because it did show up on the menu when I click on subtotals. "FSt1" wrote: hi this sounds like sub totals. 2003 on the menubar.....Datasubtotalremoveallok Regards FSt1 "Stockwell43" wrote: Hi David, Thank you for replying. That worked great, thanks! One more thing, on the left side of the spreadsheet next to A are 2 little buttons that say 1 and 2. Below those are little boxess with + signs. How can I get rid of those? Thanks! "David Biddulph" wrote: Click in the top left hand corner (above row 1, and to the left of column A) to select the whole sheet. Then Format/ Cells/ Alignment, and unselect "Merge cells", (and swear a solemn vow never to merge cells again). -- David Biddulph "Stockwell43" wrote in message ... Hello, I was sent a spreadsheet that when I try to sort and expand selection it gives me a message: This operation requires the merged cells to be identically sized. When I click on show help it says to unmerge all cells or make cells the same size as merge cells. I looked in the help and could not find anything on unmerging cells. So how do I get this report to sort?? I need to sort it by the Loam Amount Column. Any help would be most appreciated!!! |
Thread Tools | |
Display Modes | |
|
|