Freezing column headings

C

csamms

I'm trying to create a workbook in which the column headings and row headings
appear on all worksheets...how do I do that?
 
D

David Billigmeier

Select the cell beneath the row you want to freeze, and to the right of the
column you want to freeze and:

<Window>
<Freeze Panes>
 
G

Gord Dibben

Without doing each sheet manually..................

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Range("B2").Select
ActiveWindow.FreezePanes = True
End Sub


Gord Dibben MS Excel MVP
 
Top