F5SpecialBlanksOK

EditDeleteEntire Row


Gord Dibben MS Excel MVP

On Fri, 31 Jul 2009 16:18:01 -0700, RobinMerrill
wrote:

Hi. I export a report from Crystal that when I open in Excel has tiny blank
rows between each populated row. One field is for data entry, and I have to
use "autoformat row to fit" in order to display all the wrapped text lines.
This causes all rows to display full height, and undesireable "double spaced"
effect in the worksheet.

How can I either automatically eliminate the blank rows or cause the word
wrap to work in another way?