Re: Format/Row/Autofit

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

anonymous_at_discussions.microsoft.com
Date: 07/02/04 

Date: Fri, 2 Jul 2004 09:40:40 -0700

Thank you for your response. The cells are not merged and
I have not manually resized them, wrap text is enabled.
After realizing none of this worked I did have to go in
and resize them manually, but I really appreciate the code
and link reference, I'll check them out. Thanks again.
>-----Original Message-----
>Are any of the cells "merged"?
>
>Row Autofit doesn't work properly with merged cells.
>
>Excel has a problem auto-fitting merged cells.
>
>You can resize manually or via Macro. Jim Rech has
written
>code for this.
>
>http://groups.google.com/groups?threadm=e1%
241uzL1BHA.1784%40tkmsftngp05
>
>Note also a recent adaptation of this code by Greg Wilson.
>
>http://makeashorterlink.com/?P37D24B15
>
>If not merged, did you recently manually re-size the row
(s)?
>
>This can screw up Autofit. Select all rows and
Format>Rows>Autofit again.
>
>Is wrap-text enabled?
>
>Gord Dibben Excel MVP
>
>On Wed, 30 Jun 2004 16:47:00 -0700,
<anonymous@discussions.microsoft.com>
>wrote:
>
>>So sorry, I meant taller, thank you
>>
>>
>>>-----Original Message-----
>>>Wider/skinnier refers to Column.
>>>
>>>Taller/shorter refers to Row.
>>>
>>>Try Format>Column>Autofit.
>>>
>>>Gord Dibben Excel MVP
>>>
>>>On Tue, 29 Jun 2004 16:20:43 -0700,
>><anonymous@discussions.microsoft.com>
>>>wrote:
>>>
>>>>Can someone please tell me why my text will not fit in
>>>>Autofit row. It just needs to be a little bit wider.
>>It
>>>>never used to do this, is it because I'm now using
>>Windows
>>>>XP with Excel 2000?
>>>
>>>.
>>>
>
>.
>

Relevant Pages

  • Re: Column resizing problems in table -- help??
    ... > In the default template I created, the cells are just wide enough for the ... > If I manually resize the column to fit the text, ...
    (microsoft.public.word.pagelayout)
  • Column resizing problems in table -- help??
    ... rows of cells contain identifying text for what's in that particular table. ... If I manually resize the column to fit the text, ...
    (microsoft.public.word.pagelayout)
  • Re: Range as cell numbers
    ... Set objRange = objExcel.range, .Cells(lngMaxRow, lngMaxColumn)) ... Anyway, to see that you can create a range using Resize, copy/paste and then run the following code... ... strRange = .Cells.Resizegives Type mismatch. ... I know I can change Rangeto Cells(14,1), but how do you specify a range of cells in this way? ...
    (microsoft.public.excel.programming)
  • Column resizing problems in table -- help???
    ... rows of cells contain identifying text for what's in that particular table. ... If I manually resize the column to fit the text, ...
    (microsoft.public.word.docmanagement)
  • Re: I am entering data but it appears as a date in excel
    ... Pre-format the cells as Text or type an apostrophe before 3MAR01 ... Gord Dibben Excel MVP ... >before a 3 letter code. ... >I have tried to change the cell format from general to number but it makes ...
    (microsoft.public.excel.worksheet.functions)