In MS-Excel _______ option can be used to keep the desired rows and columns visible while the rest of the sheet scrolls.

Question

Accepted Answer

The correct option is (3):
The feature in MS-Excel explicitly designed to keep certain rows, columns, or both visible while navigating a large worksheet is called **Freeze Panes**. This tool, typically found under the View tab, is invaluable when working with extensive datasets that extend beyond the screen boundaries. When the top row (containing headers) and/or the first column (containing labels) are frozen, they are essentially locked into place. This ensures that as you scroll down to view thousands of data rows or scroll across to examine many columns, the crucial context provided by the titles or identifiers is never lost, significantly improving data readability and analysis efficiency.

The incorrect option is (1):
Headings, in the context of an Excel sheet, refer to the alphanumeric labels—the column letters (A, B, C, etc.) and the row numbers (1, 2, 3, etc.)—that define the cell addresses. While these are always visible and do not scroll off the screen, they are intrinsic parts of the Excel interface, not a user-definable option for fixing *data* rows or columns. They serve as coordinates for the cells themselves, unlike the Freeze Panes feature which locks the actual data content within cells. Therefore, 'Headings' does not describe the option used to keep data content visible while scrolling the rest of the sheet.

The incorrect option is (2):
The Watch Window is a powerful auditing feature located in the Formulas tab of the Excel ribbon. Its primary purpose is to allow a user to monitor the values of specific cells or the results of formulas in a separate, movable, and non-scrolling window. This is especially useful for troubleshooting complex formulas or observing changes in a distant part of the worksheet. However, the Watch Window’s function is strictly for viewing cell values and does not alter the fundamental scrolling mechanics of the main worksheet area, which is what the question asks for.

The incorrect option is (4):
Print Titles is a command that controls how a worksheet is presented when printed, not how it is viewed on the screen. This option allows the user to designate specific rows or columns to be repeated at the top or left side of every single page when the worksheet is printed. It ensures that every physical page has the necessary headers or labels for identification. Crucially, this setting is only applied when the print command is executed and has absolutely no effect on the display or scrolling behavior of the worksheet in the live Excel environment.