Explain the term Frozen Panes
Explain the term Frozen Panes
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'.
"muerkilla" wrote:
> Explain the term Frozen Panes
homework?
--
Don Guillett
SalesAid Software
[email protected]
"muerkilla" <[email protected]> wrote in message
news:[email protected]...
> Explain the term Frozen Panes
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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Don Guillett" <[email protected]> wrote in message news:[email protected]...
> homework?
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "muerkilla" <[email protected]> wrote in message
> news:[email protected]...
> > Explain the term Frozen Panes
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks