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

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

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

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

"pwalk" wrote:

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

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

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

"Jim May" wrote:

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

"pwalk" wrote:

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