#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 159
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 159
Default 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 :(
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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 :(


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 159
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I change the size of a cell and hide what is in the cell? Elisabeth Excel Worksheet Functions 7 January 3rd 08 07:43 PM
cell size and font size Aamir Excel Discussion (Misc queries) 1 October 10th 06 05:51 PM
Cell size Alex C Excel Discussion (Misc queries) 0 May 24th 06 08:52 PM
Cell size? Or size limit for Text data type? CClem Excel Discussion (Misc queries) 0 April 21st 06 04:09 PM
Keep cell size Mark Olsen Excel Discussion (Misc queries) 2 March 23rd 06 03:07 PM


All times are GMT +1. The time now is 06:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"