Question

Jim maintains attendance records for his employees for the year. Row B includes the dates of attendance, and column A includes the names of the employees. He wants to lock row B so that he can scroll the entire worksheet but keep row B visible. Which option should he use

Answer 1

The answer is Freeze Planes.

Answer 2

To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes. To lock multiple columns, select the column to the right of the last column you want frozen, choose the View tab, and then click Freeze Panes.