If you work with large spreadsheets in Microsoft Excel, you may find it helpful to keep certain rows or columns visible while you scroll through the rest of the sheet. This is called "freezing" panes. Freezing panes can be especially helpful if your sheet contains column headers (titles) or if you need to see which row you're working on while scrolling through a large sheet. In this article, we'll show you how to freeze panes in Excel so you can keep your place while scrolling. Show
Before we get started, it's important to note that you can only freeze panes in an Excel worksheet, not in a workbook (a collection of worksheets). How to Freeze Panes in ExcelThere are two ways to freeze panes in Excel:
Let's take a look at how to freeze panes in Excel. How to Freeze Rows or Columns in ExcelTo freeze rows or columns so that they're always visible when you scroll, follow these steps:
Now when you scroll down, the top row will remain visible. And when you scroll to the right, the left column will remain visible. How to Use Split Panes to Freeze Rows and Columns in ExcelIf you want to keep multiple rows or columns visible as you scroll, you can use the split panes feature instead of freezing panes. To split panes in Excel, follow these steps:
Now you can scroll through each pane of your worksheet independently. To remove split panes, follow these steps:
Tips for Using Freeze Panes and Split Panes in ExcelNow that you know how to freeze panes and split panes in Excel, here are a few tips to keep in mind:
ConclusionWe hope this article has helped you learn how to freeze panes and split panes in Excel. If you have any questions or comments, please let us know in the comments section below. And be sure to check out our other Excel articles for more tips and tricks. The tutorial shows how to freeze cells in Excel to keep them visible while you navigate to another area of the worksheet. Below you will find the detailed steps on how to lock a row or multiple rows, freeze one or more columns, or freeze column and row at once. When working with large datasets in Excel, you may often want to lock certain rows or columns so that you can view their contents while scrolling to another area of the worksheet. This can be easily done by using the Freeze Panes command and a few other features of Excel. How to freeze rows in ExcelFreezing rows in Excel is a few clicks thing. You just click View tab > Freeze Panes and choose one of the following options, depending on how many rows you wish to lock:
The detailed guidelines follow below. How to freeze top row in ExcelTo lock top row in Excel, go to the View tab, Window group, and click Freeze Panes > Freeze Top Row. This will lock the very first row in your worksheet so that it remains visible when you navigate through the rest of your worksheet. You can determine that the top row is frozen by a grey line below it: How to freeze multiple rows in ExcelIn case you want to lock several rows (starting with row 1), carry out these steps:
For example, to freeze top two rows in Excel, we select cell A3 or the entire row 3, and click Freeze Panes: As the result, you'll be able to scroll through the sheet content while continuing to view the frozen cells in the first two rows: Notes:
How to freeze columns in ExcelFreezing columns in Excel is done similarly by using the Freeze Panes commands. How to lock the first columnTo freeze the first column in a sheet, click View tab > Freeze Panes > Freeze First Column. This will make the leftmost column visible at all times while you scroll to the right. How to freeze multiple columns in ExcelIn case you want to freeze more than one column, this is what you need to do:
For example, to freeze the first two columns, select the whole column C or cell C1, and click Freeze Panes: This will lock the first two columns in place, as indicated by the thicker and darker border, enabling you to view the cells in frozen columns as you move across the worksheet: Notes:
How to freeze rows and columns in ExcelBesides locking columns and rows separately, Microsoft Excel lets you freeze both rows and columns at the same time. Here's how:
Yep, it's that easy :) For example, to freeze top
row and first column in a single step, select cell B2 and click Freeze Panes: This way, the header row and leftmost column of your table will always be viewable as you scroll down and to the right: In the same fashion, you can freeze as many rows and columns as you want as long as you start with the top row and leftmost column. For instance, to lock top row and the first 2 columns, you select cell C2; to freeze the first two rows and the first two columns, you select C3, and so on. How to unlock rows and columns in ExcelTo unlock frozen rows and/or columns, go to the View tab, Window group, and click Freeze Panes > Unfreeze Panes. Freeze Panes not workingIf the Freeze Panes button is disabled (greyed out) in your worksheet, most likely it's because of the following reasons:
Other ways to lock columns and rows in ExcelApart from freezing panes, Microsoft Excel provides a few more ways to lock certain areas of a sheet. Split panes instead of freezing panesAnother way to freeze cells in Excel is to split a worksheet area into several parts. The difference is as follows: Freezing panes allows you to keep certain rows or/and columns visible when scrolling across the worksheet. Splitting panes divides the Excel window into two or four areas that can be
scrolled separately. When you scroll within one area, the cells in the other area(s) remain fixed. To split Excel's window, select a cell below the row or to the right of the column where you want the split, and click the Split button on the View tab > Window group. To undo a split, click the Split button again. Use tables to lock top row in ExcelIf you'd like the header row to always stay fixed at the top while you scroll down, convert a range to a fully-functional Excel table: The fastest way to create a table in Excel is by pressing the Ctl + T shortcut. For more information, please see How to make a table in Excel. Print header rows on every pageIn case you'd like to repeat top row or rows on every printed page, switch to the Page Layout tab, Page Setup group, click the Print Titles button, go to the Sheet tab, and select Rows to repeat at top. The detailed instructions can be found here: Print row and column headers on every page. That's how you can lock a row in Excel, freeze a column, or freeze both rows and columns at a time. I thank you for reading and hope to see you on our blog next week! You may also be interested inWhich option keeps a portion of the sheet visible while the rest of the sheet scrolls?To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
What feature of Excel keeps a portion of a worksheet visible while the other portion Scrolls?When you freeze panes, Excel keeps specific rows or columns visible when you scroll in the worksheet. For example, if the first row in your spreadsheet contains labels, you might freeze that row to make sure that the column labels remain visible as you scroll down in your spreadsheet.
How do you keep cells visible in sheets?Freeze or unfreeze rows or columns. On your computer, open a spreadsheet in Google Sheets.. Select a row or column you want to freeze or unfreeze.. At the top, click View. Freeze.. Select how many rows or columns to freeze.. |