LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to delete rows which is blank and which has ======== ( lines) Meeru Excel Discussion (Misc queries) 3 September 7th 09 09:46 AM
Delete Blank Lines Templar Excel Discussion (Misc queries) 2 December 27th 08 05:08 PM
Delete Blank Lines Saxman Excel Discussion (Misc queries) 3 January 9th 07 01:46 AM
How do i delete blank lines at bottom of an Excel worksheet? JoeOvercoat Excel Discussion (Misc queries) 2 September 2nd 06 11:54 PM
Delete Blank Lines Charles Excel Discussion (Misc queries) 3 August 8th 05 05:11 PM


All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"