Problems sorting spreadsheet - Please Help


S

Stockwell43

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

Advertisements

D

David Biddulph

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).
 
S

Stockwell43

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

FSt1

hi
this sounds like sub totals.
2003 on the menubar.....Data>subtotal>removeall>ok


Regards
FSt1
 
S

Stockwell43

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.
 
Ad

Advertisements

S

Stockwell43

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top