| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eliminating blank rows
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Eliminating blank rows | Excel Worksheet Functions | |||
| Eliminating Blank rows | Excel Worksheet Functions | |||
| Excel 2003-eliminating blank rows in target worksheet | Excel Discussion (Misc queries) | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| Eliminating Blank Rows | Excel Discussion (Misc queries) | |||
Linear Mode
