Freeze multiple panes in excel
Because data sets can extend to thousands of rows and columns, the zoom function is a helpful way of getting a bird's eye view of your full data sheet. We'll finish up this lesson by introducing the Excel zoom function. So if you're going to use these commands, be sure to unfreeze all panes before doing so. Unfortunately, screen splits don't work with frozen panes. To remove a split, just repeat the shortcut, Alt + W + S. I tend to stick with a horizontal split most of the time. However, I don't find these splits nearly as useful. You can also perform vertical splits by selecting a cell in the column to the right of column A. So I can see the bottom five rows of the data set, just what I wanted.
And so I'll press S.īecause I'm in cell A12, the split will happen above this row. If I go to the View tab with Alt + W, I can now find the split command here. Select the cell where you want to place the split box, I'll go to cell A12, and then press the required shortcut.
Split boxes work exactly the same way as freezing panes. One nice way to complete this task is using a split box. Sometimes, we'd like to compare two parts of the data set at the same time, but unfortunately, they don't appear on the same screen, say the first five rows and the last five rows of our data set. Let's remove these panes again with Alt + W + F + F. In actual fact, it can get quite confusing. We simply navigate to this cell, for example, and enter Alt + W + F + F.īut as you can see as we scroll down the page, this doesn't make a huge amount of sense when we're freezing data entries. It's also possible to freeze multiple columns and multiple rows. If we wanted to freeze the first column and not the row, we would freeze cell B1. If we only want to freeze the top row and not the column, we would freeze panes on cell A2. To unfreeze panes, we simply use the same shortcut command we used earlier, Alt + W + F + F, and that removes our panes from the data set. On worksheets with a lot of columns, for example, financial models, freezing panes can save you a lot of time scrolling back and forth across the page. If I scroll across the page, the order number column also stays in place. As we move down the dataset, the subject heading stays in place, exactly what we want, and making our data set much easier to read. Now let's see what happens when we scroll down the page. So to do this, I'll select cell B2, and then I'll use the shortcut Alt + W + F + F.Īfter freezing panes, you can see black lines appear on this spreadsheet that show you where the panes are now in place. I would like to freeze the top row and the first column. Where the pane freezes is determined by the currently selected cell.Īny row above this selected cell and any column to the left of this selected cell will be frozen. And to do this, we'll need to use a command called freeze panes. It would be nice if we could keep all the column headings on the page at all times. As you can see, if I navigate to the bottom of my data set, we can no longer see the column headings at the top of the page. In most data sets, we typically have more row entries that can fit on one screen.
#Freeze multiple panes in excel how to
In this lesson, we'll learn how to use the freeze panes, split boxes, and zoom tools. In the previous lesson, we learned how to adjust the size of rows and columns in sheets.