How Can I Add a Title That always stays on top?

[Kenji]

I have a sheet that scrolls up and down.. but I want to keep the title
showing on the top. I tried splitting the sheet, but it seems to duplicate
the title twice. Thanks

Kenji

 

[Bob Umlas]

Use Window/Freeze Panes -- first select a row below the title.

 

[Guest]

Use Window/Freeze Panes.

 

[Stephanie]

Highlight the row under the title, go to Window and then
freeze pain. It should keep your title line at the top
while allowing the rest to scroll. You shouldn't get the
duplicate title this way.

 

[Robert Christie]

Hi Kenji
Just adding to what others have stated.
if your titles are in row 1 and say a list of names are
in column A selecting cell B2 and Windows / freeze panes
will keep the names in view while you scroll horizontally
and your titles as well.

HTH
Bob C