Freezing Panes

  • Thread starter Thread starter Guest
  • Start date Start date
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'.
 
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
 
Back
Top