1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. 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?!

Discussion in 'Ask an Excel Question' started by Eloise T, Nov 15, 2018.

  1. Eloise T

    Eloise T Active Member

    Messages:
    851
    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

    Attached Files:

    sureshsonti likes this.
  2. chirayu

    chirayu Well-Known Member

    Messages:
    959
    hover over left hand side row numbers at the top. row height is reduced. thats why not visible
    Eloise T likes this.
  3. sureshsonti

    sureshsonti Member

    Messages:
    117

    Ctrl + A and right click on the rows and select unhide. That should work
    Eloise T likes this.
  4. Chirag R Raval

    Chirag R Raval Member

    Messages:
    662
    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 likes this.
  5. Eloise T

    Eloise T Active Member

    Messages:
    851
    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.
  6. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    584
    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.
  7. Eloise T

    Eloise T Active Member

    Messages:
    851
    Thanks. I'll look into that.
  8. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    584
    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 (vb):
    Worksheet.Rows(1).Hidden = True
    though both the range and its Boolean setting may appear as variables.
  9. Eloise T

    Eloise T Active Member

    Messages:
    851
    Thanks, Peter!

Share This Page