Quote:
Originally Posted by Donna B
How do you have the column headings scroll with you as you work downward on a
page ?? Help . . . Bless you for information - much needed ! Thanks
|
If you are familar with VBA and automate your spreadsheets, try below steps
'Freeze Rows
Rows("1:1").Select
ActiveWindow.FreezePanes = True
;Freeze Columns
Range("A:A").Select
ActiveWindow.FreezePanes = True
'Freeze Rows and Columns
Range("B2").Select
ActiveWindow.FreezePanes = True
'UnFreeze Panes
ActiveWindow.FreezePanes = False
all the best