Add text above spreadsheet

I've created a spreadsheet that lists several pages of names, addresses and phone numbers. Between the title and the header row, I want to insert a few lines of text that explain a few things about the spreadsheet. This seems like it should be easy to do, but I can't do it even after searching the Numbers help. I've been able to create a text box and can move it around and edit it, but it overlays the spreadsheet so it's not readable. What's the best way to enter a few lines of explanatory text at the top of my spreadsheet?

MacBook Air 13″, macOS 10.15

Posted on Nov 15, 2020 4:57 PM

Reply
Question marked as Top-ranking reply

Posted on Nov 15, 2020 7:13 PM

A spreadsheet in Numbers is a document. A document contains sheets (tabs) and sheets contain tables, charts, and other objects. Do you mean a table?


Why not just create a text box as you have done, hide the table name (Format and uncheck 'Title' in the Table tab in the panel at the right) and place the text box right above the table that so it doesn't overlap it?


SG

5 replies
Question marked as Top-ranking reply

Nov 15, 2020 7:13 PM in response to SwtPeach

A spreadsheet in Numbers is a document. A document contains sheets (tabs) and sheets contain tables, charts, and other objects. Do you mean a table?


Why not just create a text box as you have done, hide the table name (Format and uncheck 'Title' in the Table tab in the panel at the right) and place the text box right above the table that so it doesn't overlap it?


SG

Nov 15, 2020 7:44 PM in response to SwtPeach

The text box will not make the table move. But you can move the table yourself. Select it and drag from the circle at the top left of the table.


You will not be able to fit a text box between the table title and the header row unless it is really really small print. SGIII suggested turning off the title for the table. Put the table title in the text box along with the other text you want. Format the different pieces of text as you like, center the title, make it a larger font, etc. until it all looks like what you want.

Nov 15, 2020 7:33 PM in response to SGIII

Sorry, the terminology is new to me, so yes I guess do mean a table.


Perhaps I'm not understanding something, but no matter where I move the text box, it overlaps the table. In Pages, I'm used to using the wrap feature to have different elements laid out the way I want them on the page.


I can put the text box above the table, but there's very little room there, not enough to put the info I want. And the table does not move down as I type more lines in the text box.


I did find a workaround, which is to insert extra rows at the top of the table, then add a rectangle with a white background to overlay the first few lines of table, then place the text box on top of that. In that way I can keep my title, then have the information I want to include, then the table begins, albeit at line 8 instead of line 1. But that's not a problem since I won't be printing the line numbers.


However, if there's a more efficient way to do this I'd still love to know.

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.

Add text above spreadsheet

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