Top 27 rows of Spreadsheet in Numbers have disappeared. How do I get them back? All calculations using those rows still work.

How to get back missing rows in Numbers spreadsheet.

Posted on Apr 27, 2018 7:37 AM

Reply
Question marked as Top-ranking reply

Posted on May 1, 2018 3:55 PM

Hi Kolken,


Perhaps you accidentally dragged the table "off the page" so to speak. This table has Freeze Header Rows, and so Row 1 is still visible.

User uploaded file

Click on the "bullseye" top left and drag the table down and/or right to put in back within the page margins.

I find these settings useful when dragging objects. Alignment guides appear when you drag an object, including guides at the top and left margins.

Numbers Preferences > Rulers > Alignment Guides:

User uploaded file

Regards,

Ian.

4 replies
Question marked as Top-ranking reply

May 1, 2018 3:55 PM in response to Kolken

Hi Kolken,


Perhaps you accidentally dragged the table "off the page" so to speak. This table has Freeze Header Rows, and so Row 1 is still visible.

User uploaded file

Click on the "bullseye" top left and drag the table down and/or right to put in back within the page margins.

I find these settings useful when dragging objects. Alignment guides appear when you drag an object, including guides at the top and left margins.

Numbers Preferences > Rulers > Alignment Guides:

User uploaded file

Regards,

Ian.

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.

Top 27 rows of Spreadsheet in Numbers have disappeared. How do I get them back? All calculations using those rows still work.

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