I will teach you to freeze header row and first column at the same time. You know then, which means the data cell. For example, you can block top row or first column of the table so to still have them visible. Freeze Panesįreezing Panes is that when scrolling the window of the table is in the same place. The table in this form is completely unreadable, but you can easily fix it. For this reason, you do not see headers and it is hard you work. You have quite a large table that does not fit in the Excel. You can use it, when you want to work in Excel with big data bases in your worksheet easier. In this lesson, you can learn how to freeze panes and how to split spreadseet. In Excel, you can freeze panes to keep the headings visible while you scroll through the data, and split the worksheet into separate panes to view different parts of the worksheet at the same time. This option is especially useful if your data set grows vertically.How to Freeze Panes and Split in Excel Details As the name suggests, this option locks the entire first row. The second Freeze Panes option is Freeze Top Row. This action allows you to see the first row and the column A, even when scrolling both ways. For example, to freeze both the first row and the first column, select the cell B2 and click on Freeze Panes. The first option, Freeze Panes, locks both rows and columns up to the selected cell. Freeze Panesįirst of all, all freezing options are listed under the Freeze Panes icon from the Window section of the View tab in the Ribbon. Let's see how you can apply these three variations on your worksheet. Freezing both rows and columns, based on selectionĪ quick reminder here: Freezing applies only to the active worksheet and you need to define this separately for each worksheet.In this guide, we are going to show you how to freeze panes in Excel (rows and columns) using three different methods. Excel's Freeze Panes feature allows you to lock a number of rows and/or columns and make it easier to navigate other parts of your workbook and the frozen sections will remain visible as you scroll through. If you are working with a huge data, it can be difficult to recognize which cell is under which column or row.

Can39t freeze panes excel