Printing only rows with value in certain column

  • Thread starter Thread starter willmain
  • Start date Start date
W

willmain

Does anyone know a way that I can print only rows that have a value in a
certain column? I have a large spreadsheet that I print often and would
like to be able to print only the rows with a value in column M.
 
I can't get this to work. Any other ideas? I simply want the rows wit
an empty cell in column M to not print
 
Apply data|filter|autofilter to that column (or the whole range).

Then use the dropdown to show only the non-blanks.

Print, then Data|filter|showalldata.
 
Back
Top