cannot change part of a merged cell

  • Thread starter Thread starter shank
  • Start date Start date
S

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!
 
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
 
....gotta use merged cells. That's the only way to layout a comprehensive,
tight form and make it look good.

thanks
 
Back
Top