| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
one way
highlight the range press F5click special...click the radio button "Blanks"OK Now press ctrl+- and delete rows "JP6262AMY" wrote: 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! |
|
#3
|
|||
|
|||
|
Thanks, Ray! That will really save me a lot of work!!
"Ray A" wrote: one way highlight the range press F5click special...click the radio button "Blanks"OK Now press ctrl+- and delete rows "JP6262AMY" wrote: 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! |
|
#4
|
|||
|
|||
|
Ray,
What a GREAT Way of Deleting Blank Rows, I will Certainly be Using that in Future. Thanks. All the Best. Paul Ray A wrote: one way highlight the range press F5click special...click the radio button "Blanks"OK Now press ctrl+- and delete rows "JP6262AMY" wrote: 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! |
|
#5
|
|||
|
|||
|
Another option...
Select your data and sort it by a column that always has data--except for the rows that are blank. JP6262AMY wrote: 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! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to stop excel from plotting a "blank" cell with formula as zer | Excel Discussion (Misc queries) | |||
| Isolate rows based on highlight (Excel 2003) | Excel Worksheet Functions | |||
| HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) | |||
| How do I remove blank rows in Excel? | Excel Discussion (Misc queries) | |||
| No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
