MS Excel
0 Guide

How to Freeze Columns in Excel (Step-by-Step Guide)

This is an Arcade

Learn how to freeze columns in Excel step by step

1. Open your Excel worksheet.

2. Click the column to the right of the column(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 columns 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 Columns in Excel (Step-by-Step Guide)", "description": "Learn how to freeze columns in Excel step by step", "keywords": "MS Excel freeze columns", "step": [ { "@type": "HowToStep", "name": "Open worksheet", "text": "Open your Excel worksheet." }, { "@type": "HowToStep", "name": "Select column position", "text": "Click the column to the right of the column or columns 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 columns", "text": "The selected columns will stay visible while scrolling." } ] }