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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
 
Back
Top