• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

What Happened to Row 1?!

Eloise T

Active Member
Please see the attachment. I don't know what happened, but row 1 disappeared. The data is still there because I can see it if I put "A1" in the NAME BOX the data appears in the FORMULA BAR. When I "right arrow" across from A1, the data is visible in the FORMULA BAR. How do I get Row 1 back?
upload_2018-11-15_8-50-52.png
 

Attachments

Please see the attachment. I don't know what happened, but row 1 disappeared. The data is still there because I can see it if I put "A1" in the NAME BOX the data appears in the FORMULA BAR. When I "right arrow" across from A1, the data is visible in the FORMULA BAR. How do I get Row 1 back?
View attachment 56487

Ctrl + A and right click on the rows and select unhide. That should work
 
Hi,
Continue Press mouse on row no 2 & drag till upper triangle mark (Select row 2 with upper triangle mark)
Right click ,click row hight, put value between 10 to 20,
After visible, set row hight as desire.

Hope this helps
 

Eloise T

Active Member
Many thanks to all three of you. My next small dilemma is to figure out how in the world that happened in the first place without me realizing it.
 

Peter Bartholomew

Well-Known Member
Hi Eloise
From the content of Row1 (a shape that runs code and somewhat cryptic developer notes) the fact that it is hidden was by intent, not accident. It might well be that there is a code line in a macro that hides the row.
 

Peter Bartholomew

Well-Known Member
The hyperlink in cell A1 seems to try to open a macro-enabled file in a folder
/ITI T e c h n I c a l S o l u t I o n s/…
It could be that the file contains macros to manipulate this document. if you find the file and open the code window, the thing to look for is
Code:
Worksheet.Rows(1).Hidden = True
though both the range and its Boolean setting may appear as variables.
 
Top