printing only certain lines in a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a super long worksheet on excel (50 pages) that is a price sheet for
labor and materials. It is fairly simple (6 columns including description,
quantitiy, price and notes). For each job that i use it for, I only use about
75 individual rows out of the total 50 pages. I would like to be able to only
print the rows that i am using for that individual job. In other words, I
only want the rows to print that have a number in the quantity column. How do
I create an if then statement that prints the row if a number is in the
quantity column and apply it to the whole spreadsheet?
Thanks VERY much in advance for your help!
Cassie
 
I think it would be easier to apply a filter to the quantity column,
but you might want to do this to the right of your existing data, eg
column H. If your quantity column is B, for example, and your first row
proper is 5, then enter into H5 the formula =B5, and then copy this
down to the bottom of your data.

Then highlight the column by clicking on the "H" at the top of the
column, then Data | Filter | Autofilter (check), and this will apply
the filter only to that column.

Then, when you are ready to print out, select Custom from the pull-down
on the filter and then choose Not Equal To and type 0 (zero) in the
other box. Only the rows with non-zero values in the quantity column
will show. When finished, select "All" from the filter pull-down.

Hope this helps.

Pete
 
Back
Top