ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Row Height - Auto-Fit (https://www.excelbanter.com/excel-discussion-misc-queries/202072-row-height-auto-fit.html)

Bajillian

Row Height - Auto-Fit
 
I have a spreadsheet with multiple rows that are larger than 255.00. None of
the cells are merged and all have wrao-text (although I have tried removing
the wrap-text with no different results). When auto-fit the rows, none will
auto-fit larger than 255.00, even though the limit is 409.00.

When I re-size the row by hand to be the righ size and then use auto-fit, it
shrinks the row-height back to 255.00.

Any suggestions?

Thanks!

Jim Rech

Row Height - Auto-Fit
 
In my experiments I find that the exact row height I get when auto-fitting a
row depends on the column width. But regardless of the column width I too do
not get all of a long text entry even though the maximum row height has not
been reached. Seems like a problem with Excel and you may have to go with a
manual adjustment..

--
Jim
"Bajillian" wrote in message
...
|I have a spreadsheet with multiple rows that are larger than 255.00. None
of
| the cells are merged and all have wrao-text (although I have tried
removing
| the wrap-text with no different results). When auto-fit the rows, none
will
| auto-fit larger than 255.00, even though the limit is 409.00.
|
| When I re-size the row by hand to be the righ size and then use auto-fit,
it
| shrinks the row-height back to 255.00.
|
| Any suggestions?
|
| Thanks!



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

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