View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Heather Heather is offline
external usenet poster
 
Posts: 148
Default Delete Blank Rows

Hi, I need to find a way to delete wholly blank rows from a spreadsheet that
also includes blank cells.
I tried F5special...radio button BlanksOK ctrl+- delete rows , but that
also deletes rows that have data in them along with a blank cell!

Is there an equally neat way of deleting rows that have no data in them at
all, but leaving partial rows?