Excel help!

[NiceCupOfTea]

I'm trying to merge some cells - 3 cells in a row, data in left hand cell, middle and right cells empty, want to make one big cell. I can do it individually, but I have about 100 rows to do and if I select it all and use the merge cells tool it only keeps the top left hand cell!

Help!

[NiceCupOfTea]

It won't let me paste special, and when I just paste I get a #REF error (presumably as I am copying over the cells that are referred to )

[NiceCupOfTea]

TurricanII said:

Once you have the column of merged Cells with your 100 values in, aa2 - ac2 down to aa102 to ac102, hightlight and right click THEM and then right click them while they are still highlighted and Paste Special/Values. You can then drag them around

Yes, that worked, but it's only one cell wide again now

[NiceCupOfTea]

I can't see how.

I copy the merged cells, paste special/values - and it looks like the original (ie not merged).

Excel 2003 SP2 here.

Thanks for the help anyway, reckon I should have just gone and done it by hand, would be done by now, bloody computers

[NiceCupOfTea]

GasMonkey said:

NiceCupOfTea said:

TurricanII said:

Once you have the column of merged Cells with your 100 values in, aa2 - ac2 down to aa102 to ac102, hightlight and right click THEM and then right click them while they are still highlighted and Paste Special/Values. You can then drag them around

Yes, that worked, but it's only one cell wide again now

? not sure why that wont work for you

Pressing CTRL while selecting multiple groups of cells. then click format cells, merge

"Cannot merge overlapping ranges"

It's just a grid of 3x100 cells with the left hand one filled with text (no formulae).

I've actually done it all by hand now, but it's annoying me that something that seems quite simple is so difficult...

[NiceCupOfTea]

Thanks for all the help guys - TurricanII, I wasn't overlapping the cells so not sure what I was doing wrong there