Want to print only rows that have value in certain columns- Excel

G

Guest

How can I print a report from excel spreadsheet that only prints rows of
information that have a value (non 0) in the first column? In other words,
if column A has no value entered for certain rows, those rows (column A thru
whatever) are left out when the report is printed.
TIA
 
G

Guest

Without Code you could apply the Data, AutoFilter to your Range and then
On the Drop-down of Col A - Select Non-Blanks (at the bottom) - this will
filter out the Blanks in Col A.
Jim
 
G

Guest

thanks Jim, that does work. Was hoping I could find a solution that would
filter out the rows with blank column A's as it printed, but your suggestion
will satisfy my needs. Thanks again!
Pat
 

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

wrap columns to print in rows 1
Print macro that hides rows before printing 1
Printing only rows with value in certain column 4
Export and Save Only Certain Rows of Data 1
Variable print area via a macro 9
Expand and Shrink Rows and columns to hide information. 1
Printing only Rows with a value in a specific column 2
Show only rows with duplicate values in a column? 4

Top