Printing only rows with value in certain column

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.
 
W

willmain

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing only Rows with a value in a specific column 2
Want to print only rows that have value in certain columns- Excel 2
suppress printing on certain rows 7
Variable print area via a macro 9
Show only rows with duplicate values in a column? 4
Printing only certain rows 1
Using Macro to Hide Rows with Certain Values 2
How do I print with hidden rows without gaps? 1

Top