How to Freeze Selected Rows in Excel

Excel is a spreadsheet program that helps us manipulate data in cells. A cell is an intersection between a row and a column. A row in excel is a horizontal arrangement of cells. Columns on the other hand are vertical arrangements of cells. A single entry page of cells is called a worksheet. Worksheets are labeled with tabs and are by default Worksheets contain related data.

Each worksheet can contain too much data that even flows beyond on-page. IF we needed to view the rest of the data we would have to scroll down the worksheet using the vertical scroll bars at the sides of the excel document. Doing this scrolls all the content from the first row to the rows that we intend to arrive at. However, sometimes we might not desire such phenomena.

How to freeze selected rows

Step 1: After the Opening excels, the first worksheet will be loaded. Select the rows you want to freeze.

This is done by taking the cursor to the left-most side of the rows you want to highlight.

The rows that are to be frozen are those just above the lastly selected row. For example to freeze all the top first ten rows, select the eleventh row. In my case, I have selected the first three so that the first two rows can be frozen.

Step 2: Click the View tab on the Excel ribbon located at the top.

Step 3: Then navigate to the window group of command icons and select the freeze panes command.

This is realized after clicking the View tab on the ribbon. Now you can scroll throughout the worksheet without the freeze rows moving. Only these rows that freeze remain in their fixed position while other rows scroll up and down.

You will notice that the rows that you freeze remain visible or fixed even when scrolling down the entire worksheet. For example in our case below, we can see that the first two rows do not scroll with the rest of the worksheet.