View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
excelent excelent is offline
external usenet poster
 
Posts: 695
Default 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.