View original (French)

Excel Row Display Issue

Solved
sammy79 Posted messages 3 Status Membre -  
 Pierre65 -
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

5 answers

Answer 1 / 5
Anonymous user
 
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
Pictave
 
It is wonderful to find people like you, thank you for sharing your knowledge.
Best wishes.
0
sandrine
 
Thank you, it was a line height issue at 0, but your response helped me find the problem.
0
Pil
 
You are always on point! Thank you!
0
Olivier1984
 
Thank you for the copy and paste solution in another tab :)
0
Pierre65
 

Select the entire tab

Home

Format

Hide and show

Hide

Show

It is important to hide and then show.

0