How to Freeze and Split Panes in MS Excel Worksheet?

Freeze Panes and Split Panes are useful features in Microsoft Excel that allow you to keep specific rows or columns visible while scrolling through a large dataset.

With Freeze Panes, you can keep a specific row or column in view while scrolling through the rest of the worksheet. To do this, select the row below the rows you want to freeze or the column to the right of the columns you want to freeze. Then, go to the View tab and click on Freeze Panes.

Split Panes, on the other hand, allow you to divide the worksheet into multiple panes, each with its own set of frozen rows and columns. This can be helpful when you need to compare or reference data in different parts of the worksheet. To split the panes, place your cursor where you want to split the worksheet and go to the View tab and click Split.

Both Freeze and Split Panes can be useful in managing and analyzing large datasets in Microsoft Excel, and they can save you a lot of time and effort in scrolling through and searching for specific information.

Freeze Panes in Excel

Freeze Pane:  Freeze Pane option keeps rows and columns visible while the rest of the worksheet can be scrolled to view or fill in the data.

Freeze Top Row: If you freeze the top row, the top row will be visible every time while scrolling through the rest of the worksheet.

Freeze First Column: If you freeze the first column, the first column will always be visible while scrolling through the worksheet.

Split Panes in Excel

Split is different from than Freeze panes feature in MS Excel. The splitting option divides the window into different panes, and each can be scrolled separately.

In this article, we will go through the following Freeze and Split options:-

  1. Freeze a single row and column
  2. Freeze multiple rows and columns
  3. Unfreeze all rows and columns
  4. Split windows vertically and horizontally
  5. Remove Split in Excel

How to freeze a single row and column in Excel?

To freeze a single row or column, open the Excel Workbook, click on the View tab, select Freeze Panes, and then click Freeze Top Row.

Once the above steps are completed, while scrolling through the worksheet, you will notice the first row is not disappearing.

If, instead of a top row, you want to freeze any other row according to your choice, select the Row, click on the View tab, and select Freeze Panes.

Once the above steps are completed, while scrolling, you will notice the rows above the frozen row will be visible, while others will be hiding during the scroll.

How to freeze multiple rows and columns in Excel?

To Freeze multiple rows or columns in an Excel Worksheet, select the rows or columns you want to freeze by clicking the heading of the row or column (To select multiple rows and columns in Excel, press and hold the Ctrl key from the keyboard and then keep clicking on rows and columns which you want to select).

Once you have selected the desired rows and columns, click the View tab, select Freeze Panes, and select the Freeze Panes in the drop-down menu.

How to unfreeze all rows and columns in Excel?

To unfreeze all rows and columns in one go, click the View tab and select Freeze Panes; click the Unfreeze Panes from the drop-down menu.

How to split windows vertically and horizontally in Excel?

To split Excel. Click a row or column heading, and select Split on the View tab. Once the worksheet is split, you will notice a Thick Grey Line in the worksheet; drag this line to where you want to split in the window.

How to remove Split in Excel?

To remove the Split from the Excel worksheet, click on the View tab and select the Split option.

That’s all!!! I hope you have learned to Freeze and Split Panes in MS Excel Worksheet.

Conclusion

In conclusion, Freeze and Split Panes are two powerful features in Microsoft Excel that can make working with large datasets more manageable and efficient. By freezing specific rows or columns, you can keep them in view while scrolling through the rest of the worksheet. And by splitting the worksheet into multiple panes, each with its own set of frozen rows and columns, you can easily compare or reference data in different parts of the worksheet. Knowing how to use these features can save you a lot of time and effort and help you work more effectively with Excel.

Leave a Reply