Excel How To Freeze Top Row And First Column. How to freeze panes in excel lock rows and columns. If you want to freeze the first row and first column b2 is the cell to select.
On the view tab click freeze panes freeze panes. The pictures are self explanatory. Select view freeze panes freeze first column.
How to freeze panes in excel lock rows and columns.
An example sheet is shown below with the first column frozen. Press the freeze first column menu item as shown below. On the view tab click freeze panes freeze panes. Selecting freeze panes in excel freezes the rows above your selected cell and the columns to the left of your selected cell.