Missing Lines
Solved
lulu
-
Mike-31 Posted messages 18405 Registration date Status Contributeur Last intervention -
Mike-31 Posted messages 18405 Registration date Status Contributeur Last intervention -
Hello everyone.
I need to reshape an Excel file that was given to me. On some sheets, I see that lines are missing. For example, my spreadsheet starts at row 7, and it is impossible to access the previous rows. They have disappeared. I would like to display them. Could someone help me? Thank you in advance for your help.
I need to reshape an Excel file that was given to me. On some sheets, I see that lines are missing. For example, my spreadsheet starts at row 7, and it is impossible to access the previous rows. They have disappeared. I would like to display them. Could someone help me? Thank you in advance for your help.
3 réponses
Hello,
It is possible that your rows are hidden or the height is set to zero
Click on the header of column A Home tab/Cells module/Format/Hide & Unhide/Unhide Rows
If the rows do not appear, they are set to zero; in that case
Home tab/Editing module/Find & Select/Go To/type A1:A7 and OK
directly go to Home tab/Cells module/Format/Hide & Unhide/Row Height enter 15
--
Best,
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
It is possible that your rows are hidden or the height is set to zero
Click on the header of column A Home tab/Cells module/Format/Hide & Unhide/Unhide Rows
If the rows do not appear, they are set to zero; in that case
Home tab/Editing module/Find & Select/Go To/type A1:A7 and OK
directly go to Home tab/Cells module/Format/Hide & Unhide/Row Height enter 15
--
Best,
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
lulu
Thank you for your response Mike-31. I forgot to mention that the lines are not hidden; they have completely disappeared. I tried your methods, but it didn't work.
Re,
Deleted is impossible; if you delete line 1, for example, line 2 becomes line 1
Can you join your file with this link
https://www.cjoint.com/
--
Talk to you soon
Mike-31
A period of failure is a perfect time to plant the seeds of knowledge.
Deleted is impossible; if you delete line 1, for example, line 2 becomes line 1
Can you join your file with this link
https://www.cjoint.com/
--
Talk to you soon
Mike-31
A period of failure is a perfect time to plant the seeds of knowledge.