WebMar 17, 2015 · Check out the video above, or follow these steps: Go to the View tab. To freeze or lock your top row, click the Freeze Panes icon in the ribbon and select Freeze Top Row. To freeze or lock your first column, … WebOct 31, 2024 · You basically have to toggle back and forth. Is there a way to freeze both at the same time? yes, click the cell where you want both top and side to freeze, example: click cell b3, then click freeze panes, then it will freeze the top and side panes 60 people found this reply helpful · Was this reply helpful? Yes

Freeze panes to lock rows and columns - Microsoft Support

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... WebSelect the row below the row (s) you want to freeze (select row 6, if you want to freeze rows 1 to 5). On the View tab, click Freeze Panes > Freeze Panes. bira white pint

How to Freeze Row and Column Headings in Excel Worksheets

WebIf you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and … WebScroll your spreadsheet until the row you want to lock in place is the first row visible under the row of letters. 2. In the menu, click "View." 3. In the ribbon, click "Freeze Panes" and then ... 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. bira white price in gurgaon