Scrolling cells under a heading?

[JER]

Someone passed along a sample check register file in Excel. At the top are
Column headings for date, check number, etc. When you scroll down, the
heading at the top, always stays visible The Rows underneath give the
appearance of disappearing under the header. In this way, as mentioned the,
header is always visible, allowing one to see the identity of each column no
matter how far you scroll down the ledger or page. How is such a header
created and what is it called? I would find this useful in creating other
worksheets. I am new to Excel, as you might surmise, but not computer
illiterate ... and eager to learn the program.

From Jerry Bohley (jerliz@home)

 

[AlfD]

Hi!

Put the headings at the top. Can be more than one row.
Put names or whatever at the left-hand side (again, 1 or mor
columns).

Select the cell which is one row below your chosen headings and on
column to the right of your chosen row headings.

On the main menu click Window > Freeze panes. Done.

eg if you want one row of headings and one column of fixed names
select B2: window>freeze panes.

Unfreeze panes removes it and lets you change it.

Al

 

[JER]

Alf, thanks with much appreciation.

Jerry

 

[dlw]

On the menu bar, Click on Window / Freeze Panes
it will "freeze" cells to the left and above where the
cursor is.