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!!!

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!!!

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!!!

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!!!

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!!!

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!!!

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!!!