Excel - Cell Auto Expand

[jrobin5881]

I have the word wrap set in a cell so that when I type it'll move to the next line so that I can get several lines of text in the cell. My question is what do I do to set the cell to automatically increase in height so that all of the input(alpha) can be easily seen and read in the cell?

 

[PeterMoran]

Hi,

Try selecting the sheet (Ctrl+A) and then Format, Row, Autofit. This should make each row expand to the max height needed for the row.

Good Luck!

Peter Moran

 

[jrobin5881]

Peter,
My apologies- I should've been more explicit in explaining what I'm trying to accomplish. I'm aware of how to adjust the row height by either right clicking on the row heading or doing as you suggest above. What I'm after is along the lines of a feedback type form whereby the respondents type information into a cell. What I would like to happen is to have that cell expand by itself as the user types in the info without any intervention. I'm trying to avoid using VBA and all of that because it's rather simple data I'm after.

 

[xlbo]

That is what should happen by default - is the cell merged? if not, what formatting has been applied to it?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[jrobin5881]

Yes, cells A1 - E1, F1 - R1, are merged etc.
The cell scrolls as the user types so that they can see what they're typing but then when you move to another cell you cannot fully see the contents without adjusting the cell height.

 

[PeterMoran]

Hi,

as Geoff and I know (and many others) merged cells are a nuisance in Excel. If you can, try removing the merged cells property via Format Cells Alignment, and then on the same Format Cells window, under Horizontal select the bottom entry "Centre across Selection". This gives most of the benefits of merged cells without the problems.

Good Luck!

Peter Moran

 

[xlbo]

....one of which is that the "AutoFit" option doesn't work on merged cells.....

Second Peter's suggestion for getting around this....only other options are a textbox with Multiline property set to true embedded in the sheet - this would then require VBA etc though

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[jrobin5881]

Thanks all- I think I'm crying uncle and going the VBA route. That way I can be assured of the end product.