December 4, 2020

How to Freeze Columns in Excel

Sometimes in excel, we have certain requirement to freeze a section of the column(s), so that when you scroll left/right, the frozen column(s) section does not go away. To freeze column(s), follow the below steps:

  • Select the immediate right column after the columns you want to freeze.
  • Go to view.
  • Select ‘Freeze Panes’ drop down. Select ‘Freeze Panes’ option.

In this example, we want to freeze column A & B i.e. ‘Department’ and ‘Region’ so we select column C.

Now if you scroll right you will see the columns ‘Department’ and ‘Region’ are fixed.

Leave a Reply

Your email address will not be published. Required fields are marked *