keeping worksheet title visible during scrolling

N

New at excel

I am Office 2000, and is finding it hard to find the right comands to have
the title of my worksheet remain visible while I scroll to the bottom of the
page.
 
S

Steve

1) Click in column A below your title row
2) Click Window, Freeze panes

If you need row headings as well, click the first cell below your column
titles and to the right of your row titles.

HTH
Steve
 
G

Gord Dibben

New

Select A2 and Window>Freeze Panes to freeze the top row.

Rule is.........

Everything to the left and above the selected cell will be frozen.

i.e. B2 and Freeze Panes will freeze row 1 and Column A.


Gord Dibben Excel MVP

On Tue, 15 Feb 2005 16:41:03 -0800, New at excel <New at
 
Top