Freeze Panes and Split

In this lesson you can learn how to freeze panes and how to split spreadseet.

You can use it, when you want to work in Excel with big data bases in your worksheet easier. You can do something like that:

Excel Splited

Let's see, how to do it.

You have quite a large table that does not fit in the Excel. For this reason, you do not see headers and it is hard you work. The table in this form is completely unreadable, but you can easily fix it.

Freeze Panes

Freezing Panes is that when scrolling the window of the table is in the same place. For example, you can block row or heading of the table so as to still have them on top. You know then, which means the data cell. In the picture you can't to see that. I will teach you to freeze row and column headers at the same time. Select the cell that is under the blocked column and the right of the frozen line. Typically, this is cell B2.

Excel Freeze Panes

Go to the ribbon. Choose View - Freeze Pane

Excel Freeze Panes Ribbon

Worksheet is frozen. Now, moving a table, row and column header will always be visible.

Excel Freeze Panes row and column

Worksheet Split

Another situation is when you haven't got enough space in the Worksheet. For example you need to have access to different parts of the sheet simultaneously. To avoid continuous scrolling, let's split it. In order to split the window in Excel, first select one of the cells. Then go to the ribbon according to the path: View - Split

Excel Split

The screen was divided into four parts, which you can scroll independently! This is a great convenience in working with large data sheets.

Excel Splited Worksheet