Excel missing rows

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

iMac 27" 5K, macOS 10.14

Posted on Jun 10, 2019 7:39 PM

Reply
Question marked as Top-ranking reply

Posted on Jun 11, 2019 4:00 AM

I suspect the missing rows have been given a row hight of zero. If you select a row above, and then extend the selection downwards you can then right-click on the row labels and set a height. The default is 12.75. Picking Unhide from the context menu may also work.


tt2

3 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Excel missing rows

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.