How To Lock A Row In Excel When Scrolling. Web freeze rows or columns. Select the row just below the row that you want to lock.
How to lock header row in Excel? HiTech Service
Look for the 'window' group within the 'view' tab. Web in the ribbon, click freeze panes and then click freeze top row. click freeze top row to lock the top visible row. How to lock a row in excel for scrolling. Select view > freeze panes >. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Web freeze rows or columns. Web if 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. Click on the 'freeze panes' option. Now, when you scroll through the spreadsheet, the top row that was visible. Go to the 'view' tab on the excel ribbon.
Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Look for the 'window' group within the 'view' tab. Select view > freeze panes >. Tap view > freeze panes, and then tap the option you need. Or, select the column immediately right to the column that you want to lock. Go to the 'view' tab on the excel ribbon. Web in the ribbon, click freeze panes and then click freeze top row. click freeze top row to lock the top visible row. Select the row just below the row that you want to lock. Click on the 'freeze panes' option. Web freeze rows or columns. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.