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

B

baobob

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?

***
 
B

Bob Umlas

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maintaining cell size after merge 3
Merging variable length data to a table 1
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
Wrapping multiline text in merged cells 1
Can Excel autosize merged cells yet? 1
Grouped Objects in MS-Excel 2007 1
Preserving cell validation on worksheets post data merging 1
Cells with wrapped text won't auto-adjust row height correctly 2

Top