Discover the answers to your questions at Westonci.ca, where experts share their knowledge and insights with you. Experience the convenience of getting reliable answers to your questions from a vast network of knowledgeable experts. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform.

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.

Sagot :

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.