How do you freeze a column in old Excel?
To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then under the Window menu, select Freeze Panes. Now when you scroll, you should still continue to see row 1 and column A.
How do I freeze cells in Excel 2003?
Select the cell that is below the left-most column heading that you wish to see. Then under the Window menu, select Freeze Panes.
How do you freeze data in Excel?
Freeze columns and rows in Excel
- Select the row below the row(s) you want to freeze (select row 6, if you want to freeze rows 1 to 5).
- On the View tab, click Freeze Panes > Freeze Panes.
How does freeze panes work in Excel?
When you freeze panes, Microsoft Excel keeps specific rows or columns visible when you scroll in the worksheet. For example, if the first row in your spreadsheet contains headers, you might freeze that row to make sure that the column headers remain visible as you scroll down in your spreadsheet.
How do I freeze multiple columns in Excel?
Freeze columns and rows
- Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
- Select View > Freeze Panes > Freeze Panes.
How do I freeze first column and first row at the same time?
Freeze Top Row and First Column Simultaneously ➤ Go to the View tab and click on Freeze Panes from the Window ribbon. As a result, the Freeze Panes menu will appear. ➤ Click on the Freeze Panes. It will freeze both the top row and the first column of the worksheet.
How do you freeze columns in sheets?
Freeze or unfreeze rows or columns
- On your computer, open a spreadsheet in Google Sheets.
- Select a row or column you want to freeze or unfreeze.
- At the top, click View. Freeze.
- Select how many rows or columns to freeze.