You are currently viewing How to freeze column A and B in Excel

How to freeze column A and B in Excel

When working with a lot of data on the workbook, it may be difficult to compare information on various columns and rows. However, excel has several tools to make that make it easier to view different content on the workbook screen. Excel provides its users with the ability to freeze both the columns and rows. When it's done correctly, the chosen panes within Excel's freeze panes are locked in place. That means whenever you freeze any column on the workbook, Microsoft Excel keeps that specific column visible when you scroll in the worksheet. Excel also doesn't limit the user on the number of columns one can freeze. Besides allowing you to compare different columns on a long spreadsheet, the freeze panes feature lets you keep important information always in view.

In this article, we shall learn how to freeze columns A and B using the Freeze panes feature of excel.

 

1. Open the excel worksheet

Once you've launched the excel application, open the blank workbook to add and create the watermark. This is achieved by clicking the excel tool button located on the top left corner of the screen. Then, click the new button, and then click the create button to open the new workbook.

2. Click on the third column

When freezing column(s) in excel, the next column from the one to be locked is selected, and then the freeze panes feature is applied. Since, in our case, we only want to freeze the first two columns, that is, "A" and "B," we will have to click on the third column named C. On clicking on this column, excel can identify the columns to be locked.

3. Click the View tab button

Once you've selected the third column, locate and click on the view tab found on the ribbon bar.

4. Tap the freeze panes button

Below the View tab, locate the Window section. Then, tap the Freeze Panes button. On the drop-down menu, various freeze panes features can be used to freeze the document. Since we want to freeze the selected columns, thus select freeze panes from the drop-down menu. By doing so, the columns are automatically frozen.

5. Frozen columns

That's all that is required. The frozen column will be separated from other columns by a gray line that runs downwards. The columns located on the left side of the line represent the frozen columns, whereas those found on the right side are not frozen.