MS Excel
0 Guide

How to Freeze Rows in Excel

This is an Arcade

Learn how to freeze rows in Excel for more visibility while scrolling.

1. Open your Excel worksheet.

2. Click the row to the above of the row(s) you want to freeze.

3. Go to the View tab.

4. Click Freeze Panes.

5. Select Freeze Panes from the dropdown.

6. Now, the selected rows will stay visible while scrolling.

MS Excel
0 Guide

Ready to create quick,
interactive product demos?

Sign up
– it's free
{ "@context": "https://schema.org", "@type": "HowTo", "name": "How to Freeze Rows in Excel", "description": "Learn how to freeze rows in Excel for more visibility while scrolling.", "keywords": "MS Excel freeze rows", "step": [ { "@type": "HowToStep", "name": "Open worksheet", "text": "Open your Excel worksheet." }, { "@type": "HowToStep", "name": "Select row position", "text": "Click the row above the row or rows you want to freeze." }, { "@type": "HowToStep", "name": "Go to View tab", "text": "Go to the View tab." }, { "@type": "HowToStep", "name": "Open Freeze Panes", "text": "Click Freeze Panes." }, { "@type": "HowToStep", "name": "Apply freeze panes", "text": "Select Freeze Panes from the dropdown." }, { "@type": "HowToStep", "name": "Confirm frozen rows", "text": "The selected rows will stay visible while scrolling." } ] }