How do I reveal hidden data in the top three rows of a Numbers table?

Question

How do I reveal hidden data in the top three rows of a Numbers table?

I have created a table using Numbers.

The top three rows have data in them but are hidden by the line of column identifiers that Numbers puts at the table (ie top left A, incrementing a letter at a time as it goes right). For some reason Numbers is writing these letters over my data rather than outside the data area.

My first cell containing data is A1. The first visible is A4. If I put the cursor in A4 and move up with the keyboard arrows all that happens is the red selection rectangle moves up the screen without revealing the data.

Am I the only person who has this problem? Google cannot answer.

It would be nice if somebody could do Apple's job and fix their software, or direct me to the secret instruction.

Thanks.

Apple Silicon3 iMac, Sonoma (14.7.4

[Re-Titled By Moderator]

iMac 24″, macOS 14.7

Posted on Apr 7, 2025 2:29 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,550 points

Apr 7, 2025 5:52 AM in response to Franknfurterx

Your table may be too high on the canvas. Try moving it down a little.

To do that, click in the table, then click the concentric circles "bulls-eye" at the upper left corner of the table and drag it down.

SG

Reply

Answer 2

Apr 7, 2025 2:50 AM in response to Franknfurterx

I have sussed it!

This is a freeze header rows issue, not an Apple column title problem. And i sussed it when I froze the top rows.

Because Numbers comes free with the OS, USA and EU in is potentially in breach of Competition Law which doesn't like big companies giving away free stuff to squeeze out small enterprises, (remember the Internet Explorer thing in the 1990s?) So the coders have to make Numbers inferior or else MS, who charge an arm an a leg for Office whatever and the folk who make other office applications will (justifiably) complain.

The issue is that when you freeze the number of header rows of your choice, Numbers will prevent you from seeing the next three rows.

So cheapskate cognoscenti need to deploy the following hack:- insert three empty rows between the bottom of your headder and the top of your data. Remember to hide the rows prior to printing.

Reply

Answer 3

Apr 7, 2025 2:52 AM in response to Franknfurterx

that should read............"free with the OS, in the USA and EU it is potentially in breach......." Sorry

Reply

How do I reveal hidden data in the top three rows of a Numbers table?

Similar questions