Share via

Missing Excel Rows

Anonymous
2019-06-11T02:47:18+00:00

Weird! Just working on an Excel project and noticed unviewable rows. The left edge goes nicely from row 1 to row 733. Then there's a thick-ish green cell-bottom line, and the next row is 1071. Hovering over the green line yields the parallel lines. Click on that and the row number after 733 is now 1070, so 1 row closer. I could do this another 337 times, but wondering what I did to cause this - and maybe how to solve it.

Thanks for any help on this!

Rick

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2019-06-11T02:50:11+00:00

    Hi Rickhess

    Greetings! I am Vijay, an Independent Advisor. I am here to work with you on this problem.

    Either Freeze Panes or Split is applied. Remove it from View tab.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-06-14T09:11:33+00:00

    Hi Rick:

    You can check if those rows are hidden: Hide or show rows or columns

    If not, welcome to share a screenshot of the workbook with us for further support.

    Regards,

    Alex

    Was this answer helpful?

    0 comments