USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The quickest and easiest way to reorder or move a worksheet in Excel is to:
|
|
Right-click the worksheet tab
|
|
|
Drag the worksheet tab
|
|
|
Use the ribbon at the top of the screen
|
|
|
Start a new workbook
|
Explanation:
Detailed explanation-1: -Hold down OPTION. Drag the sheet tab to the location that you want the copied sheet to appear along the row of sheet tabs. Important: Release the mouse button before you release the OPTION key.
Detailed explanation-2: -You can move a sheet to a different position, click and hold the sheet tab at the bottom of the screen with the mouse and drag it to its new position. select Edit → Sheet → Move/Copy from the main menu. Specify the new position of the sheet in the dialog.
Detailed explanation-3: -Moving a Worksheet Click the sheet tab you want to move. While holding down the mouse button, drag the sheet tab to its new location.
There is 1 question to complete.