How to freeze panes in Excel.....

Sometimes when you're working with Microsoft Excel spreadsheets, there is too much data in the rows/columns that you have to use the scroll to get to the end of it. At that very moment, you wonder how can i see the 1st column and the last row/column together [most of the times its needed]. That's where ''Freeze panes" option comes to play. To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can simply lock specific rows or columns in one area by freezing or splitting panes.

When you freeze panes, you keep specific rows or columns visible when you scroll in the worksheet. For example, you might want to keep row and column labels visible as you scroll.

A solid line indicates that row 1 is frozen to keep column labels in place when you scroll.

When you split panes, you create separate worksheet areas that you can scroll within, while rows or columns in the non-scrolled area remain visible.

This is how you do it:

On the worksheet, perform the following:

1) To lock rows, select the row below the row or rows that you want to keep visible when you scroll.
2) To lock columns, select the column to the right of the column or columns that you want to keep visible when you scroll.
3) To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll.

How to select cells, ranges, rows, or columns:

On the View tab, click the arrow below Freeze Panes.

Do one of the following:
1) To lock one row only, click Freeze Top Row.
2) To lock one column only, click Freeze First Column.
3) To lock more than one row or column, or to lock both rows and columns at the same time, click Freeze Panes.