When using Numbers, I am finding that rows 2, 3 & 4 slide up under row 1 and can’t be edited. I can view the hidden rows by dragging them down with my finger but as soon as I release my finger they slide back under row 1. Any suggestions as to how I can fix this?
iPad Air, iPadOS 26
Is Row 1 marked as a header row? (Inspector -> Format -> Table -> Headers and Footers?
If so, Numbers will always scroll the table such that the header rows are always visible. Therefore, if you're entering data further down the table (e.g. row 20), Numbers will scroll the table so that row 20 (the active row) and the header row(s) are all visible... the inevitable side effect of this is to scroll the first non-header rows up and 'under' the header rows, which sounds like what you're experiencing.
Most of the time this makes sense - it's useful to see the column headers even when you're way down the spreadsheet. If you don't want this, just turn off the Header Rows in the Table inspector.
Is Row 1 marked as a header row? (Inspector -> Format -> Table -> Headers and Footers?
If so, Numbers will always scroll the table such that the header rows are always visible. Therefore, if you're entering data further down the table (e.g. row 20), Numbers will scroll the table so that row 20 (the active row) and the header row(s) are all visible... the inevitable side effect of this is to scroll the first non-header rows up and 'under' the header rows, which sounds like what you're experiencing.
Most of the time this makes sense - it's useful to see the column headers even when you're way down the spreadsheet. If you don't want this, just turn off the Header Rows in the Table inspector.
Hi Red Whopper,
Does it look something like this? (Screen shot on a Mac, but it looks the same on my iPhone).
You have accidentally dragged the table off the "page" and into the top margin. Hold on the "bullseye" (concentric circles top left of the table) and drag down and/or right .
Regards,
Ian.
Thank you for your response. I don’t understand why, when I freeze row 1 rows 2,3 & 4 disappear beneath it. It makes no sense why this should be the case. I still want to view these rows and perhaps edit them, but I can’t unless I unfreeze row 1. I can slide them down to read them but as soon As I release my finger they disappear again. I can’t think of one reason why anyone would design a spreadsheet with this function.
I guess I'm misunderstanding the issue...
There is no option in Numbers to 'freeze' rows (or columns), other than the header rows/columns.
If the headers are frozen, they will always be visible, so that doesn't sound like your situation.
Can you post more details of what you're actually seeing?
In Numbers, rows 2,3 & 4 disappear under row 1.
