Register
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,
102,677 views
19 votes
19 votes
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.

User Karellm
by
3.0k points

1 Answer

18 votes
18 votes

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.

User Reggoodwin
by
2.8k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

1.6m questions

2.0m answers

Other Questions

If the rate of inflation in Japan dramatically increases while the rate of inflation in the United States remains constant, then a. the demand curve for dollars shifts to the left. b. the demand curve
If you buy a one-year bond for $4,000 and the issuer pays you back $5,000 at the end of one year, the interest rate on the bond is
The market value of the equity of Hudgins, Inc., is $582,000. The balance sheet shows $21,000 in cash and $192,000 in debt, while the income statement has EBIT of $93,000 and a total of $137,000 in depreciation
Kylie is risk averse and has $1,000 with which to make a financial investment. She has three options. Option A is a risk-free government bond that pays 5 percent interest each year for two years. Option
Elroy Rocket is entering his senior year as an accounting major and has a number of options for his summer break. His options for the 3 month break follow: (1) Work full time at a local accounting firm
Link Copied!