How to freeze rows and columns in Excel

If you usually work with large worksheets, it’s really important that you familiarize yourself with the steps to freeze rows and columns in Excel.

Freeze rows and columns in Excel

As you may have noticed, when you scroll down an Excel worksheet, the column headings disappear and are no longer visible.

Without visible column headings, it becomes really difficult to enter new data in the correct columns or to review and compare the existing data.

A simple solution to this problem is to just freeze the entire row that contains column headers. Once this is done, the column headings will be frozen and always visible when you scroll down.

Likewise in Excel it is possible to freeze columns and freeze both rows and columns at the same time.

Note: Freezing rows or columns does not affect printing, it only affects how the worksheet appears on screen.

1. Freeze rows in Excel

In case you want to make the column headers stationary and always visible when you scroll down, you can follow the steps below to freeze the row of column headers.

1.1. Choose The line (or the first cell in the row) directly below the row that contains the column headings.

Select row in Excel

1.2. Then click on the outlook tab > click Freeze windows and then click Freeze windows option in the drop down menu.

Option to freeze windows in Excel

This freezes the row with the column headers and keeps that particular row visible whenever you scroll down the worksheet.

2. Freeze columns in Excel

If the worksheet spans multiple columns, you may want certain columns to be visible whenever you scroll the worksheet to the side (left or right).

2.1. Choose one cell is immediately to the right of the column you want to freeze. In our case, we selected cell B2 to freeze column A, which contains “Items”.

Select cell in Excel

2.2. Then click on the outlook tab > click Freeze windows and then click Freeze windows in the drop down menu.

Option to freeze windows in Excel

This will freeze column A and keep that particular column visible whenever you scroll sideways on the worksheet

3. Freeze both rows and columns in Excel

In certain cases, you may want to freeze the column header row and also freeze the first column or some selected columns in the worksheet.

To freeze both rows and columns, select cell is to the right of the column you want to freeze and below the row you want to freeze.

In our case, we selected cell B2 to freeze the second row with column headers and also column A with “Items”.

Select cell in Excel

After selecting the right cell, click on the outlook tab > Freeze windows > Freeze windows option in the drop down menu.

Option to freeze windows in Excel

Now the rows above the selected cell stay frozen when you scroll down, and the columns to the left of the selected cell also stay frozen when you scroll sideways.

Unlock row and column ranges in Excel

You can share rows and columns in Excel at any time by clicking outlook tab > Freeze windows > share window option in the drop down menu.

Unfreeze panes option in Excel

The frozen rows or columns become free and no longer remain frozen or stationary when you scroll up or down.

Freezing windows is not available in Excel

You may encounter an issue where the Freeze Panes option is unavailable, greyed out, or not working. This problem is usually related to the worksheet being in Page Layout view.

To fix this problem, click outlook Tab and then click normal or page break preview.

Switch to normal view in Excel

The Freeze Window option can also be disabled because the workbook is in protected mode.

However, this issue has been fixed in newer versions of Microsoft Excel, and this issue only occurs when you work on files created with an older version of Excel (earlier than Excel 2013).

Related

Leave a Reply

Your email address will not be published.