Printing

[Joe_99_Nooks]

I'd like to print the top three rows of my spreadsheet at the top of every sheet that prints.  Is this possible and how can I do it.  Many thanks for any help.  Joe

[#2]

@Joe_99_Nooks 

On the Page Layout tab of the ribbon, in the Page Setup group, click Print Titles.

Click in the 'Rows to repeat at top' box, then point to rows 1 to 3, or type $1:$3 in the box.

Then click OK.

This is a worksheet setting, you have to set it for each sheet separately.

[#3]

@Hans Vogelaar 

Many thanks Hans and I'll give this a try.  Joe

[#4]

Hi Hans, the fix you explained works fine but what also prints are the column headings A,B,C etc and the row numbers. These I don't want. Can you help with this too? Many thanks. Joe

[#5]

@Joe_99_Nooks 

On the same tab of the ribbon, in the Sheet Options group, clear the check box Print under Headings.

[#6]

Thanks again Hans and like the first solution you gave me, this too worked perfectly.
Betst wishes
Joe