View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CarSum
 
Posts: n/a
Default How do I delete a row in excel if it has no value?

I work a lot in spreadsheets that are linked together. Eg I enter data on
one sheet it is recalculated and placed on another spreadsheet that has
multiple rows of data on it. I then delete the lines that have no data from
previous sheet on it to print a neater form. Can I somehow get these rows
that have a zero valu in a certain column not show up when I print instead of
manually deleting them one by one.
Thank You for any help you may be able to give me.