LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JP6262AMY
 
Posts: n/a
Default How do I remove numerous blank rows from Excel spreadsheet?

Data is imported from an external source and contains numerous blank rows
within the data. How can I remove the blank rows without having to select
each one? There are sometimes hundreds of them. Thanks!
 
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 stop excel from plotting a "blank" cell with formula as zer tiw Excel Discussion (Misc queries) 5 April 21st 05 08:38 PM
Isolate rows based on highlight (Excel 2003) Alcide Excel Worksheet Functions 2 April 21st 05 05:40 PM
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? Phil A. Excel Discussion (Misc queries) 1 April 19th 05 04:10 PM
How do I remove blank rows in Excel? m28leics Excel Discussion (Misc queries) 2 November 29th 04 11:56 PM
No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 Ian Ripsher Excel Discussion (Misc queries) 0 November 26th 04 08:43 PM


All times are GMT +1. The time now is 10:05 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"