What happens when you freeze panes in a spreadsheet ?
2023
What happens when you freeze panes in a spreadsheet ?
- A.
The worksheet locks and cannot be edited
- B.
The spreadsheet automatically saves changes
- C.
Specific rows or columns remain visible while scrolling
- D.
Data formatting is removed
Attempted by 31 students.
Show answer & explanation
Correct answer: C
When working with large datasets in spreadsheet applications like Microsoft Excel or Google Sheets, scrolling down or across often hides the header rows or descriptive columns.
Freeze Panes is a feature designed to lock specific rows (usually the top headers) or columns (usually the leftmost labels) in place.
Once frozen, these specific rows or columns remain visible at all times on the screen while you scroll through the rest of the worksheet. This helps you keep track of what data belongs to which header without losing context.