View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gevew gevew is offline
external usenet poster
 
Posts: 8
Default Show zero values only when data is entered in other fields

I am currently working on a spreadsheet that contains min. information but
will expand over time. I have formatted a column for number and would like
the zero value to show only in fields where there is other information
showing (all the rest of the rows should show no zeros. I also found that
because I applied conditional formatting to one of the columns from row
2-2000, when I want to print the whole spreadsheet rows 1-2000 are selected
to print (pages 1-56) not just the page(s) with data on them. How do I get it
to auto select only the rows with data.