totn Excel

MS Excel 2013: Freeze first column

This Excel tutorial explains how to freeze panes to keep the first column visible when scrolling in Excel 2013 (with screenshots and step-by-step instructions).

Question: In Microsoft Excel 2013, I have a spreadsheet and I need to freeze the first column. That way, I can see the first column at all times even when I scroll. How can I do this?

Answer: If you need to see the first column (column A) even after scrolling, you could try freezing the pane in Excel.

NOTE: Freezing panes only works when you are in Normal View.

To freeze the first column, open your Excel spreadsheet.

Select the VIEW tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze First Column option in the popup menu.

Microsoft Excel

Now when you scroll, you should still continue to see column A.

Microsoft Excel