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)

Posted on Mar 13, 2023 9:40 AM

Reply
Question marked as Top-ranking reply

Posted on Mar 27, 2023 8:24 AM

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


7 replies
Question marked as Top-ranking reply

Mar 27, 2023 8:24 AM in response to dtryon9981

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


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.

Expanding Cells

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