If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Freezing Panes
Explain the term Frozen Panes
|
#2
|
|||
|
|||
Freezing 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 |
#3
|
|||
|
|||
Freezing Panes
homework?
-- Don Guillett SalesAid Software "muerkilla" wrote in message ... Explain the term Frozen Panes |
#4
|
|||
|
|||
Freezing 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" wrote in message ... homework? -- Don Guillett SalesAid Software "muerkilla" wrote in message ... Explain the term Frozen Panes |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Freezing Panes | JB | General Discussion | 1 | October 22nd, 2005 02:10 PM |
Freezing Panes | pknivens | General Discussion | 2 | October 13th, 2005 12:45 PM |
Freezing panes | Tiina | General Discussion | 1 | October 12th, 2005 12:18 PM |
Freezing panes | LAF | General Discussion | 1 | September 16th, 2005 03:56 PM |
Freezing panes, phantom line | mystical_ways | General Discussion | 1 | August 12th, 2005 02:14 AM |