Single space? - help

[Adam]

Sorry if this is dumb - I am new to this.

I have a large spreadsheet
About 10,000 rows x 20 columns.

Problem is it is every other row is blank.

How do I get rid of (re-format?) the spreadsheet to get
rid of the empty rows?

Example - all even rows are populated, all odd are
absolutely blank.
Now when I write formulas and apply to the whole
spreadsheet - I get zeros and errors in the empty rows!
(Not to mention, when it comes time to print it'll take
twice as much paper)

Thanking all the smart ones ahead of time ;-)

 

[Ken Wright]

Select the entire range of data in one of the columns that has data in every other row. Do Edit /
Go To / Special / Blanks, then hit Edit / Delete Entire Row.

 

[Bob Kilmer]

programmatically
(assumes column A represents the blank rows)

Workbooks("Book1.xls").Worksheets("Sheet1"). _
Columns(1).SpecialCells(xlBlanks). _
EntireRow.Delete xlShiftUp

 

[Adam]

Ohh!

Works! many thanks

Adam

-----Original Message-----
programmatically
(assumes column A represents the blank rows)

Workbooks("Book1.xls").Worksheets("Sheet1"). _
Columns(1).SpecialCells(xlBlanks). _
EntireRow.Delete xlShiftUp

--
Bob Kilmer




.