Excel. Lock A Row. In our example, we want to freeze rows 1 to 8. Select the row below, the rows we want to freeze.
How to lock Excel 2007 Header Row YouTube
Web lock only specific cells and ranges in a protected worksheet. So, we’ll select row 9. Select the row below, the rows we want to freeze. 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,. On the review tab, select unprotect sheet (in the protect group). Click the view tab on the ribbon. In the menu, click view. 3. 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. If the worksheet is protected, do the following: Web freeze panes to lock rows and 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. Tap view > freeze panes, and then tap the option you need. On the review tab, select unprotect sheet (in the protect group). If the worksheet is protected, do the following: Select the row below, the rows we want to freeze. In the menu, click view. 3. Web freeze panes to lock rows and columns. Scroll your spreadsheet until the row you want to lock in place is the first row visible under the row of letters. Web lock only specific cells and ranges in a protected worksheet. So, we’ll select row 9. In our example, we want to freeze rows 1 to 8.
