USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Detailed explanation-2: -Then click the “View” tab in the Ribbon. Then click the “Split” button in the “Window” button group to split the current worksheet into four separate panes. This lets you scroll each pane to independent sections of the same worksheet. You can click the “Split” button again to remove the split panes, when finished.
Detailed explanation-3: -The Windows 10 shortcut to split windows is really useful: just press and hold the Windows key and then press either the Left or Right arrow key. This should automatically snap the active window to the left or right. Then you just select another window to fill the second empty space.
Detailed explanation-4: -You can split the window horizontally, vertically or both for up to four different panes.