How do I freeze columns in Excel 2003?
To freeze the first column, open your Excel spreadsheet. Select cell B1. Then under the Window menu, select Freeze Panes. Now when you scroll, you should still continue to see column A.
How do I freeze my headings in Excel?
To freeze the top row or first column:
- From the View tab, Windows Group, click the Freeze Panes drop down arrow.
- Select either Freeze Top Row or Freeze First Column.
- Excel inserts a thin line to show you where the frozen pane begins.
How do I freeze panes in Excel 97 2003?
For Excel 97-2003, select Window, Freeze Panes. For Excel 2007/2010, click the View tab. From the Window group click the Freeze Panes button and select Freeze Panes.
How do I lock the top row in Excel 2002?
Freeze the Top Row in Excel To freeze the top row in a spreadsheet: Select View. Select Freeze Panes to display a drop-down list. Select Freeze Top Row.
How do I freeze multiple rows in Excel 2003?
Select the Window menu, and then select Freeze Panes. You might want to experiment on a large worksheet. Freeze the column and row headings, and then use the keyboard or the mouse to move around in the worksheet. As you do, the row and/or column headings remain locked in their positions.
How do you freeze a row in Excel that isn’t the top row?
To freeze rows:
- Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3.
- Click the View tab on the Ribbon.
- Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
- The rows will be frozen in place, as indicated by the gray line.
Can you freeze bottom rows in Excel?
To freeze rows: Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3. On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. The rows will be frozen in place, as indicated by the gray line.
Can I freeze both row and column 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.
Can you freeze middle row in Excel?
Select the row below the row(s) you wish to freeze. Click the View tab on the Ribbon. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. … Your selection will be frozen in place.
How do you freeze header rows in Excel?
If the header row is also row 1 of the worksheet then all you have to do is go up to the Ribbon under the View tab and select Freeze Top Row after clicking Freeze Panes. If your header row is some other row, click on a cell in the immediate next row below the header row and select Freeze Panes instead.
How to freeze multiple panes in Excel?
Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
How to freeze two rows in Excel?
– To lock one row only, choose the View tab, and then click Freeze Top Row. – To lock one column only, choose the View tab, and then click Freeze First Column. – To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes. – To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes. – To lock multiple columns, select the column to the right of the last column you want frozen, choose the View tab, and then click Freeze Panes.
How to lock the first row in Excel?
Open your Excel spreadsheet.