How to Freeze and Split Panes in MS Excel Worksheet?

Microsoft Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications. Microsoft Excel enables users to format, organize and calculate data in a spreadsheet. It is a spreadsheet program containing several columns and rows, where each intersection of a column and a row is a “cell.” Each cell has one point of data or one piece of information.

Here, you can easily find the Microsoft Office program in every workplace. A few of us also use the Microsoft Office program on our home PC to educate our children or store critical data. Because of its easiness of storing and calculating the data, we call it a “mini database.”

So, if you have already worked in the Microsoft Excel program, you may be aware of Freeze and Split Panes options. These two options help a lot while working on Excel. It lets you focus on your work without distracting through entire columns and rows. Freezing and Splitting screens is a method that makes navigation and viewing between pages more manageable.

Freeze Panes in Excel

Freeze Pane: It keeps rows and columns visible while the rest of the worksheet scrolls (based on the current selection).

Freeze Top Row: Keep the top row visible while scrolling through the rest of the worksheet.

Freeze First Column: Keep the first column visible while scrolling through the worksheet.

Split Panes in Excel

Split is different from than Freeze panes feature in MS Excel. It divides the window into separate panes that each scrolls separately.

In this risewindows 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?

First, click on the View tab to freeze a single row or column and open the Excel Workbook. Then, select Freeze Panes. After that, click Freeze Top Row.

After completing the above steps, you will notice that the first row is not disappearing while scrolling through the worksheet.

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.

After completing the above steps, 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?

Now, select the rows or columns you want to freeze to Freeze multiple rows or columns in an Excel Worksheet by clicking the heading of the row or column (To select multiple rows and columns in Excel. Then, 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, choose Freeze Panes, and select the Freeze Panes in the drop-down menu.

How to unfreeze all rows and columns in Excel?

Here, click the View tab and select Freeze Panes to unfreeze all rows and columns in one go; 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 break in the window.

How to remove Split in Excel?

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

That’s it for the article.

I hope this article will be informative to you.

Good luck & keep reading, guys.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: