How to delete about 86k blank rows

**Harrold** · 06-17-2014, 10:24 AM

Hi,

I have been trying to delete about 86k rows in my table in a worksheet. It has been over 5 hours now and it is still running to delete. any better solution? or how long do i need to wait for the system to finish its work?

Thanks

**newdoverman** · 06-17-2014, 10:30 AM

I have found that this tool from Microsoft is quite effective at removing excess formatting and resetting the last cell.

http://www.microsoft.com/en-ca/downl....aspx?id=21649

How to delete about 86k blank rows

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to delete about 86k blank rows

Re: How to delete about 86k blank rows

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Find last row and column that contain data and delete all blank rows and blank columns

[SOLVED] How to Delete Multiple Consecutive Blank Rows - Delete all Blank Rows

[SOLVED] Delete blank rows after filter - if no blank rows exit sub

Excel 2007 : Delete blank rows where data entire cell contents are blank

[SOLVED] To delete blank rows having blank cell in the needed raws

Bookmarks

Bookmarks

Posting Permissions