ExcelBanter - How do I create a "floating" header in Excel so I can always see i

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I create a "floating" header in Excel so I can always see i (https://www.excelbanter.com/excel-discussion-misc-queries/55792-how-do-i-create-floating-header-excel-so-i-can-always-see-i.html)

Andy Heal

How do I create a "floating" header in Excel so I can always see i

contact me at

Gord Dibben

How do I create a "floating" header in Excel so I can always see i

Andy

To have row 1 always in view as you scroll down.

Select A2 and WindowFreeze Panes.

Rule is: whatever is above and left of the selected cell will be frozen after
you hit WindowFreeze Panes.

i.e. select B2 to have Column A and Row 1 frozen.

Gord Dibben Excel MVP

On Wed, 16 Nov 2005 13:38:00 -0800, Andy Heal <Andy
wrote:

contact me at

All times are GMT +1. The time now is 01:20 PM.