Re: New sheet with hidden cells

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Re: New sheet with hidden cells

Alan Pearce-2
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.
Please please help.

All the Best!
Melissa Bartman
[hidden email]