How to freeze rows and columns in excel

    how to freeze top line in excel
    how to freeze top line in excel spreadsheet
    how to freeze top line in excel sheet
    how to lock top line in excel
  • How to freeze top line in excel
  • How to freeze columns in excel

    How to freeze multiple rows in excel.

    Freeze Panes in Excel

    If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.

    Freeze Top Row

    To freeze the top row, execute the following steps.

    1.

    On the View tab, in the Window group, click Freeze Panes.

    2. Click Freeze Top Row.

    3. Scroll down to the rest of the worksheet.

    Result: Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.

    Unfreeze Panes

    To unlock all rows and columns, execute the following steps.

    1.

    On the View tab, in the Window group, click Freeze Panes.

    2.

    How to freeze multiple columns in excel

  • How to keep header row in excel when printing
  • How to freeze multiple rows in excel
  • Excel freeze top 2 rows
  • How to freeze rows and columns in excel (at the same time)
  • Click Unfreeze Panes.

    Freeze First Column

    To freeze the first column, execute the following steps.

    1. On the View tab, in the Window group, click Freeze Panes.

    2. Click Freeze First Column.

    3.

    Scroll to the right of the worksheet.

    Result: Excel automatically adds a dark grey vertical line to indicate that the first column is frozen.

    Freeze Rows

    To freeze rows, execute the following steps.

    1.

    For exampl

      how to freeze top row in excel sheet
      how to freeze top row in excel for printing