Microsoft Excel: How to Freeze a Row in 2 Fast Methods

Freeze top row or first column

Excel’s functionality includes the first row and first column freezing as a default in the “Freeze Panes” dropdown menu. To access it, you need to go to the spreadsheet, click the “View” menu, navigate to “Freeze Panes,” and click the arrow.

You’ll see three choices. The bottom two are referring to the “First Row” and “First Column.” You can choose one, the other, or both.

Fix rows and columns

There might be cases where freezing the first row and column isn’t enough. To ensure convenience, you can also suspend more than one of them. To freeze more than one row, follow the steps below:

– Click the row below what you want visible at a scroll

– Go to View > Freeze Panes

– Choose the top option

The same trick works for the columns:

– Click a column to the right of what you want frozen

– Go to View > Freeze Panes

– Click the unspecified panes option on top of the list

You can also halt columns and rows at the same time. Just click a tile, and go to the “Freeze Panes” selection mentioned above. Once you click, all the rows above and columns to the left of the selected tile will stay in place.