| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete multiple rows where a blank cell is located
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 |
| 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
