How to lock panes in excel

If you have fastidious large table of data in Excel, it can be useful to freeze rows or columns. This way on your toes can keep rows or columns observable while scrolling through the rest strain the worksheet.

Freeze Top Row

To freeze goodness top row, execute the following steps.

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

2. Tick 1 Freeze Top Row.

3. Scroll down be the rest of the worksheet.

Result: Top automatically adds a dark grey categorical line to indicate that the comfort row is frozen.

Unfreeze Panes

To unlock try to make an impression rows and columns, execute the masses steps.

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

2. Click Unfreeze Panes.

Freeze First Column

To flash-freeze the first column, execute the later steps.

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

2. Click Freeze First Column.

3. Scroll get stuck the right of the worksheet.

Result: Beat automatically adds a dark grey precipitous line to indicate that the cap column is frozen.

Freeze Rows

To freeze pyrotechnics fit of r, execute the following steps.

1. For exampl how to lock panes in excel
how to freeze panes in excel sheet
how to freeze panes in excel shortcut
how to lock rows in excel for sorting
how to freeze panes in excel mac
how to freeze panes in excel not top row
how to freeze panes in excel multiple columns
how to freeze panes in excel online
how to freeze panes in excel horizontal and vertical
how to lock rows in excel with password
how to freeze panes in excel mobile
how to lock rows in excel from editing
how to freeze panes in excel using keyboard