How to Freeze Rows 1 and 2 and Columns A Through H in Excel
Question details
The user needs to know how to simultaneously lock rows 1 and 2 along with columns A through H so that they remain constantly visible while scrolling through a spreadsheet.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Scrolling through a large dataset while needing to keep both the top header rows and the initial data columns locked on the screen.
- Observed behavior
- The user wants to establish a fixed viewing area for specific multiple rows and columns by identifying the correct anchor cell for the Freeze Panes feature.
Ensure your workbook is set to 'Normal' view, as the Freeze Panes feature is disabled in 'Page Layout' view. If you already have active frozen panes, you must unfreeze them first before applying a new custom freeze area.
Use Freeze Panes with an Intersection Cell
To freeze both rows and columns at the same time, you must select the single cell that intersects immediately below the target rows and immediately to the right of the target columns.
Excel relies on the active cell's placement to determine where to draw the freeze lines. Everything above the selected cell and everything to the left of the selected cell will be frozen in place.
Click to select cell I3. Row 3 is immediately below your target rows (1 and 2), and column I is immediately to the right of your target columns (A through H).
On the top ribbon menu of Excel, click on the 'View' tab to access the window display tools.
Click the 'Freeze Panes' button in the Window group, and then select 'Freeze Panes' from the dropdown menu.
Easily Freeze Multiple Rows and Columns with WPS Spreadsheet
WPS Spreadsheet allows you to effortlessly freeze complex intersections of rows and columns just like Microsoft Excel, completely free. It provides a highly intuitive interface to lock headers and important data columns in place so you can analyze large datasets without losing context.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the worksheet where you need to lock your rows and columns.
- 2. Select the anchor cell: Click on cell I3 to prepare for freezing rows 1 and 2, and columns A through H.
- 3. Navigate to the View menu: Click on the 'View' tab located on the top ribbon.
- 4. Lock the panes: Click the 'Freeze Panes' button to instantly lock the selected rows and columns in place.
Frequently Asked Questions
Why is the Freeze Panes button grayed out or unclickable?
The Freeze Panes option will be disabled if your workbook is in Page Layout view, if you are actively editing the text inside a cell, or if the worksheet is protected. Press 'Esc' to exit cell editing mode and switch back to 'Normal' view under the View tab.
How do I unfreeze the rows and columns I just locked?
To remove the frozen boundaries, go back to the View tab on the ribbon, click on Freeze Panes, and select 'Unfreeze Panes' from the dropdown list. The solid gray lines will disappear, restoring standard scrolling.
Can I freeze multiple disjointed rows, like Row 1 and Row 5?
No, Excel only allows you to freeze contiguous rows at the top of the worksheet and contiguous columns on the left side. You cannot lock rows or columns in the middle of a sheet without also locking everything above or to the left of them.
Why did Freeze Panes lock the wrong area on my screen?
If the wrong rows or columns were frozen, the wrong cell was selected before applying the command. Make sure to first select 'Unfreeze Panes', then carefully click the single cell directly below the rows and to the right of the columns you want to freeze before trying again.
