USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
|
|
Freeze
|
|
|
Split
|
|
|
Page Break
|
|
|
Hide
|
Explanation:
Detailed explanation-1: -On the View tab, in the Window group, click the arrow below Freeze Panes. time, click Freeze Panes. Unfreeze Panes so that you can unlock any frozen rows or columns. freeze rows and columns in the middle of the worksheet.
Detailed explanation-2: -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-3: -To fix this, click View > Window > Unfreeze Panes.
There is 1 question to complete.