Double-click on row-separator doesn't always correctly adjust rowheight

P

Peter Reaper

Our company often uses Excel v.2003 to generate table-like text reports.
The cells often contain text that wraps to multiple lines. We also have
merged cells at various locations.

I often will double-click on the border between two row headers to make
the row above auto-expand/collapse to make the row fit to the amount of
wrapped text. However, there seem to be many situations where the row
will collapse to only one row in height. It might have to do with merged
cells (either in the row itself or somewhere else in the document). This
seems to be a bug.

Could you please tell me which specific criteria trigger this limitation
so I can avoid them?

Thank you!

PS. Here's a sketch of what I mean:

|-------------
|1|
|-------------
|2| Lots of text here that flows to 2+ lines.
|------------- <--- double-click here to expand row #2
|3|
|-------------
--
Regards,

Peter Reaper

The browser you can trust: www.GetFirefox.com
Reclaim Your Inbox: www.GetThunderbird.com

Israel - Myths & Facts: http://www.JewishVirtualLibrary.org/
Dangers of Islam (German): http://www.pi-news.net/
Church of the Flying Spaghetti Monster: http://www.venganza.org/
 

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

Top