USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
TRUE
|
|
|
FALSE
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Moving and copying sheets are not allowed in protected workbooks. To check if the workbook is protected, go to the Review tab > Protect group and have a look at the Protect Workbook button. If the button is highlighted, it means the workbook is protected. Click that button to unlock the workbook, and then move sheets.
Detailed explanation-2: -Move a sheet to another workbook Open the workbook that you want to move the sheet to. On the Window menu, click the workbook that contains the sheet that you want to move. Click the sheet that you want to copy to the other workbook. On the Edit menu, click Sheet > Move or Copy Sheet.
Detailed explanation-3: -Hold Ctrl and click the worksheets to which you want to copy the data or formatting. If you hold Shift and click the last worksheet in the workbook, then all worksheets will be selected. In the window that opens, choose if you want to copy the just the Formatting, Contents of the cells, or All (everything).
Detailed explanation-4: -By default when you copy (or cut) and paste in Excel, everything in the source cell or range-data, formatting, formulas, validation, comments-is pasted to the destination cell(s). This is what happens when you press CTRL+V to paste.