Cells stop being centered once they get tight vertically and header will not allow option + enter to go a line down

Hello,


  1. I'm looking to get rid of the dead space above my text. I have centered the text both vertically and horizontally but it always stops centering toward the top when I shrink the cells vertically. Trying to optimize the amount of cells but if I go any tighter it cuts off the text like in this view. Is there somewhere that I can set a value to get rid of this extra space above the text?



2. The header of a document doesn't allow for you to go a line down inside itself. Is there a way to do like in the regular cells (option + enter). Otherwise I have to just put in a bunch of spaces manually to allow for this, seems somewhat wasteful.


Posted on Feb 6, 2023 6:44 AM

Reply
Question marked as ⚠️ Top-ranking reply

Posted on Feb 6, 2023 7:18 AM

1- Reduce Text Inset here:



2 - Not sure what you mean by 'header of a document'


SG

Similar questions

3 replies
Sort By: 

Feb 6, 2023 5:14 PM in response to wareagle1999

You probably want to keep table names relatively short. Table names are used in cell references when a cell reference is to a different table. Long names make for long formulas.


Example:


=This is a long name for a table and it makes formulas hard to read::B2÷This is a long name for a table and it makes formulas hard to read::B3


versus


=Table 3::B2÷Table 3::B3


This is the same reason I turn off the Numbers preference "use header names as labels"

Reply

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.

Cells stop being centered once they get tight vertically and header will not allow option + enter to go a line down

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