Freezing Panes

[muerkilla]

Explain the term Frozen Panes

 

[bpeltzer]

If you freeze the pane, you can scroll right or down and keep the row/column
headers visible so you know what you're looking at. To demonstrate, enter
the months Jan...Dec in A2:A13 and the days of the month, 1...31 in B1:AF31.
Now suppose I ask you to enter the number 5 on November 28th. It's hard to
tell what cell that is; as you scroll to the column labeled 28, the month
labels scroll off the visible window.
Now go back to cell B2. Select it, then Window > Freeze Panes. Now go to
November 28th; it's easy because the headers are frozen.
FYI, the printout equivalent to freezing panes is available under File >
Page Setup, on the Sheet tab you select 'Rows to Repeat at Top' or 'Columns
to Repeat at Left'.

 

[Don Guillett]

homework?

 

[David McRitchie]

Sure looks like they have the same teacher anyway
Freeze Panes, Split Cells, New Window, Print Top Row(s)
http://www.mvps.org/dmcritchie/excel/freeze.htm

Would be nice if they taught how to use Help (F1) and What's this (Shift+F1)
and how to search Web sites with Google, and how to search Newsgroups with Google Groups
http://www.mvps.org/dmcritchie/excel/xlnews.htm
and what is the meaning of netiquette
http://www.cpearson.com/excel/posting.htm
http://www.mvps.org/dmcritchie/excel/posting.htm

As far as a teacher goes try these by Mike Alexander, one would not likely fall asleep
during quick five minute video tutorials.
http://www.datapigtechnologies.com/ExcelMain.htm