You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hello.
In Excel, when I set a row to "Wrap Text", whenever I type and the content goes longer than the cell size, it will wrap itself and auto expand the cell's height. But in Numbers, it appears that I have to double click the row to make it expand.
Please advise, thank you.
In my copy of Numbers, Wrap text is the default setting.
If yours is set by default to not wrap text, you can easily change that setting for one or more cells.
Select the cell(s),
Click the format brush to open the Format Inspector
Choose the Text section.
Check the checkbox indicated by the arrow to Check (to wrap) or Uncheck (to not wrap) text in the selected cells.
Full view of the table shown above:
Text in cells C3, B4 and A5 was entered directly from the keyboard.
Text in C3 was copied, then pasted into cell B5.
Body cells in rows 4 and 5 were set to NOT wrap text in the cell, letting it flow into the empty cells to its right.
Cell C3 was set to Wrap text in the cell, making the cell (and the rest of the row) expand vertically to accept the extra text.
Regards,
Barry
In my copy of Numbers, Wrap text is the default setting.
If yours is set by default to not wrap text, you can easily change that setting for one or more cells.
Select the cell(s),
Click the format brush to open the Format Inspector
Choose the Text section.
Check the checkbox indicated by the arrow to Check (to wrap) or Uncheck (to not wrap) text in the selected cells.
Full view of the table shown above:
Text in cells C3, B4 and A5 was entered directly from the keyboard.
Text in C3 was copied, then pasted into cell B5.
Body cells in rows 4 and 5 were set to NOT wrap text in the cell, letting it flow into the empty cells to its right.
Cell C3 was set to Wrap text in the cell, making the cell (and the rest of the row) expand vertically to accept the extra text.
Regards,
Barry
syakir_zainol wrote:
In Excel, when I set a row to "Wrap Text", whenever I type and the content goes longer than the cell size, it will wrap itself and auto expand the cell's height. But in Numbers, it appears that I have to double click the row to make it expand.
Have you selected the cell(s) and made sure 'Wrap text in cell' is checked?
If 'Wrap text in cell' is checked then the row height will expand automatically as you add more text. There should be no need to double-click.
SG
Thanks. I've discovered that for table that was originally in XLS format, it didnt do this by default but new table in Numbers, yes.
Expand Cell's Height
