| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I delete multiple blank rows collectively?
I have imported a report to excel which contains alot of blank rows, almost
every other row. I want to delete the blank rows so I can use the auto filter function but don't want to select each line individually. Is there a quick way? Sorry, don't know which version of Excel - how do I find out? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I delete multiple blank rows collectively?
Autofilter on blanks, then delete all the visible rows.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "bursar" wrote in message ... I have imported a report to excel which contains alot of blank rows, almost every other row. I want to delete the blank rows so I can use the auto filter function but don't want to select each line individually. Is there a quick way? Sorry, don't know which version of Excel - how do I find out? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
| Besides manually how can I delete words in multiple rows? | Excel Discussion (Misc queries) | |||
| select and delete all blank rows | Excel Discussion (Misc queries) | |||
| I want to delete multiple blank rows from a spreadsheet | New Users to Excel | |||
| Pivot Tables & not printing blank rows (revisited) | Excel Worksheet Functions | |||
Linear Mode
