As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Lock Rows in Excel: Step-by-Step Guide

In Microsoft Excel, locking rows can be beneficial to keep specific information visible while scrolling through a large worksheet. Follow this step-by-step guide to learn how to lock rows in Excel.

How to Lock Rows in Excel:

  1. Select the Row or Rows to Lock:
  2. Click on the row number(s) on the left side of the worksheet to select the row(s) you want to lock.
  3. Enable Row Locking:
  4. Navigate to the View tab on the Excel ribbon.
  5. Click on the Freeze Panes drop-down menu in the Window group.
  6. Choose Lock Top Row from the drop-down menu.
  7. The selected row(s) will now be locked, remaining visible while scrolling through the worksheet.

How to Unlock Rows in Excel:

  1. Unlock Rows:
  2. Click on the View tab.
  3. Open the Freeze Panes drop-down menu.
  4. Choose Unlock Top Row.
  5. The previously locked row(s) will now be unlocked and scroll as you navigate through the worksheet.

How to Lock Multiple Rows in Excel:

  1. Select the Rows to Lock:
  2. Click on the row number of the first row you want to lock.
  3. Drag your mouse down to select multiple rows.
  4. Enable Row Locking:
  5. Follow the steps mentioned above for enabling row locking.
  6. The selected rows will remain visible while scrolling through the worksheet.

How to Lock a Row and Column in Excel:

  1. Select the Cell in the Upper-Left Corner:
  2. Click on the cell that intersects the row and column you want to lock.
  3. Enable Row and Column Locking:
  4. Follow the steps mentioned above for enabling both row and column locking.
  5. The selected row and column will be locked, staying visible during scrolling.

How to Lock a Row and Multiple Columns in Excel:

  1. Select the Cell in the Upper-Left Corner:
  2. Click on the cell that intersects the row and the first column to be locked.
  3. Enable Row Locking:
  4. Follow the steps mentioned above for enabling row locking.
  5. The selected row and columns will be locked, remaining visible during scrolling.

How to Lock Multiple Rows and Columns in Excel:

  1. Select the Cell in the Upper-Left Corner:
  2. Click on the cell that intersects the first row and the first column to be locked.
  3. Enable Row and Column Locking:
  4. Follow the steps mentioned above for enabling both row and column locking.
  5. The selected rows and columns will be locked, staying visible while scrolling through the worksheet.

By following these steps, you can efficiently lock and unlock rows in Excel based on your specific needs.