Post Reply 

Hidden Cells

Aug 6, 2013, 01:39
Post: #1
Hidden Cells
While using Open Office, I've hidden a number of cells. How do I open them again?

As always, I appreciate the help.

Tom
Western Canada
Find all posts by this user
Quote this message in a reply
Aug 6, 2013, 03:49
Post: #2
RE: Hidden Cells
Ctrl+A to select all and then Format --> Cells... Cell Protection and uncheck Hide.
If you hide columns or rows you can do that the same too.
Visit this user's website Find all posts by this user
Quote this message in a reply
Aug 6, 2013, 08:51
Post: #3
RE: Hidden Cells
For the cells to be hidden the document/sheet has to be in protected mode (Tools -> Protect Document). You will have to use the password you assigned. Then you reformat them.

If it is just some hidden columns (or rows) where the width is effectively zero then a couple of ways to do this,
1. Identify the column, eg. if the run A, B, D... then you know C is hidden.
2. Type in a 'C' cell in the search box, that takes you to the hidden column.
3. Now you can go and unhide the column.

[Image: 65VzoKd.jpg]

Another way is to 'click-n-swipe' to select the columns B.thro.D and go to formatting then format the column width back to say default.
The snag with that is you lose the original width setting of the B and D columns

** https://www.gimp-forum.net/ now answering questions**
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


GIMP ForumPortalArchiveContactTermsRSS