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

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

A

Freeze panes

B

Freeze sheet

C

Freeze cells

D

Freeze lows

Solution:

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.

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

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

Full Name

Phone Number

Select Language

Select Course

Select Course

Select Course

Select Course

Select Course

Please leave this field empty.