How to freeze two columns on Excel

In excel sheets we freeze columns, rows, or cells to make them visible all through the entire excel sheet even when we scroll from top to bottom. Excel sheets provide its users with the function or the tool to freeze rows, columns, cells, and panes

Freezing is the general activity of locking columns and rows in a given excel sheet so that when you happen to scroll top to down your rows or columns remain visible. We do freezing with the help of the freezing tool located under the view menu on the menu bar.

When data is on freeze function, it is made all visible throughout the entire sheet even when you scroll to the bottom cell of your data. This function helps the user keep a track of important data because it will always appear visible on the screen.

To do freezing is not a hard thing do, with the help of the following steps, you can freeze your work that is rows and columns at your convenient pace.

Step 1

First of all, you will need to have the data set in an excel sheet that you would like to freeze the columns. If you do not have the data set to work on, open a blank excel sheet from Microsoft Excel on your laptop and insert some columns with data in them as in the case below.

Step 2

The second step is to select the columns you wish to lock. In this case, we are going to select two columns because they are the ones we are interested in at the moment. Note to freeze two columns you need to select the third column.

After you are done with the selection, go to the menu bar, and select on view. Under view, browse to find freeze panes. Click on freeze panes to reveal the list of options, select the first option which is freeze panes. This option will freeze or rather lock the two columns in a way that they will always remain visible even after scrolling down.

The sample excel sheet below explains the entire procedure in the picture form.


%d bloggers like this: