USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The entire contents of the column must be visible.
|
|
|
The first row of the column must be non-blank.
|
|
|
Duplicate worksheets must also be able to have their first columns frozen.
|
|
|
You can click Freeze First Column in the Freeze Panes menu.
|
Detailed explanation-1: -If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need.
Detailed explanation-2: -Select View > Freeze Panes > Freeze First Column.
Detailed explanation-3: -If you select the Freeze First Column command, it does not automatically freeze Column A on the worksheet. After freezing the first column: The frozen column stays in place if you scroll left or right on the worksheet. If the frozen column has other columns to the left of it, you can’t scroll left to see those columns.
Detailed explanation-4: -Freeze top row Keeps only the top row visible as you scroll through a worksheet. Freeze First Column Keeps only the first column visible as you scroll through a worksheet. To freeze one or more rows and columns, use the Freeze Panes option.