How do I delete rows where cells are empty
Select entire column A
hit F5 Special
Mark Empty cells - hit OK
Right click on one selection and select Delete
Entire Row - hit OK
"Stan" skrev:
Office 2007, Complete dunce
I have a large 3 col Excel spreadsheet where certain cells in col A are
empty.
How do I delete every row where the cell in Col A is empty?
Should the answer require code or a macro to be entered, please tell me FULL
details of EVERY keystroke in the answer.
|