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 excel 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 2010

1- Splitting Panes:

When you split panes, you can scroll in the 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.

To unfreeze, follow the same steps, but select Unfreeze Panes.

RECOMMENDED COURSE

Data Management and Reporting

Data Management is the key success of construction projects reporting. This self-study course will teach you using a step by step case…

• 1,674 students
• WhatsApp support group
• Certificate

View course

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:

---

Keep in Touch

Join our Email Newsletters and receive FREE weekly useful content!

Your Name

Email

---

Related posts:

Build your Dream First Why Good Employees Leave? Power Point Templates for Presentations and Reporting- 50 Templates Find how to build your LinkedIn profile, target connections, and find the proper job! Human Resource Management Definitions