WebMay 31, 2024 · To freeze rows: Select the row below the rows you want frozen. For example, if you want rows 1 and 2 to always appear at the top of the worksheet even as you scroll, then select row 3. …. Click the View tab. Click the Freeze Panes command. …. Select Freeze Panes. …. A black line appears below the rows that are frozen in place. WebTo 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 row...
Freeze panes to lock the first row or column - Microsoft Support
WebOct 3, 2024 · In your spreadsheet, select the row below the rows that you want to freeze. For example, if you want to freeze the first three rows, select the fourth row. From Excel’s … WebFreeze rows or columns Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes. greensboro nc luxury apts
3 Simple Ways to Freeze and Unfreeze Panes in Excel
WebJun 20, 2024 · To 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 Excel WebUnfreeze locked panes. You're scrolling down your worksheet (or scrolling to the side), but part of it is frozen in place. This is probably because at some point you decided to freeze … WebGo to the View tab. Under the View tab, select the Freeze Panes option. The Freeze Panes drop-down panel will appear as shown. From this panel, select the Freeze Top Row option. Scroll down, and you will see that the top row is now frozen. As you scroll down, the top row will remain in place and in view. greensboro nc main post office