MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Printing certain rows


Posted by Frank on January 15, 2002 3:44 PM

Can I set up a formula that will allow only certain rows to be printed? This will be a company order form, which is a total of 10 pages. The only items I want to print are the items that are selected. Is there a formula that can be placed in a cell that will print the complete row if a number is plugged into a corresponding cell. I hope this makes sense.

Frank



Posted by Qroozn on January 15, 2002 3:54 PM

you can set a printable print area....
but i think they all the rows have to be together!
i'm quickly doing some testing for you


Posted by Qroozn on January 15, 2002 3:56 PM

i was right.
you can select an area and then go file /printarea/setprint area

but if you have multiple selection s it prints one selection per page.