Splitting Panes and locking rows and columns in excel is very useful option not all of us could be aware of it.
When you are working with big excel sheet14 steps to create cash flow from primavera with sample file. Read more ... », This option will be very useful because you can view two areas of a worksheet and lock rows or columns into one place by splitting panes and locking rows and columns. Lets see how to do this.How to Freeze Panes in Excel 2010Advertisement
1- Splitting Panes:
When you split panes, you can scroll in theHeads Up WHAT'S THE FIRST WORD YOU SEE?. Read more ... » two areas of the worksheet that you’ve split, and all areas remain visible. You’ll see more of what we mean in just a minute.
The Splitting option work as the following in excelTop 10 steps you should do to be a successful planning engineer. Read more ... », it is Splitting the cells above and right to your active cell, in the below figure you can see the i clicked split while the active cell was K4 so the excel split the worksheet into 4 areas, above and right to the active cell.Advertisement
To unfreeze, follow the same steps, but select Unfreeze Panes.
2- Locking Rows and Columns by Freezing Panes:
When you Freezing Panes in Excel , you select rows and columns that remain visible when you scroll in the worksheet. You freeze panes to keep row and column labels visible as you scroll through.
To freeze rows or columns, go to the View tab and click Freeze Panes in the Window group.
See This Excel Tutorial Video for more practices: