How to delete Blank lines in excel workbook?
 

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

How to delete Blank lines in excel workbook?
 

You can find some techniques at Debra Dalgleish's site for resetting the last
used cell:
http://www.contextures.com/xlfaqApp.html#Unused

Hemant wrote:

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

--

Dave Peterson

How to delete Blank lines in excel workbook?
 

Easy to do when you place your cursor on the row NUMBER on the far leftHold
the shift keyctrl+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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Hemant" wrote in message
...
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