USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cut and paste
|
|
|
Copy and paste
|
|
|
Click and drag
|
|
|
Format sheet
|
Detailed explanation-1: -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-2: -On the Edit menu, click Sheet > Move or Copy Sheet. On the To book menu, click the workbook that you want to move the sheet to. Tip: To create a new workbook that contains the moved sheet, click new book. In the Before sheet box, click the sheet that you want to insert the moved sheet before, or click move to end.
Detailed explanation-3: -These keyboard shortcuts are probably the quickest and easiest way to move between sheets in Excel. Simply press CTRL + PAGE UP to move to the previous sheet, or CTRL + PAGE DOWN to move to the next sheet. You can also hold down the CTRL key and use the mouse scroll wheel to move between sheets.
Detailed explanation-4: -Press SCROLL LOCK, and then hold down CTRL while you press the LEFT ARROW or RIGHT ARROW key. Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet.
Detailed explanation-5: -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.