What is the difference between Paste and Paste Special Option in Excel?

Asked by Last Modified  

19 Answers

Learn Computer Software

Follow 3
Answer

Please enter your answer

Rohit Katke

Tutor

Paste is a feature that lets users cut or copy items from a Cells and transfer them to another. Paste Special allows the items being transferred to be formatted in several different ways. Paste Special is a feature found in many softwares like Microsoft Word, Microsoft Excel and OpenOffice. Pasting...
read more
Paste is a feature that lets users cut or copy items from a Cells and transfer them to another. Paste Special allows the items being transferred to be formatted in several different ways. Paste Special is a feature found in many softwares like Microsoft Word, Microsoft Excel and OpenOffice. Pasting text from a Web page often retains the HTML formatting of the original, while using Paste Special lets users change the font, use different links or adjust the size and color of the text. Paste Special also allows users to paste data into cells by copying formulas and calculations, which is unavailable when using Paste. read less
Comments
Dislike Bookmark

Paste: Paste all values, formats, formulas, comments, etc. Paste special: Paste with option, only values, only values, only formats, etc or all.
Comments
Dislike Bookmark

Paste Special removes all formatting from the copied text. Paste keeps the formatting, often with disastrous results.
Comments
Dislike Bookmark

paste --> paste all values, formats, formulas, comments, etc paste special --> paste with option, only values, only values, only formats, etc, or all
Comments
Dislike Bookmark

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...
read more
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. 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. read less
Comments
Dislike Bookmark

I understand that Paste Special > Values strips the formula and that Paste doesn't. But my question was about Paste > Values. That appears to do exactly the same thing as Paste Special >Values, doesn't it? They do the same thing... recording a macro for each action produces identical code. Apparently...
read more
I understand that Paste Special > Values strips the formula and that Paste doesn't. But my question was about Paste > Values. That appears to do exactly the same thing as Paste Special >Values, doesn't it? They do the same thing... recording a macro for each action produces identical code. Apparently Microsoft added Paste>Values because PasteSpecia>Values is such a common action to perform on a worksheet that they decided to eliminate making the user interact with the dialog box just to do it. Note: Paste>Special was added to Excel at version 2007. read less
Comments
Dislike Bookmark

Professor by profession, Excel & VBA Free Lancer, Day Trader Stock Market, Video Ad & SEO Support

Excel terms - Paste and paste special are two different features. Paste is a feature that lets users cut or copy items from a document and transfer them to another. Paste Special allows the items being transferred to be formatted in several different ways.
Comments
Dislike Bookmark

Expert computer science and problem solving tutor

By paste you simply paste the content with the formatting. By paste special you can change the formatting options....
Comments
Dislike Bookmark

Oracle, Hindi, C++, C, MS Office, VBScript,JavaScript,Spoken English etc with 32 years of experience

Paste means what ever you selected in copy and paste special means different types formulas values comments validation different ways you can paste.
Comments
Dislike Bookmark

Paste option will just paste the copied cell contents as it is, using paste special you can paste the contents of cells in 17 different ways: ex: paste values will only paste the values or contents of the cell without any formats (plain text).
Comments
Dislike Bookmark

View 17 more Answers

Related Questions

need trainer for Rule Engine
Hi I take basics of computers. And internet basics.Also Ms office and Photoshop and Illustrator
Hari
0 0
5
How to Create new nonsys(not sa) user login with openrowset function priviledges ? I want to read/write excel sheet through nonsys(or non sa) user
INSERT INTO table SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0; Database=//server/folder/file.xls; HDR=YES;', 'SELECT * FROM ')
Amit
0 0
6
what is java core language?
Core Java" is Sun's term, used to refer to Java SE, the standard edition and a set of related technologies, like the Java VM, CORBA.. "Core Java" is Oracle's definition and refers to subset of Java SE technologies.
Md
0 0
9
what are the languages used to develop an android application?
Java and XML
Raghi
What we do with html?
In HTML we can design web pages with the help of frames, tags, and tables etc.
Suraj

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Graphics and Game Development
Hi there, I am sure you all would have played video games for killing time. Do you know how these are developed? I am going to introduce you to some details of the gaming industry. Gaming is a serious...

Mukesh Kamath

0 0
0
Software Development Training In Jaipur
Satyam Web Solution provides website designing &development and software designing &development training in Jaipur for various stream’s students. MCA 6 month Industrial Training/Internship B....

Satyam Web Solution Project Training

1 0
0
History of SQL server
In 1988, Microsoft released its first version of SQL Server. It was designed for the OS/2 platform and was developed jointly by Microsoft and Sybase. During the early 1990s, Microsoft began to develop...

Rahul J Rajesh

0 0
0
GIT
In software engineering, software configuration management (SCM) is the task of tracking and controlling changes in the software, part of the larger cross-disciplinary field of configuration management....
R

Rahul Kumar

0 0
0
C and C++ programming with memory level debugging
Understanding C and C++ programming by using memory level debugging. Step 1: Understand the Memory map of C executable Step 2: Start memory level debugging using popular IDE Step 3: Find the memory...

Umasankar Natarajan

0 0
0

Recommended Articles

10 Tips For Your Powerpoint Presentation...

Decades back, when computers were being introduced in office premises, PPT was a new terminology that all employees tried to learn. Now PPT has made its way far away from offices and is an integral part of schools, colleges, and several other official proceedings. This is because PPT is an user-friendly computerized method...

Read full article >

10 Keyboard Shortcuts to Get Rid Off The Mouse

Whether you are using a laptop or a desktop, the mouse surely takes up time. Imagine if you could alone manage with the keys and not have to move your hands around the mouse? That would have been faster and so much time-saving. For example, Control + Z for undo or Control + Y for redo, definitely saves time when we are...

Read full article >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

MCTS certification course in India

MCTS Certification in India The Microsoft Certified Technology Specialist or MCTS certification is suited for professionals who want to get into profession of implementing, building, troubleshooting, and debugging a particular Microsoft technology. The MCTS certification can give you a clear edge over others to showcase...

Read full article >

Find Computer Software Classes near you
Computer Software Classes in Bangalore
Computer Software Classes in Delhi
Computer Software Classes in Pune
Computer Software Classes in Hyderabad
Computer Software Classes in Mumbai
Computer Software Classes in Jaipur
Computer Software Classes in Kolkata
Computer Software Classes in Chennai
Computer Software Classes in Gurgaon
Computer Software Classes in Noida

Looking for Computer Software Classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you