answersLogoWhite

0

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.

User Avatar

Wiki User

16y ago

Still curious? Ask our experts.

Chat with our AI personalities

FranFran
I've made my fair share of mistakes, and if I can help you avoid a few, I'd sure like to try.
Chat with Fran
SteveSteve
Knowledge is a journey, you know? We'll get there.
Chat with Steve
ProfessorProfessor
I will give you the most educated answer.
Chat with Professor

Add your answer:

Earn +20 pts
Q: What is the difference between the spreadsheet commands CopyPaste and CopyPaste Special?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Basic Math

What is the lower and upper case while creating password?

Upper case are the "capital" letters ABCDEFGHIJKLMNOPQRSTUVWXYZ. Lower case are the (obviously) lower case letters abcdefghijklmnopqrstuvwxyz. All other characters fall into the 'numeric", i.e. 0123456789, or "special characters" categories. "Special characters" may include `-=[]\;',./~!@#$%^&*()_+{}|:"<>? although some of those characters may be excluded from use because the are tied to commands.


How do you factor an expression?

This is sometimes quite tricky. You can use several tricks to help you factor expressions. The first thing you should look out for is whether there is some common factor which you can take out. Example: 3x2 + 5x has the common factor "x" Taking it out, you get: x (3x + 5) Next, you look for some special forms, which you need to get familiar with - such as the difference of two squares, the sum or difference of two cubes, etc. You can probably find those special forms in the corresponding chapter in your algebra book.


What is the difference between echo and print and printf in PHP?

The print function is slightly more dynamic than the echo function by returning a value, and the echo function is slightly (very slightly) faster. The printf function inserts dynamic variables/whatever into wherever you want with special delimiters, such as %s, or %d. For example, printf('There is a difference between %s and %s', 'good', 'evil') would return 'There is a difference between good and evil'.


Any special name for a prime number 2?

No special name.


What are special numbers?

Even though there are different special numbers, there is only one special number that falls under all the categories. The number one is special because it cannot be a prime or a composite number as one only has one factor: itself. So it is classified as a special number. There are, however, other special numbers in separate categories.