If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format/Row/Autofit
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? |
#2
|
|||
|
|||
Format/Row/Autofit
Wider/skinnier refers to Column.
Taller/shorter refers to Row. Try FormatColumnAutofit. Gord Dibben Excel MVP On Tue, 29 Jun 2004 16:20:43 -0700, 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? |
#3
|
|||
|
|||
Format/Row/Autofit
So sorry, I meant taller, thank you
-----Original Message----- Wider/skinnier refers to Column. Taller/shorter refers to Row. Try FormatColumnAutofit. Gord Dibben Excel MVP On Tue, 29 Jun 2004 16:20:43 -0700, 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? . |
#4
|
|||
|
|||
Format/Row/Autofit
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?thre...%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 FormatRowsAutofit again. Is wrap-text enabled? Gord Dibben Excel MVP On Wed, 30 Jun 2004 16:47:00 -0700, wrote: So sorry, I meant taller, thank you -----Original Message----- Wider/skinnier refers to Column. Taller/shorter refers to Row. Try FormatColumnAutofit. Gord Dibben Excel MVP On Tue, 29 Jun 2004 16:20:43 -0700, 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? . |
#5
|
|||
|
|||
Format/Row/Autofit
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 FormatRowsAutofit again. Is wrap-text enabled? Gord Dibben Excel MVP On Wed, 30 Jun 2004 16:47:00 -0700, wrote: So sorry, I meant taller, thank you -----Original Message----- Wider/skinnier refers to Column. Taller/shorter refers to Row. Try FormatColumnAutofit. Gord Dibben Excel MVP On Tue, 29 Jun 2004 16:20:43 -0700, 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? . . |
Thread Tools | |
Display Modes | |
|
|