We have an Excel worksheet with information about a company. We’ll freeze the column header and the employee names so they stay on the screen while scrolling.
Method 1 – Using Freeze Panes to Freeze Columns
Steps:
- Since we’re freezing columns up to column C, select the D column.
- Select Freeze Panes from the View tab.
- From the dropdown list, select Freeze Panes.
- You can now scroll horizontally with these two columns always visible.
Read More: How to Freeze Multiple Panes in Excel
Method 2 – Applying Excel Freeze Panes to Freeze Rows
Steps:
- We want to freeze the rows so the information for the first four employees shows, which ends at row 8. So, select row 9.
- Select Freeze Panes from the View tab.
- From the dropdown list, select Freeze Panes.
- You can now scroll down with these 4 rows always visible.
Method – Adding a Freeze Button to the Quick Access Toolbar to Freeze Columns and Rows at the Same Time
Steps:
- Click the down arrow from the top of the Excel file.
- Click More Commands from the drop-down list.
- Under Choose commands from, select Commands Not in the Ribbon.
- Select Freeze Panes and click Add.
- Click OK to add the command to the Quick Access Toolbar.
- To freeze rows and columns, select the first cell after the row and column you want to freeze.
- Click the Freeze Panes button and the columns and rows will be frozen at the same time.
Read More: How to Freeze Panes with VBA in Excel
Method 4 – Splitting Panes to Freeze Rows and Columns Simultaneously
Steps:
- We want to freeze the first two rows (information of the first two employees) of the worksheet. So, we will select row 7.
- On the View tab, click Split.
Things to Remember
- You can’t use Freeze Panes and Split Panes simultaneously.
- You have to select the row(s) below the one you want to be frozen or the column right of the column(s) you need to be frozen.
- If you want to freeze rows and columns at the same time based on a reference cell, the reference cell must be below the row and to the right of the column you want to freeze.
Download the Practice Workbook
Further Readings
- How to Freeze Top Row and First Column in Excel
- How to Unfreeze Rows and Columns in Excel
- Keyboard Shortcut to Freeze Panes in Excel
- How to Apply Custom Freeze Panes in Excel
- Excel Freeze Panes Not Working
<< Go Back to Freeze Panes | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!