ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   autofit height of row - ajit (https://www.excelbanter.com/excel-discussion-misc-queries/29901-autofit-height-row-ajit.html)

Ajit Munj

autofit height of row - ajit
 
Some time when I double click the divider of two rows (faint line between
two rows where cursor changes double headed) to autofit the height of row,
it does not change automatically the height of that row containing a
particular text. I have to manually drag it to adjust the height the row
containing text. Why it is like this?

--
Knowldege is Power

Dave Peterson

Do the offending rows contain merged cells?

Autofit doesn't play nicely with merged cells.

Ajit Munj wrote:

Some time when I double click the divider of two rows (faint line between
two rows where cursor changes double headed) to autofit the height of row,
it does not change automatically the height of that row containing a
particular text. I have to manually drag it to adjust the height the row
containing text. Why it is like this?

--
Knowldege is Power


--

Dave Peterson


All times are GMT +1. The time now is 10:03 PM.

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