Keeping column titles for each printed page

  • Thread starter Thread starter John Bordieri
  • Start date Start date
J

John Bordieri

Hi,

I had an inventory worksheet (until someone deleted it), when I print the
sheets, on each page the first row has the names of each column
ie.,
NAME DESCRIPTION COUNT
PRICE

While looking at the speadsheet on the computer I see the above titles (and
yes the panes are frozen), as I scroll down the sheet to a page break there
are no titles. They only appear on the top row of each new printed sheet.

If this makes sense could you please tell me how to set it up again. I've
been going crazy trying to figure it out.I want each printed sheet to have
the title of each column.

Thank you,
John
 
menu File>Page Setup, tab 'Sheet', box 'Rows to repeat at top:' write 1:1,
2:2, 1:2 or whatever are the rows to repeat.

KL
 
KL,

To add to your reply, you can, with the cursor in the rows to repeat box,
just click anywhere in the row of the sheet that's in the background. It's
called a RefEdit box. That's why that box is inactive (greyed out) if
there's a print preview image in the background instead of the worksheet.
 
Back
Top