answersLogoWhite

0


Best Answer

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

15y ago
This answer is:
User Avatar

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.

Related questions

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.


What special name is given to to text in a spreadsheet?

Label


When do you get special commands in zoo resort for 3ds?

you get it when you get 20 animal species


What is the difference between JSOC and SOCOM?

SOCOM is the Army's special operations command. JSOC is the Joint Special Operations Command and encompasses all of the special ops units in the United States military, including those from Air Force, Navy, and Marines. Both commands are located at Ft. Bragg, NC.


What are special keys programmed to issue commands to the computer?

Function key


What device inputs letters numbers and special commands?

The computer keyboard.


How do you link an external Excel spreadsheet into a word document?

Select the data in the spreadsheet and copy it. Go to the Word document and in the Edit menu pick Paste Special and Paste Link. A link will be established so that when the spreadsheet changes, the data in the word processing document will also change.


What are psuedoinstructions?

Pseudo Instructions are special commands used in computer programming. They are special commands to the assembler about the positioning of the program, the address the program should presumed to be assembled at, the name of the module, data declarations, the title and printing options for the program, and end of source.


Which Paste Special option can give you trouble with the formatting of your spreadsheet data?

Microsoft office excel worksheet object


How do you get more food on zoo resort 3d?

You can get them in the animal dispenser sometimes or using special commands


What file type combines ASCII codes with special commands that distinguish variations?

Dot matrix


US joint forces command, us special operations command, us strategic command, and us transportation command comprise?

Functional Combatant Commands