I have 2 merged cells where each has the same value, but I have no idea how it was do

Hey there,

This one is a bit sneaky.
Sort of a hack that I don't think Microsoft really intended but it is possible to hide information in the merged cell.

There are good uses for this, but its for the crafty to play this way.


All that you need to do is first fill in the data. Both Left and Right (This isnt just for 2 cells but that is what you are doing in your example... SHAPE will be key in a moment, for this the shape is 1x2 (1 row X 2 col))

Lets be ahead of the game, knowing your intent is to always have both cells represent the displayed merged value... simply make the right = the left...
In your example, Unmerge Exercise GRP and in C9 Type = B9. Now they say the same thing!

Now Merge any two cells side by side (You can use ones that are present but for example sake, merge two new ones)

Now that it is done...here comes the magic!!!!

Click on the merged cells and click ...ready... Format Painter. Yup! thats it, Format Painter, once you click that lil guy the merged cell will have the running ants to let you know it is mocking what is selected.
Simply Paint your desired merge in this case click B9 and it will cover up C9, but C9 will remain =B9


Now when you write something in the newly merged cell, you will be updating B9 and C9 will equal that!


Tricky Tricky Tricks...

No worries! Glad it was what you were looking for... dont see a lot of people trying to do that.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.