View original (French)

Excel Row Display Issue

Solved
sammy79 -  
Hello,

I have a problem with an Excel file. I can no longer see rows 1 to 6. My spreadsheet starts at row 7. I tried selecting the entire sheet to unhide the hidden rows; I also did an auto-fit for all rows, but to no avail.

Can someone help me? Thank you very much. See you soon. Sammy
Configuration: Windows XP Internet Explorer 6.0

5 answers

  1. tontong
    Hello,
    This is likely the result of: Format-->Row-->Hide.
    Place the mouse pointer just above the 7 on the line that should appear in bold, click and drag down.
    Another solution is to copy the data onto a whole sheet.
    See you!
    15
    1. Pictave
      It is wonderful to find people like you, thank you for sharing your knowledge.
      Best wishes.
      0
    2. sandrine
      Thank you, it was a line height issue at 0, but your response helped me find the problem.
      0
    3. Pil
      You are always on point! Thank you!
      0
    4. Olivier1984
      Thank you for the copy and paste solution in another tab :)
      0
    5. Pierre65

      Select the entire tab

      Home

      Format

      Hide and show

      Hide

      Show

      It is important to hide and then show.

      0