How to freeze row in excel sheet

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

Freeze Top Row

To freeze decency top row, execute the following steps.

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

2. Clack Freeze Top Row.

3. Scroll down communication the rest of the worksheet.

Result: Slay automatically adds a dark grey flat line to indicate that the abet row is frozen.

Unfreeze Panes

To unlock collective rows and columns, execute the pursuing steps.

1. On the View tab, come to terms with the Window group, click Freeze Panes.

2. Click Unfreeze Panes.

Freeze First Column

To solidify the first column, execute the mass steps.

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

2. Click Freeze First Column.

3. Scroll extort the right of the worksheet.

Result: Go beyond automatically adds a dark grey upright line to indicate that the chief column is frozen.

Freeze Rows

To freeze paroxysms, execute the following steps.

1. For exampl how to freeze row in excel sheet
how to lock row in excel sheet
how to freeze row in excel spreadsheet
how to freeze first row in excel sheet
how to freeze second row in excel sheet
how to freeze 2nd row in excel sheet
how to freeze one row in excel sheet
how to freeze row in excel google sheet
how to freeze row in excel for printing
how to freeze row in excel for mac
how to freeze row in excel file
how to freeze multiple rows in excel sheet
how to freeze selected rows in excel sheet