How to freeze column in excel

Answer

To freeze a column in Excel, follow these steps to keep specific columns visible while scrolling through the rest of your worksheet.

Steps to Freeze a Column

1. Select the Column
   Click on the column to the right of the column you want to freeze. For example, to freeze column A, select column B.

2. Open the View Tab
   Go to the View tab in the Excel ribbon.

3. Freeze Panes
   Click on Freeze Panes in the Window group.

4. Choose Freeze Panes Option
   From the drop-down menu, select Freeze Panes. The selected column and all columns to the left will remain visible while scrolling horizontally.

Freeze the First Column Quickly

1. Go to the View tab.

2. Click Freeze Panes.

3. Select Freeze First Column.

4. Column A will remain visible while scrolling.

Notes

• To unfreeze columns, go to View → Freeze Panes → Unfreeze Panes.

• On Mac, the steps are the same, but the Freeze Panes button is located under Window → Freeze Panes in older versions.

This feature is useful for keeping headers or key data visible while navigating large datasets.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report