Which Excel feature allows all information above or to the left of a specified point to be kept in place during scrolling?

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

Answer: (D)

Maintaining visibility of headers or labels while you scroll through a large worksheet is achieved by freezing panes. Freeze Panes locks the rows above and the columns to the left of a chosen cell so those areas stay on screen as you move around the sheet. For example, selecting a cell like B2 and applying Freeze Panes keeps the first row and first column visible while everything below and to the right can be scrolled through.

Split creates independent scrolling areas within the same window, which isn’t the same as keeping specific rows or columns fixed. Lock Cells is a protection feature, not a scrolling behavior. Scroll Lock is a keyboard setting that affects how the arrow keys move around the sheet, not how the worksheet is displayed while scrolling. The freezing panes feature directly addresses keeping information above or to the left in view.