column title row

[Tobias Weber]

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?

 

[JE McGimpsey]

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

 

[Tobias Weber]

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?

 

[CyberTaz]

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 |:>)

 

[JE McGimpsey]

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>

 

[CyberTaz]

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).

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.

Interesting... Had never really had occasion to observe that before. I see
what you mean.

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 |:>)