To freeze the top row or column:
- On the View tab, in the Windows group, click the Freeze Window drop-down arrow.
- Select either “Freeze First Row” or “Freeze First Column”.
- Excel inserts a thin line to show where the frozen area begins.
How to freeze rows and columns at the same time in Excel 2010?
To freeze the top row and first column at the same time, click View tab > Freeze Window > Freeze Window. 5
How to freeze windows in Excel 2010?
In an open table, select View in the top menu bar and then press Freeze First Column. This will freeze column A. 2. If you want to freeze multiple columns, click in the first cell to the right of the last column that you want to freeze. Then on the View menu, click Freeze Window. 19
How to freeze windows horizontally and vertically at the same time in Excel 2010?
To freeze the top row and first column at the same time, click View tab > Freeze Window > Freeze Window. 5
How to freeze first two rows in Excel 2010?
To lock multiple rows (starting with row 1), select the row below the last row that you want to freeze, select the View tab, and click Freeze Window. To freeze multiple columns, select the column to the right of the last column you want to freeze, select the View tab, and click Freeze Panes.
How to freeze second column in Excel 2010?
To lock multiple rows (starting with row 1), select the row below the last row that you want to freeze, select the View tab, and click Freeze Window. To freeze multiple columns, select the column to the right of the last column you want to freeze, select the View tab, and click Freeze Panes.
How to freeze both a column and a row in Excel?
To lock multiple rows (starting with row 1), select the row below the last row that you want to freeze, select the View tab, and click Freeze Window. To freeze multiple columns, select the column to the right of the last column you want to freeze, select the View tab, and click Freeze Panes.
How to freeze multiple windows in Excel 2010?
Click the View tab. Click the Freeze Window command. A drop-down menu will appear. Choose Freeze Regions.
How to freeze top and side panels in Excel 2010?
To lock multiple rows (starting with row 1), select the row below the last row that you want to freeze, select the View tab, and click Freeze Window. To freeze multiple columns, select the column to the right of the last column you want to freeze, select the View tab, and click Freeze Panes.