Top rows and left column of Excel spread sheet can be protected from scrolling using

Freeze panes

Freeze sheet

Freeze cells

Freeze lows

To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes.
To freeze the top row or first column:
From the View tab, Windows Group, click the Freeze Panes drop down arrow.
Select either Freeze Top Row or Freeze First Column.
Excel inserts a thin line to show you where the frozen pane begins.

Strengthen Your Practice with our comprehensive question bank.

Get Expert Advice for Free: Register for Your Free Consultation Now!

Full Name

Phone Number

Select Language

Select Course

Please leave this field empty.