I have a couple of Numbers spreadsheets and on one when I click on a cell to enter data it expands to two lines deep. I've obviously inadvertently changes some setting but I don't know how to reverse it.
It only happens on one of my Numbers spreadsheets and the problem persists across all my I Cloud linked devices. Can somebody point me in the right direction to fix it?
M,
If you ever manually increased the size of the until you execute Format > Table > Row and Column Size > Fit, or manually reduce the height. Or, possibly your text is close enough to filling the cell that it thinks it's time to "Wrap".
If you don't want text to wrap and increase the row height, unselect "Wrap text in Cell" Format > Text menu.
Jerry
M,
If you ever manually increased the size of the until you execute Format > Table > Row and Column Size > Fit, or manually reduce the height. Or, possibly your text is close enough to filling the cell that it thinks it's time to "Wrap".
If you don't want text to wrap and increase the row height, unselect "Wrap text in Cell" Format > Text menu.
Jerry
MVTVL wrote:
it expands to two lines deep.
You can control that behavior by selecting the cell(s) and changing this checkbox:
SG
First screenshot is cell selected. Second is after clicking again to enter text. Is this what you are asking about? If so, the problem is the cell is too small in height to fit the text at the chosen font size. If you don't want to increase the cell height you can pre-format the cell(s) so that the font is smaller and will fit in the cell. Alternatively, you can enter some text in this cell then adjust/set the row height to fit the text.
Sorry, doesn't work.
Highlighting the cell shows normal depth but as soon as I click on the cell to enter data it expands to double depth
Jerry this happens before I've even entered any text in the cell. I only have to click on the cell ready to enter data and it automatically expands
MVTVL wrote:
as soon as I click on the cell to enter data it expands to double depth
And that's a problem? Why?
SG
Because it bugs me!
And it hides any data in the cell below
In my Numbers spreadsheet if I click on a cell to enter data it automatically expand to two lines deep.
