If you haven't saved you can use the "undo" button. Also I think you can highlight the cells and click the merge button again and it will unmerge leaving the text visible.
-------- Original message -------- From: Melissa Bartman <[hidden email]> Date: 04/09/2018 19:07 (GMT+00:00) To: [hidden email] Subject: New sheet with hidden cells
Please help me. I just created a file with ten worksheets for a new job. I need the new sheet to merge the first three columns but when I try to do that I get a message that says, “Should the contents of the hidden cells be moved into the first cell?” I’ve checked the sheet formatting but it should be an unformatted sheet if it’s new. I went to the setting for row - show and column show to expose any hidden. That doesn’t help. And it doesn’t matter if I say yes or no to the message. I get one wide column. Text is gone. I tried formatting the column Top Right justified and then I see only the top word. The rest disappears Screen shots are below.
It took me three weeks to create the sheets and it would be devastating if the file has been corrupted in some way.