Splitting and Locking Rows and Columns by Freezing Panes in Excel 2010

Splitting and Locking Rows and Columns by Freezing Panes in Excel 2010

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 excelCreate Gantt Chart and cash flow using excel with sample file. Read more ... » sheet, 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 2010Track Changes in Excel 2010. Read more ... »

1- Splitting Panes:

When you splitHow to split activities in Primavera P6.. Read more ... » 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 excel, 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.

Splitting Panes in excel 2010

Splitting Panes in excel 2010

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.

Freezing Panes in excel 2010

Freezing Panes in excel 2010


See This Excel TutorialExcel Gantt chart by excel: Step by Step Guide Tutorial. Read more ... » Video for more practices:

[embedplusvideo height="390" width="645" standard="http://www.youtube.com/v/V7-ylTG9pLo?fs=1" vars="ytid=V7-ylTG9pLo&width=645&height=390&start=&stop=&rs=w&hd=0&autoplay=0&react=1&chapters=&notes=" id="ep7715" /]


  • Share on Social Networks

Leave a comment

Your email address will not be published.

Password Reset
Please enter your e-mail address. You will receive a new password via e-mail.