| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete multiple rows where a blank cell is located
kippers wrote:
Hi, I have a spreadsheet with nearly 20,000 rows and around 20 columns- every so often a blank cell appears (it is always in the 2nd column) - I want to delete the entire row on which this blank cell is placed. This happens roughly every 10-15 rows so it would be far too time consuming to go through 20k rows manually- can anyone give me a quick and easy way of deleting these rows? Any help gratefully appreciated! cheers Could you auto filter the sheet then column two to show blanks and just delete all the visible data in the other columns? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
| To delete rows when more than one cell is blank | Excel Worksheet Functions | |||
| In Office 2000, How do I delete multiple blank rows at one time? | Excel Worksheet Functions | |||
| Can I delete multiple blank rows collectively? | Excel Worksheet Functions | |||
| I want to delete multiple blank rows from a spreadsheet | New Users to Excel | |||
Threaded Mode
