Not to print one row within a spreasheet

[Guest]

I created a spreadsheet for employees to use to report their time (for
payroll). I included formulae to calculate overtime. I wrote a note with
instructions on line 3. I don't want line 3 to print when the page is
printed. How do I restrict printing so that line 3 doesn't print?

 

[Ron de Bruin]

Hi HBaumann

With code you can do this
http://www.rondebruin.nl/print.htm#Hide

 

[Fable]

Why not hide the row and place the comments some else

 

[Guest]

Two options:

1) Hide the row (probably counter-productive to hide the instruction row!)

2) Move the row to row 1 and set your print area from row 2 down.
(you can still set row 2 as a "header" row to print on all pages, if
desired)

HTH

Bruce