How to delete Blank lines in excel workbook?

  • Thread starter Thread starter Hemant
  • Start date Start date
H

Hemant

If excel worksheet contains data up to 450 lines however due to some wrong
entry on Row 63000, it selects data up to 63000 lines. Now it contains no
data in Row 63000. If I try to delete Rows from 451 to 63000, it takes
substantial time or application hung up. Is there any solution that the excel
wiill select data up to last cell which contains data OR to delete blank
lines
 
Easy to do when you place your cursor on the row NUMBER on the far left>Hold
the shift key>ctrl+end down. Now you have all rows highlighted. Make sure
your cursor is still on the numbers and click the delete key. Here is a
recorded macro. Be sure to SAVE the workbook for the change to take.
Sub Macro3()
' Macro3 Macro
' Macro recorded 9/20/2009 by Donald B. Guillett
Rows("11:11").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Delete Shift:=xlUp
End Sub
 
Back
Top