cannot change part of a merged cell

[shank]

Annoying problem...
I merged cells and come time to paste from the clipboard into a merged cell,
I get the error it can't be done. I can hit F2 and paste. It's an annoying
step and users who are not quick on the draw with Excel would be stuck.

Is there a way to stop the error and succeed with a paste?

thanks!

 

[muddan madhu]

don't use office clipboard use Ctrl + C & Ctrl +V

 

[Gord Dibben]

Don't use merged cells.

The problem you found is only one of a great many you will come across when
using merged cells.


Gord Dibben MS Excel MVP

 

[shank]

....gotta use merged cells. That's the only way to layout a comprehensive,
tight form and make it look good.

thanks

 

[Gord Dibben]

OK


Gord

...gotta use merged cells. That's the only way to layout a comprehensive,
tight form and make it look good.

thanks

 

[shank]

nope - that's how it's formatted.

Will Format > Cells > Alignment > Horizonal > Center across selection work
for you?

HTH
Regards,
Howard