To keep headings in view, you can freeze both rows and columns with the ________ feature.

To keep headings in view, you can freeze both rows and columns with the ________ feature.

• A. Freeze Panes
• B. Split
• C. Hide
• D. Group

Answer: (A)

Maintaining visibility of headings while you scroll is achieved with Freeze Panes. This feature locks the selected rows and columns so they stay visible as you navigate the rest of the worksheet. To keep both a header row and a header column in view, place the cursor at the cell that is below the rows you want frozen and to the right of the columns you want frozen, then apply Freeze Panes. The rows above and the columns to the left remain fixed while the rest of the sheet scrolls. The other options don’t lock part of the sheet in place: Split only divides the window, Hide removes data from view, and Group collapses sections. Therefore Freeze Panes is the right choice to keep headings in view.

Maintaining visibility of headings while you scroll is achieved with Freeze Panes. This feature locks the selected rows and columns so they stay visible as you navigate the rest of the worksheet. To keep both a header row and a header column in view, place the cursor at the cell that is below the rows you want frozen and to the right of the columns you want frozen, then apply Freeze Panes. The rows above and the columns to the left remain fixed while the rest of the sheet scrolls. The other options don’t lock part of the sheet in place: Split only divides the window, Hide removes data from view, and Group collapses sections. Therefore Freeze Panes is the right choice to keep headings in view.