Question

Karla is working in Microsoft Excel, and she needs to copy data from one spreadsheet into another. The cells she wants to copy contain a large amount of data; however, Karla wants to copy only the formatting, comments, and values. She is debating between using Paste and Paste Special. Explain which option she should use. Include details of the function you choose to support your decision. Use details to support your answer.

Answer 1

Answer:

The main difference between paste and paste special is that the paste command allows the user to insert the selected data from the clipboard into an application while the paste special command follows the same functionality similar to paste, but provides additional options to select how the inserted data should appear

how to copy Here's how:

Select all the data in the worksheet. Keyboard shortcut: Press CTRL+Spacebar, on the keyboard, and then press Shift+Spacebar.

Copy all the data on the sheet by pressing CTRL+C.

Click the plus sign to add a new blank worksheet.

Click the first cell in the new sheet and press CTRL+V to paste the data.