• Go to the View tab, where you can Freeze Panes to lock select rows and columns in place, or Split Panes to create separate windows of the same worksheet, to keep one section of a worksheet visible while you navigate to another area of the worksheet.
• The first column should be frozen.Choose View > Freeze Panes > Freeze First Column from the View menu. The weak line between Column A and Column B indicates that the first column is frozen.
• The first two columns should be frozen. -The third column should be selected. Select View > Freeze Panes > Freeze Panes from the View menu.
• Columns and rows should be frozen. When you scroll, select the cell below the rows and to the right of the columns you want to keep visible. Select View > Freeze Panes > Freeze Panes from the View menu.

Read More: What is the use of comment? How to add comments to a cell in excel?