UrbanPro

Location Set your Location

Login Ask & Answer Success Stories Paid Courses Free Classes Tuition & Classes Fees Write a Review All Categories Help Center
Post your Learning Need Signup as a Tutor
✕

Popular Cities

Bangalore

Hyderabad

Delhi

Mumbai

Chennai

Pune

Kolkata

Gurgaon

Ahmedabad

Jaipur

Noida

✕

Learn Computer Software from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Book a Free Demo

Computer Software > Learn Computer Software > What is the difference between Paste and Paste Special...
✕

Search in

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

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

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

Trainer

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. Paste Special is a feature found in Microsoft Word, Microsoft Excel and OpenOffice. Pasting text from a Web...
read more
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. Paste Special is a feature found in 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

Corporate IT Trainer

All the answers so far given are just perfect, I would like to add a few more. Excel 2010, give a graphical icon look to paste special, now you could not only paste, values, keep formatting, using the icons, now it is possible to even transpose data (like pivot, unpivot operations we do in SQL), paste...
read more
All the answers so far given are just perfect, I would like to add a few more. Excel 2010, give a graphical icon look to paste special, now you could not only paste, values, keep formatting, using the icons, now it is possible to even transpose data (like pivot, unpivot operations we do in SQL), paste your data validations, keep Col width, no-borders, paste link, unlink, with picture, in fact select some data, do Ctrl+C and just use your keys ALT+H+V to invoke the paste special menu. Hope this helps! read less
Comments
Dislike Bookmark

Trainer

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

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

A Cell (Range) is a combination of it's value, formulas, format, comments, data validation. Using all these features a cell exists in the worksheet. We need use paste special, if you want to paste only one of the above feature like values, comments, formulas etc. Paste will paste all of the above. Thanks, Team...
read more
A Cell (Range) is a combination of it's value, formulas, format, comments, data validation. Using all these features a cell exists in the worksheet. We need use paste special, if you want to paste only one of the above feature like values, comments, formulas etc. Paste will paste all of the above. Thanks, Team Excelytics 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

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

View 17 more Answers

Related Questions

How does memory allocation is occurred during executing a simple C program .??
Memory allocation is of types: Static Memory Allocation and Dynamic Memory allocation. Static is a fixed one and is allocated once during compile time, whereas dynamic memory is allocated during run time.
Arnab
Hello all, can anyone suggest me best IT course to get / available job for fresher?
go for testing (simple and easy)
Priya
Where will I get best IT course? I'm 24 year and completed my graduation from management in 2012. After completing my graduation, I have one year experience in basic computer software like SAP (I run SAP in a logistic company) now I have no job and I want to do a software course for my future but I am not sure which course would be best for me. I want a good course to get a job in MNC with good salary. Please advice.
Learn DBA..It's leading Technology in Market.
Raj
Hi, I am working as a web designer and want to work as UI developer. So what should I have to learn initially? And learning Angular Js would be a good option?
It is good choice web designer to become web developer (UI developer). Start with the basics first learn HTML and CSS, Then go and continue with bootstrap and Angular js.
Mudita
Hi, I currently work in mainframe technology. i want to learn something new so planning to learn a different technology and work in it in future. i am currently working in mainframe (tech role) for about 9 years now with an automotive background. I have got a suggestion from colleagues to learn BW and then BW with HANA as there could be good demand in future. Now, Are BW and BW with HANA separate courses? Is it workable to learn both of these in parallel?
You have options for learning new technology. For example, big data technologies, IoT, etc. You can even opt for HANA. Well, in addition to this you can think of certifications like cloud computing, cisco, oracle, etc.
Satya
0 0
6

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

Ask a Question

Related Lessons

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
Easy way to remember Java keyword.
ACCESS MODIFIER ACCESS SPECIFIER abstract, assert, const, final, native, static, strictfp, super, synchronized, this, transient, void, volatile public, private, protected, default DATA...

Rohit Deshbhratar

1 0
0
The ABCs Of Success For A Software Developer
“There is more to know for career advancement rather than focusing on codes and its challenges to become a successful developer”. A developer is the one who creates software application by...

Mercury Solutions limited

0 0
0
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
Focus on Fundamentals
It is very important to focus on fundamentals of any subject one is interested to gain command over that subject. If one learns and understand the fundamentals throughly, it is easy to grasp the advance...

Vihanga EmbedSoft

0 0
0

Recommended Articles

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 >

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 >

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 >

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 >

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

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
X

Looking for Computer Software Classes?

The best tutors for Computer Software Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Computer Software with the Best Tutors

The best Tutors for Computer Software Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more

ThinkVidya Learning Pvt Ltd © 2010-2024All Rights Reserved