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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top