How To Freeze A Row In Excel

When having a long sheet in Microsoft Excel, or a sheet that you often scroll through, you may want to consider earning how to freeze a row in Excel so that they’re always visible.

Find more Excel guides here

I do this often when I create a spreadsheet that has rows of information, to ensure the information is labelled correctly. You just need to know how to freeze a row in Excel.


It is pretty straightforward and simple to do, one of these things that once you have done it a number of times, you will find you just remember how.

How To Freeze A Row In Excel

ow To Freeze A Row In Excel
Credit: Microsoft

All you need to do is select the cell below the row you want to freeze. Then, select View on the toolbar, followed by Freeze Panes and then Freeze Panes again. That will freeze the row that you want to be frozen so that they are always visible.

If you are looking to freeze columns in Microsoft Excel, the process is pretty simple too.

  • Step 1: Select View on the toolbar
  • Step 2: Select Freeze Panes
  • Step 3: Select Freeze Top Row or First Column.

That will freeze the first row or column of your Excel spreadsheet, and you will see a faint line appear between Columns A and B that shows that the first column is frozen.

If you are freezing the first two columns, you need to select the third column, then select View, followed by Freeze Panes and Freeze Panes again. This will freeze the first two columns in your sheet. 

Once you have frozen some rows, you will find that it’s a simple process for the future.


The fighting in Ukraine is causing families to flee their homes. Please give now to save lives and protect people in need. Donate today!

Keep the conversation going by heading over to our Facebook and Twitter pages. You can also find us on Instagram, TikTok, and YouTube. Be sure to also check out our friends over on GameByte and Sporf.

Along with the latest games, merch, and accessories, the GameByte Shop has an epic Loyalty Points Scheme – earning you points for every £1 you spend. Sign up to hear about exclusive deals, PS5 console drops, and more!


<div class=”klaviyo-form-VAkrCV”></div>

Featured Image Credit: Microsoft