howto.org.in

How to Lock Row in Excel

Learn how to lock a row in Excel with Freeze Panes, keep headers visible, avoid mistakes, troubleshoot, and understand protection vs freezing.

TechnologyEdited by Pramod Tiwari
2 min read

Quick Answer

To lock a row in Excel so it stays visible, select the row below the one you want frozen, go to View > Freeze Panes, and choose Freeze Panes or Freeze Top Row.

What You Need

  • Microsoft Excel workbook
  • Header row or row to keep visible
  • View tab access
  • Worksheet not in incompatible view

Safety Precautions

  • Freeze Panes keeps rows visible but does not protect them from editing.
  • Use Protect Sheet if you need to prevent changes.
  • Select the correct row before freezing panes.
  • Unfreeze panes before changing the layout if needed.
  • Save before major formatting changes.

Step-by-Step Instructions

  1. Step 1

    Open worksheet

    Go to the sheet with the row you want to keep visible.

  2. Step 2

    Choose simple top row option

    If row 1 is the header, use View > Freeze Panes > Freeze Top Row.

  3. Step 3

    Select row below

    For another row, select the row directly below the row you want frozen.

  4. Step 4

    Open View tab

    Click View on the Excel ribbon.

  5. Step 5

    Choose Freeze Panes

    Select Freeze Panes from the menu.

  6. Step 6

    Scroll to test

    Scroll down and confirm the row stays visible.

  7. Step 7

    Unfreeze if needed

    Use View > Freeze Panes > Unfreeze Panes to remove it.

Practical Example

Example: To keep row 1 headers visible, you choose View > Freeze Panes > Freeze Top Row, then scroll down the sheet.

Common Mistakes

  • Confusing freeze with sheet protection
  • Selecting the row to freeze instead of the row below
  • Forgetting panes are already frozen
  • Trying in page layout view
  • Freezing the wrong sheet
  • Expecting printed headers to repeat automatically

Troubleshooting

Wrong row is frozen

Unfreeze panes, select the correct row below the target, and freeze again.

Freeze option is unavailable

Check workbook view, editing mode, and whether the sheet is protected.

Rows freeze but print does not repeat

Use Page Layout > Print Titles for printed headers.

Need to lock cells from editing

Use Protect Sheet, not Freeze Panes.

FAQs

Is locking a row the same as freezing a row?

People often mean freezing a row for visibility; protection is different.

How do I freeze the top row?

Use View > Freeze Panes > Freeze Top Row.

Can I freeze rows and columns?

Yes, select the cell below and to the right of what you want frozen.

How do I undo it?

Use View > Freeze Panes > Unfreeze Panes.

Education2 min read

How to Learn Math

Learn how to learn math with foundations, examples, practice, mistake review, problem-solving habits, troubleshooting, and FAQs.

Help us improve this guide

Tell us about an outdated instruction, unclear step, broken link or safety concern. Do not include passwords, account numbers, medical records or other sensitive information.

Email a correction or suggestion