USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Freeze Pane
|
|
|
Split
|
|
|
Hide
|
|
|
Unhide
|
Detailed explanation-1: -You’re scrolling down your worksheet (or scrolling to the side), but part of it is frozen in place. This is probably because at some point you decided to freeze the panes. To fix this, click View > Window > Unfreeze Panes.
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: -Besides locking columns and rows separately, Microsoft Excel lets you freeze both rows and columns at the same time. Here’s how: Select a cell below the last row and to the right of the last column you’d like to freeze. On the View tab, click Freeze Panes > Freeze Panes.