To lock a row in Excel, you can use the "Freeze Panes" feature. This feature allows you to lock specific rows or columns so that they remain visible as you scroll through your spreadsheet. Here's how you can do it:
1. **Open Your Excel Spreadsheet**: Open the Excel spreadsheet containing the row you want to lock.
2. **Select the Row Below the Row You Want to Lock**: Click on the row number below the row you want to lock. This selects the entire row.
3. **Freeze Panes**: Go to the "View" tab in the Excel ribbon.
4. **Click on "Freeze Panes"**: In the "Window" group, click on the "Freeze Panes" dropdown arrow.
5. **Choose "Freeze Panes"**: From the dropdown menu, select "Freeze Panes". This will freeze the selected row (and all rows above it) in place.
Now, when you scroll through your spreadsheet, the locked row will remain visible at the top of the window.
If you want to unlock the row later, simply go back to the "Freeze Panes" dropdown menu and select "Unfreeze Panes".
This method allows you to lock a specific row in Excel so that it remains visible as you navigate through your spreadsheet.