0
What is the difference between Paste and Paste Special in Excel?
Wiki User
∙ 9y ago
In word programs, there is normal pasting which is normally done with images, text, etc, then there is special pasting which allows you to copy a section of text from word for example and past it into another word program as a picture eg.
It just allows you to copy one type of information and paste it as another.
Wiki User
∙ 12y ago
Wiki User
∙ 12y agoSpecial allows you to pick some options, such as to copy the formula (if any) or just the value. The default is the formula - so sometimes it's desireable to copy just the value. There are other options as well - give it a try and you'll see the possibilities.
Wiki User
∙ 9y agoIn word programs, there is normal pasting which is normally done with images, text, etc, then there is special pasting which allows you to copy a section of text from word for example and past it into another word program as a picture eg.
It just allows you to copy one type of information and paste it as another.
The paste special command has a number of useful tools built into it. Besides allowing you to paste values, it also allows you to transpose lists (columns to rows or rows to columns), multiply, add, skip blanks and paste links.
Wiki User
∙ 9y agoIn Excel paste takes what you have copied and puts into the destination. Paste Special gives you lots more options as to how and what you want to paste. You can do things like paste the formatting only. You can copy the values only, so you get the value as the content of a cell and not the actual formula being copied. You can do things like copy a number and then paste it onto other numbers and do a calculation in the process. So if you had a set of numbers that you wanted to change to be 100 times what they are, you could put 100 into a cell, copy it, and pick the multiply operation in Paste Special and then paste over the numbers and they would all be multiplied by 100. You can do things like transpose what you have copied. So if you copied some things that were in a row you could paste them into a column. Paste Special is very useful once you get used to using its many facilities.
Add your answer:
Earn +20 pts
What is the difference between the spreadsheet commands CopyPaste and CopyPaste Special?
The basic Paste command in Excel pastes all values, formulas, validations, formatting, and other attributes into the cell. With Paste Special, you can select which attributes to paste. For example, you can paste just the value of the copied cell or just the validations, or just the formatting, etc.
Have you linked the files when you connect a Word document to a separate Excel worksheet?
If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.
What is the command that pastes formulas with rows and columns switched in Excel?
From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.
What is difference between between paste and paste special option in edit menu of wordpad?
Paste will just paste whatever you've copied. Paste Special in Wordpad has a few options to paste in different formats which are as a Wordpad document, Rich Text Format, a picture and unformatted text. It is much more limited in options compared to Paste Special in other applications.
How do you copy a function to another cell in excel?
Copy and Special Paste formulas.
What is the button that allows you to copy values with or without formatting or format only?
hi..to paste the selected cells in value/other formats press the folllowing in a sequential order (not simultaneously) 1. alt 2. E 3. V 4. S Then, select the desired option
Can you switch data from Works to Excel?
Yes, you can import MS Works data into MS Excel. thanks you can use two options first is paste and other one is paste special which is linked with excel with word.
What is difference between paste and paste special options in edit menu of wordpad?
Paste will just paste whatever you've copied. Paste Special in Wordpad has a few options to paste in different formats which are as a Wordpad document, Rich Text Format, a picture and unformatted text. It is much more limited in options compared to Paste Special in other applications.
What is the difference between the spreadsheet command Copy Paste and Copy Paste Special?
Special copy allows you to copy only specifc aspects instead of copying all formatting and formulas of a cell.
How do you set cells in excel for only copy the content?
You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.
What is paste special in Excel 2007?
Paste Special lets you copy cell contents and copy selected cell contents to another cell. The paste special command has a number of useful tools built into it. Besides allowing you to paste values, it also allows you to transpose lists (columns to rows or rows to columns), multiply, add, skip blanks and paste links.
Which Paste Special option can give you trouble with the formatting of your spreadsheet data?
Microsoft office excel worksheet object
