i have a spreadsheet in excel that has about 1500 rows and about 8 columns. One of the columns is headed by 'orderable.' Every cell in this column has either a value '1' or nothing at all. I would like to select each row that has no value and delete the entire rows. There are blank values elsewhere, if that makes a difference.
Select the 'orderable' column. Type ƒ5 (or select Go To…). Choose Special…. Select 'Blanks'. At this point, all blank cells in your original selection should selected.
Right-click on one of the selected cells and click Delete. The resulting dialogue should offer 'Entire Row'. Select it and click OK. All the rows that are part of your selection will be deleted.
Note that if your range were smaller, you could just use CTRL-click to select a cell in each row that you want to delete.
Old thread I know, but I think the original question is about deleting entire rows when on column in the row is blank and doing this "en-mass".
For Excel 2011:
Select an entire column (or row),
Under the "Edit" menu, select "Go To"
Select "special" in the dialog that pops up
Choose the "Blanks" radio button and click "Ok"
Now go back to the "Edit" menu and choose "Delete"
In the dialog box you should have the option for "Entire row"