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.