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 ;-)

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"Adam" wrote in message ...
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 ;-)

programmatically
(assumes column A represents the blank rows)

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

--
Bob Kilmer

"Adam" wrote in message
...
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 ;-)

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

"Adam" wrote in message
...
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 ;-)


.