Thread: select rows to print where there's data in specific column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default select rows to print where there's data in specific column
Hi,

Will selecting the electrician's column, then going
Data|Filter|AutoFilter then click the Autofilter's Down arrow and
selecting NonBlanks do what you want.

Also, before you print, select the electrician's cells, then go
File|Print Area|Set Print Area, then only those cells will print.

Ken Johnson

Reply With QuoteReply With Quote