Forum Discussion
Understanding the specific. Differences between Paste All and Paste all using sourcing theme
- I tried so many things and finally got the answer, this options is used for Copy and Paste in different workbook. If copy and paste in the same workbook, result will be as same as paste all.
Thank you every one for your input.
13 Replies
Copy and paste specific cell contents
(Click on Link for detail Infos as well as seeing the differences)
You can copy and paste specific cell contents or attributes (such as formulas, formats, comments, and validation). By default, if you use the Copy and Pasteicons (or+ C and+ V), all attributes are copied. To pick a specific paste option, you can either use a Paste menu option or select Paste Special, and pick an option from the Paste Special box. Attributes other than what you select are excluded when you paste.
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. Since that might not be what you want, you have many other paste options, depending on what you copy.
For example, you might want to paste the contents of a cell, but not its formatting. Or maybe you want to transpose the pasted data from rows to columns. Or, you might need to paste the result of a formula instead of the formula itself.
You can specify formatting when you paste slides, text, pictures, objects, and tables from other programs or the web into your Office application such as Access, Word, PowerPoint, Excel, and Outlook. Keyboard Shortcut: Press Ctrl+Alt+V.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- I afraid this doesn't answer the question, I'm looking for a specific example not a general info that show on Microsoft as it doesn't say much about the differences between the 2 options in questions. Thank you though.
I am afraid I do not understand your concern.
I sent him the table with what paste and paste special can do.
What is so difficult to make an example of it for yourself?
Anyway, everyone who is looking for help here should get help.
Difference Between Paste and Paste Special Definition
Paste is a computer program action that allows copying an object or text from one location and placing it to another location. Paste Special is a computer program action that provides more control on how the content is displayed when pasted from the clipboard.
Conclusion
Paste Special is a special type of paste option. The 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 on the application.
Hope this helped you.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
