Skill Level: Beginner

I’m a huge advocate for learning by video so in this clip, I’ll introduce and show you how to freeze rows and columns in Excel.

This section is made specifically for those of you who learn better by seeing / watching.

Select a Row

The first step of the process is to select the row (by highlighting the row number on the left).  Any content/cells above the highlighted row will be frozen so that when you scroll through your worksheet, you’ll continue to see that content.

Select View & Freeze Panes

The second and last step of being able to freeze rows in Excel is to head over to the view tab of the quick access ribbon and select freeze panes.  Once you’ve done this, as you scroll down through your spreadsheet, any rows above the row select will remain in sight on your worksheet.

Select a Column

The first step of the process is to select the column (by highlighting the column letter on the top of your spreadsheet).  Any content/cells left of the highlighted column will be frozen so that when you scroll through your worksheet from right to left, you’ll continue to see that content.

In the example below, I’ve frozen all columns to the left of column C so that we can see the stock name and its ticker symbol.

Select View & Freeze Panes to Freeze Columns

The second and last step of being able to freeze columns in Excel is to head over to the view tab of the quick access ribbon and select freeze panes.  Once you’ve done this, as you scroll to the right in your spreadsheet, any columns to the left of your highlighted column will remain in sight on your worksheet.

Select a Cell

The first step of the process is to select a cell whereby you want all columns to the left to be frozen and all rows above the cell to be frozen.  This will then allow columns and rows to the left and above to always be shown when scrolling through your worksheet.

In the example below, I’ve selected cell C2 so that all columns to the left of column C and all rows above row 2 will remain frozen when scrolling.

Select View & Freeze Panes to Freeze Columns and Rows

The second and last step of being able to freeze columns and rows at once in Excel is to head over to the view tab of the quick access ribbon and select freeze panes.  Once you’ve done this, as you scroll to the right or down in your spreadsheet, any columns to the left and any rows above your highlighted cell will remain in sight on your worksheet.