Freeze First Column and Row in Excel
Excel's a great tool to work with data, especially lots of data. Having frozen rows and columns helps a lot while analyzing large datasets. Excel provides a very easy way to freeze rows and columns. Here's how -
Freeze both First Row and First Column
To freeze both the first row and first column together, select the cell B2 and click Windows >> Freeze Panes.
The first row and column will remain static depending on whether you scroll vertically or horizontally.
Freeze First Row Only
To Freeze the first row, select the row below it i.e the second row.
Now in the menu, go to Windows >> Freeze Panes.
This completely freezes the first row. The row will always be still while scrolling down.
Freeze First Column Only
Select the second column i.e the B column. After that, go to Windows >> Freeze Panes.
More Excel Tips:
Convert Rows to Columns and Columns to Rows
Transfer Excel Spreadsheet to Access Table
Export Access Table to Excel