USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How would sheet tabs be moved to a new position in the workbook?
|
|
Choose Move on the Home Ribbon
|
|
|
Click and drag the sheet tab to the new location
|
|
|
Choose Move on the Insert Ribbon
|
|
|
Choose Relocate on the Quick Access Toolbar
|
Explanation:
Detailed explanation-1: -Press CTRL and drag the worksheet tab to the tab location you want.
Detailed explanation-2: -Tip: You can also right-click the selected sheet tabs, and then click Insert. On the General tab, click Worksheet, and then click OK. To change the order of the worksheets in a workbook, click the tab of the worksheet that you want to move, and then drag it to the location that you want.
Detailed explanation-3: -To move a sheet(s) in Excel, you simply select one or more tabs and drag them to a new location. To move a sheet to another workbook, place the workbooks side-by-side (View tab > View Side by Side) and then drag the sheet from one file to another.
There is 1 question to complete.