Expanding Cells
I have a spreadsheet that has multiple tables. In several, the cell expands automatically to accept data. See here
In this one that does not happen
Is there a setting that is missing in the 2nd one?
MacBook Air (M1, 2020)
I have a spreadsheet that has multiple tables. In several, the cell expands automatically to accept data. See here
In this one that does not happen
Is there a setting that is missing in the 2nd one?
MacBook Air (M1, 2020)
dtryon9981 wrote:
the strange thing is that in the 1st screenshot that table automatically does that without me having to manually do it
In that table you probably had not explicitly set a row height.
Once you explicitly set a Height (either by changing the value in the Row & Column Size section or by adjusting the height using your mouse) the cell no longer expands automatically. Clicking Fit will restore the default behavior.
SG
dtryon9981 wrote:
the strange thing is that in the 1st screenshot that table automatically does that without me having to manually do it
In that table you probably had not explicitly set a row height.
Once you explicitly set a Height (either by changing the value in the Row & Column Size section or by adjusting the height using your mouse) the cell no longer expands automatically. Clicking Fit will restore the default behavior.
SG
If 'Wrap text in cell' is already checked then (with the relevant cells or rows or columns selected) go to the Table tab and try clicking Fit next to Height in the Row & Column Size section.
SG
Select the cells that aren't doing what you want and try checking the 'Wrap text in cell' checkbox under the Text tab.
SG
The wrap text is already checked but the cell does not enlarge. I was under the impression that the wrap text feature would expand the box horizontally.
SG,
Yes, that does it but the strange thing is that in the 1st screenshot that table automatically does that without me having to manually do it. ???
dtryon9981 wrote:
......where do I do that at? I am not seeing that under Table or Format.
Select the row(s) and follow the red arrow in the screenshot in my post above...
SG
"Clicking Fit will restore the default behavior."......where do I do that at? I am not seeing that under Table or Format.
Numbers 12.2.1
Expanding Cells