How to lock row in excel

Answer

To lock a row in Excel, you use the Freeze Panes feature. This allows a row to remain visible while scrolling through the rest of the worksheet.

Steps to Lock the Top Row

1. Open your Excel worksheet.

2. Click on the View tab in the ribbon.

3. In the Window group, click Freeze Panes.

4. Select Freeze Top Row from the dropdown menu.

5. The top row will now remain visible while you scroll through other rows.

Steps to Lock a Specific Row

1. Click the row number below the row you want to lock.

2. Go to the View tab.

3. Click Freeze Panes in the Window group.

4. Select Freeze Panes from the dropdown.

5. All rows above the selected row will now remain locked while scrolling.

Notes

• Freezing the top row is most common when you have headers for columns.

• You can lock multiple rows by selecting the first row below the rows you want to lock.

• To unfreeze rows, go to View → Freeze Panes → Unfreeze Panes.

This method works similarly on both Windows and Mac versions of Excel. On Mac, the View tab may appear slightly different, but the Freeze Panes options are the same.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report