basic excel question

Greetings, How can i remove blank rows from a worksheet? I have a worksheet with 7000 rows of data and the worksheet contains 2000 blank rows making a total of 9000 rows. I would like to elminiate these 2000 blank rows at the end of the work sheet. Thanks, any help appricated

Greetings, How can i remove blank rows from a worksheet? I have a worksheet with 7000 rows of data and the worksheet contains 2000 blank rows making a total of 9000 rows. I would like to elminiate these 2000 blank rows at the end of the work sheet. Thanks, any help appricated

Try:
You can click on one or more column letters or one or more row numbers in the frame area, and click on Edit on the menu bar. Select the option of Delete and the highlighted column or row would be deleted. These columns or rows can be empty or contain information.

If all the rows containing data have data in a certain Column you could write a quick little macro to erase all rows that do not contain data in that cell

For i = Worksheets(1).UsedRange.End(xlDown).Row To 1 Step -1
'Is the cell at (row i, column 1) empty
If Cells(i, 1).Value = "" Then
Cells(i, 1).Delete
End If
Next

thanks alot man, that seemed to do the trick!

Here's a method that checks to make sure the entire row is empty:

http://www.j-walk.com/ss/excel/tips/tip56.htm