 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / January 2006column title row
Hi, some files I get open in Excel X with a grey line (no border) below the first row. More importantly: that row doesn't scroll, so you always have your column headings in view. How do I do that with my own files?  SignatureTobias Weber > some files I get open in Excel X with a grey line (no border) below the > first row. More importantly: that row doesn't scroll, so you always have > your column headings in view. > How do I do that with my own files? Select cell A2. Choose Window/Freeze Panes > Select cell A2. Choose Window/Freeze Panes Exactly. Thanks! Well hidden. I even looked up locking in the help. Who would have thought of the window menu? SignatureTobias Weber No doubt it would seem make more sense in Format>Sheet, as it is sheet-specific. However, it is a legacy feature which predates the multiple-sheets-per-workbook capability, so long-term users are accustomed to finding it there. It made sense at the time as there was only one sheet per window. BTW, depending on the active cell, it freeze both rows above _and_ columns to the left. Regards |:>) On 1/29/06 9:14 AM, in article towb-F29C85.15145329012006@news.1und1.de, >> Select cell A2. Choose Window/Freeze Panes > > Exactly. Thanks! > > Well hidden. I even looked up locking in the help. Who would have > thought of the window menu? > No doubt it would seem make more sense in Format>Sheet, as it is > sheet-specific. No, Freeze Panes is window-specific. Putting it in Format/Sheet would make little sense... > However, it is a legacy feature which predates the > multiple-sheets-per-workbook capability, so long-term users are > accustomed to finding it there. MacBU hasn't been shy about moving menu items around in the past... In the Excel object model, the FreezePanes property is a property of windows, not the worksheets. To demonstrate: 1) Create a blank worksheet. Enter some random data if desired. 2) Select cell A2. Choose Window/Freeze Panes... 3) Note that the top row is frozen. 4) Choose Window/New Window 5) Note that the second window's top row is not frozen, even though the windows display the same worksheet. 6) Select cell B4. Choose Window/Freeze Panes... 7) Note that the same worksheet now has two windows with different frozen panes. > It made sense at the time as there was only one sheet > per window. Still does...<g> On 1/29/06 11:37 AM, in article jemcgimpsey-C9EECB.09371229012006@msnews.microsoft.com, "JE McGimpsey" <jemcgimpsey@mvps.org> wrote: >> No doubt it would seem make more sense in Format>Sheet, as it is >> sheet-specific. > > No, Freeze Panes is window-specific. Putting it in Format/Sheet would > make little sense... Poor phrasing on my part, but the key word is "seem"... The intended point was that Freezing Panes on one sheet has no effect on other sheets in the same book. Nor did I take multiple windows into consideration (obviously). >> However, it is a legacy feature which predates the >> multiple-sheets-per-workbook capability, so long-term users are [quoted text clipped - 16 lines] > 7) Note that the same worksheet now has two windows with different > frozen panes. Interesting... Had never really had occasion to observe that before. I see what you mean. >> It made sense at the time as there was only one sheet >> per window. > > Still does...<g> Quite so, but I understand the OP's position about it not being the 'obvious' place to look for one not as well versed in the program's design as yourself :) Thanks for the clarification! Regards |:>) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.