Which feature keeps rows or columns visible in the worksheet while you scroll?

• A. Freeze Pane
• B. Split
• C. Group
• D. Scroll Lock

Answer: (A)

When you want to keep important parts of a worksheet in view as you move around, you use freezing panes. This feature locks the selected rows or columns so they stay visible while the rest of the sheet scrolls. For example, freezing the top row keeps the column headers in sight as you scroll down, and freezing the first column keeps row labels visible as you scroll to the right. This is the classic way to maintain context in large spreadsheets.

Other options don’t fit this need. Splitting creates two or more separate panes that can scroll independently, which isn’t about fixing a row or column in place for the entire sheet. Grouping is about collapsing and expanding sections of rows or columns, not about constant visibility while scrolling. Scroll Lock is a keyboard toggle that changes how arrow keys navigate, not about keeping parts of the sheet fixed in view.