December 3, 2020

How to Freeze Rows in Excel

Sometimes in excel, we have certain requirement to freeze a section as header, so that when you scroll down, the header section does not go away. To freeze rows, follow the below steps:

  1. Go to left hand side of the excel where row numbers are mentioned. Press Ctrl and select as many rows you want to freeze. Selected rows are highlighted with greens.
  2. Go to View.
  3. Click on Freeze Panes drop down.
  4. Select Freeze Panes.

Leave a Reply

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