gang remove blank rows
Hi,
You can do this just using the first column.
Select all of your first column,
Tap F5
Click on Special
Check Blanks
Click OK
Then right click on the selected Blanks
Click Delete
And check Entire rows
HTH
Martin
"swell estimator" wrote:
I have a large amount of data that is composed of a text row followed by 2
blank rows. This pattern repeats itself in the entire worksheet.
I want to gang remove the blank rows so that I end up with single spaced data.
Any help out there. Thank you.
|