IT Employment

Ask something
Discussion Locked

How to remove blank Rows in Excel??

0 helpful
1 reply

by les

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anyone know of a way to automate the removal of many blank rows inside an Excel Sheet??
I have exported to Excel from Crystal Reports but I have three blank rows between every record. There must be a better way to remove all of these blank rows.
Any help would be greatly appreciated!!!

Thanks,

Les

1 reply

by kdogg

You should be able to do that in Crystal before you send it to Excel. In your 'Format' section, is the box 'Suppress Blank Section' checked?

If you don't have access within Crystal to change the format, you could write a macro in Excel that would delete the row where the condition you specify are not met. In your case, sounds like an If statement would work.

This discussion is closed to new replies.