answersLogoWhite

0


Best Answer

Use the Paste Special facility. From there you can then choose to paste the values, rather than the formulas.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: When you copy data and paste in excel sheet it pasting only formulas not the data how can I copy the data when the content is formula made?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

In excel the action of placing cell content that has been moved to clipboard to another location is called?

Pasting.


'How do you do formulas on Excel and continue to work with answer as a numerical value and not a formula '?

'How do you do formulas on excel and continue to work with answer as a numerical value and not a formula '


What do you have to put in a cell to denote an equation in Excel?

In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.


What is the formula for sound on spreadsheet?

There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.


Where is the formula error button in Excel 2007?

There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.


How does Excel recognize that you are entering a formula into a cell?

All formulas must begin with the equals sign. That is how Excel knows it is a formula.


What are some examples of Excel formulas?

formula's of excel =sum(+_/*) =count(if) =today() =now() by' (rubab)


Which function of Excel does not work with 3D formulas?

There are several functions of Excel that do not work with 3D formulas. These include cell references and range formula.


Where can you get a list of Microsoft Excel column formulas?

There are no column formulas in Excel. Only formulas you put in individual cells. The closest thing to a column formula would be VLOOKUP.


Where can a person find an Excel formula tutorial online?

A person can find an Excel formula tutorial online at several websites that contains spreadsheets with formulas. Microsoft Excel maintains many tutorials online with these formulas for a small fee.


What is a background formula checking in Excel?

Excel continually reviews the workbook for errors in formulas as you create or manipulate it


How do you specify that the cells containing formulas well display the formula but not the result of the formula?

Under the formulas tab, there is an option called "Show Formulas" in Formula Auditing. This applies for Excel 2010 (what I am using) and should apply for Excel 2003 and 2007 as well. For older options (or if there is no such option in Excel 2003/2007, search for something similar).