ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   cell size (https://www.excelbanter.com/excel-worksheet-functions/187434-cell-size.html)

robzrob

cell size
 
If I've got a cell where text is to be entered but I don't know how
much, can I set the cell's height (or width) to increase according to
the amount of text typed into it?

Teethless mama

cell size
 
It depends how you want it. Either wider column or wider row, or both

Format cells select Wrap text OK out


"robzrob" wrote:

If I've got a cell where text is to be entered but I don't know how
much, can I set the cell's height (or width) to increase according to
the amount of text typed into it?


robzrob

cell size
 
On May 14, 6:23*pm, Teethless mama
wrote:
It depends how you want it. Either wider column or wider row, or both

Format cells select Wrap text OK out



"robzrob" wrote:
If I've got a cell *where text is to be entered but I don't know how
much, can I set the cell's height (or width) to increase according to
the amount of text typed into it?- Hide quoted text -


- Show quoted text -


Thanks, but that just makes the text smaller, not the cell bigger :(

Gord Dibben

cell size
 
FormatCellsAlignmentWrap Text.

FormatRow or Column and "Autofit"


Gord Dibben MS Excel MVP

On Wed, 14 May 2008 13:37:39 -0700 (PDT), robzrob wrote:

On May 14, 6:23*pm, Teethless mama
wrote:
It depends how you want it. Either wider column or wider row, or both

Format cells select Wrap text OK out



"robzrob" wrote:
If I've got a cell *where text is to be entered but I don't know how
much, can I set the cell's height (or width) to increase according to
the amount of text typed into it?- Hide quoted text -


- Show quoted text -


Thanks, but that just makes the text smaller, not the cell bigger :(



robzrob

cell size
 
On May 14, 10:22*pm, Gord Dibben <gorddibbATshawDOTca wrote:
FormatCellsAlignmentWrap Text.

FormatRow or Column and "Autofit"

Gord Dibben *MS Excel MVP



On Wed, 14 May 2008 13:37:39 -0700 wrote:
On May 14, 6:23*pm, Teethless mama
wrote:
It depends how you want it. Either wider column or wider row, or both


Format cells select Wrap text OK out


"robzrob" wrote:
If I've got a cell *where text is to be entered but I don't know how
much, can I set the cell's height (or width) to increase according to
the amount of text typed into it?- Hide quoted text -


- Show quoted text -


Thanks, but that just makes the text smaller, not the cell bigger *:(- Hide quoted text -


- Show quoted text -


Thank you.


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com