ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Does the latest Excel STILL fail to auto-resize merged cells? (https://www.excelbanter.com/new-users-excel/179355-does-latest-excel-still-fail-auto-resize-merged-cells.html)

[email protected]

Does the latest Excel STILL fail to auto-resize merged cells?
 
Whereas:

- Excel can (wonderfully) auto-resize a cell whose contents are wider
than its width.
- But auto-resize doesn't work on a cell that is merged with another.
- At the risk of being obvious, a feature is a feature only if it
works.

And Excel's auto-resize doesn't work.

That is, unless Microflot has fixed this bug since my version?

***

Bob Umlas[_2_]

Does the latest Excel STILL fail to auto-resize merged cells?
 
Same situation in Excel 2007, but in both versions there's a workaround. If
the merged cells are A1:D1, for example, use a remote cell, say Z1, which is
as WIDE as columns A:D, and contains =A1. Both are marked as wrap text. When
you double-click the row separator between rows 1 & 2, it actually uses Z1
to determine the height, and it looks like A1:D1 works!

wrote in message
...
Whereas:

- Excel can (wonderfully) auto-resize a cell whose contents are wider
than its width.
- But auto-resize doesn't work on a cell that is merged with another.
- At the risk of being obvious, a feature is a feature only if it
works.

And Excel's auto-resize doesn't work.

That is, unless Microflot has fixed this bug since my version?

***




All times are GMT +1. The time now is 04:27 PM.

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