Keeping column titles for each printed page

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


"John Bordieri" <[email protected]> wrote in message
news:WTyEe.176054$sy6.170675@lakeread04...
> 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
>

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.
--
Earl Kiosterud
www.smokeylake.com

"KL" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
>
> "John Bordieri" <[email protected]> wrote in message
> news:WTyEe.176054$sy6.170675@lakeread04...
>> 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
>>
>
>