Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 22nd 05, 07:53 PM
Leo
 
Posts: n/a
Default Autofit for row height is not working. Why?

I am using Excel 2002 run on a Windows XP machine. In a cell I have typed a
bunch of text. I selected "wrap text" in the format of the cell. It is also a
merged cell with severl cells to the right. On one tab of the workbook, when
I double click on the row seperation line to the left it will automatically
change the hieght of the row to fit the content, keeping the column width
fixed. On the second tab in the work book when I do this or select "autofit"
from the format/row menu, the row will shrink to the height of one line of
text and nothing more. Is there some setting that is causing this? I have a
large number of rows and have to manually adjust them one at a time instead
of being able to double click and autofit them.

  #2   Report Post  
Old January 22nd 05, 08:31 PM
Gord Dibben
 
Posts: n/a
Default

Leo

Merged cells will allow "wrap text" from FormatCellsAlignment but..........

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

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.


Gord Dibben Excel MVP

On Sat, 22 Jan 2005 11:53:05 -0800, Leo wrote:

I am using Excel 2002 run on a Windows XP machine. In a cell I have typed a
bunch of text. I selected "wrap text" in the format of the cell. It is also a
merged cell with severl cells to the right. On one tab of the workbook, when
I double click on the row seperation line to the left it will automatically
change the hieght of the row to fit the content, keeping the column width
fixed. On the second tab in the work book when I do this or select "autofit"
from the format/row menu, the row will shrink to the height of one line of
text and nothing more. Is there some setting that is causing this? I have a
large number of rows and have to manually adjust them one at a time instead
of being able to double click and autofit them.


  #3   Report Post  
Old January 27th 06, 10:48 AM posted to microsoft.public.excel.misc
richarmk
 
Posts: n/a
Default Autofit for row height is not working. Why?

i find that even if the cells are not merged, but they are wrapped, sometimes
with an autofit to the row height, it almost works.It looks ok in "normal"
view, but on printing, the bottom of the text in the cell gets chopped off.
Particularly this happens with verdana text.

Should this happen?

"Gord Dibben" wrote:

Leo

Merged cells will allow "wrap text" from FormatCellsAlignment but..........

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

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.


Gord Dibben Excel MVP

On Sat, 22 Jan 2005 11:53:05 -0800, Leo wrote:

I am using Excel 2002 run on a Windows XP machine. In a cell I have typed a
bunch of text. I selected "wrap text" in the format of the cell. It is also a
merged cell with severl cells to the right. On one tab of the workbook, when
I double click on the row seperation line to the left it will automatically
change the hieght of the row to fit the content, keeping the column width
fixed. On the second tab in the work book when I do this or select "autofit"
from the format/row menu, the row will shrink to the height of one line of
text and nothing more. Is there some setting that is causing this? I have a
large number of rows and have to manually adjust them one at a time instead
of being able to double click and autofit them.



  #4   Report Post  
Old July 28th 08, 06:43 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 1
Default Autofit for row height is not working. Why?

So does anyone have a fix for printing a document that has NO merged cells,
but there is wrapped text in the cells, autofit makes it look ok until you
print it. This is a major issue in my book since I would have to adjust over
5000 rows by hand if there is no other way of doing this...
Has anyone written a macro that inserts an Alt+Enter at the end of the text
in cells?

I hope Microsoft is working on fixing this. In my book this makes the
program unusable. And this should be fixed as it's a basic function of a
program to print out the way it actually looks in the program...?

"richarmk" wrote:

i find that even if the cells are not merged, but they are wrapped, sometimes
with an autofit to the row height, it almost works.It looks ok in "normal"
view, but on printing, the bottom of the text in the cell gets chopped off.
Particularly this happens with verdana text.

Should this happen?

"Gord Dibben" wrote:

Leo

Merged cells will allow "wrap text" from FormatCellsAlignment but..........

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

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.


Gord Dibben Excel MVP

On Sat, 22 Jan 2005 11:53:05 -0800, Leo wrote:

I am using Excel 2002 run on a Windows XP machine. In a cell I have typed a
bunch of text. I selected "wrap text" in the format of the cell. It is also a
merged cell with severl cells to the right. On one tab of the workbook, when
I double click on the row seperation line to the left it will automatically
change the hieght of the row to fit the content, keeping the column width
fixed. On the second tab in the work book when I do this or select "autofit"
from the format/row menu, the row will shrink to the height of one line of
text and nothing more. Is there some setting that is causing this? I have a
large number of rows and have to manually adjust them one at a time instead
of being able to double click and autofit them.





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
Row Autofit Problem Peter Graff Excel Discussion (Misc queries) 3 January 18th 05 10:10 PM
Automatic Autofit oranskeer Excel Discussion (Misc queries) 6 January 6th 05 01:33 PM
Change height of row Pam MacT Excel Discussion (Misc queries) 2 January 5th 05 01:54 AM
How do I change row height to 16.0? I get choice of 15.6 (26 Pix. jlloyd Excel Discussion (Misc queries) 4 December 9th 04 04:47 PM


All times are GMT +1. The time now is 05:13 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017