![can you freeze multiple panes in excel 2010 can you freeze multiple panes in excel 2010](https://www.wallstreetmojo.com/wp-content/uploads/2019/02/Freeze-Columns-Example-4.png)
Split panes to lock rows or columns in separate worksheet areas.Freeze panes to keep headers in site (video for Excel 2010).Freeze panes to lock the first row or column (how-to).
#Can you freeze multiple panes in excel 2010 how to
Note: if you'd rather read how to do it rather than watch the video, here are links to the resources Dave demonstrates: Other tips that let you see and work with data more easily.The difference between freezing panes, locking cells, and splitting the window.How to freeze & unfreeze rows and columns.These actions freeze the first row and first column in place. From the dropdown that appears, select the first option, Freeze Panes. Now, from the view options, select Freeze Panes. In our example, since we want the first two rows locked, we have to select row number 3 (row below the one we want to be frozen) and then go to View Freeze.
![can you freeze multiple panes in excel 2010 can you freeze multiple panes in excel 2010](https://www.live2tech.com/wp-content/uploads/2019/06/how-to-freeze-row-excel-2.jpg)
Take 15-minutes to watch this demo to learn. To freeze the first row and first column, we need to perform the following steps: Select Cell B2 from the worksheet. To freeze (or to lock) multiple rows (starting with row 1), you have to select the row below the last row you want frozen, and then use the option Freeze Panes. This is great when you have a spreadsheet with enough data that you have to do a lot of scrolling to see all the cells, then lose track of the headers that label the columns. This is in the middle of the other two freeze options. This step lets you view your column and row headings continuously while you scroll your document. If you want to freeze a specific row or just a specific column, you can go to the View tab in the Ribbon. When you freeze a row or column, you are actually splitting the screen into one or more panes (window sections) and freezing one of the panes. Once you open the Freeze Panes drop-down menu, choose Freeze Top Row. When you freeze a pane on an Excel spreadsheet, you're keeping a row or a column still while the rest of the cells below it can scroll freely. If you want to freeze both rows and columns, you need to freeze them at the same time. For example, if you freeze row 1 and then decide to freeze column A, row 1 will no longer be frozen. It must be the wintery weather - my mind is on freezing things. You can choose to freeze just the top row of your worksheet, just the left column of your worksheet, or multiple rows and columns simultaneously.