answersLogoWhite

0

Right click the source cell. Choose "Copy". Right click the destination cell. Choose "Paste Special". Now select "Values" (left click) and press (left click) "Ok".

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

Formula for finding the magnification of a cell?

The magnification of a cell can be calculated using the formula: Magnification = Image size / Real size. This formula compares the size of the image of the cell to its actual size in order to determine the level of magnification.


What is an static cell information in Microsoft Excel?

Static is something that does not change. So you could answer the question in a number of ways. If you type an actual value into a cell, that value will not change. Whereas if you type in a formula, the result it will display can change, depending on other things that happen in the spreadsheet. Other static information about a cell could be the actual cell reference, and even breaking that down to the column it is on and the row it is on.Static is something that does not change. So you could answer the question in a number of ways. If you type an actual value into a cell, that value will not change. Whereas if you type in a formula, the result it will display can change, depending on other things that happen in the spreadsheet. Other static information about a cell could be the actual cell reference, and even breaking that down to the column it is on and the row it is on.Static is something that does not change. So you could answer the question in a number of ways. If you type an actual value into a cell, that value will not change. Whereas if you type in a formula, the result it will display can change, depending on other things that happen in the spreadsheet. Other static information about a cell could be the actual cell reference, and even breaking that down to the column it is on and the row it is on.Static is something that does not change. So you could answer the question in a number of ways. If you type an actual value into a cell, that value will not change. Whereas if you type in a formula, the result it will display can change, depending on other things that happen in the spreadsheet. Other static information about a cell could be the actual cell reference, and even breaking that down to the column it is on and the row it is on.Static is something that does not change. So you could answer the question in a number of ways. If you type an actual value into a cell, that value will not change. Whereas if you type in a formula, the result it will display can change, depending on other things that happen in the spreadsheet. Other static information about a cell could be the actual cell reference, and even breaking that down to the column it is on and the row it is on.Static is something that does not change. So you could answer the question in a number of ways. If you type an actual value into a cell, that value will not change. Whereas if you type in a formula, the result it will display can change, depending on other things that happen in the spreadsheet. Other static information about a cell could be the actual cell reference, and even breaking that down to the column it is on and the row it is on.Static is something that does not change. So you could answer the question in a number of ways. If you type an actual value into a cell, that value will not change. Whereas if you type in a formula, the result it will display can change, depending on other things that happen in the spreadsheet. Other static information about a cell could be the actual cell reference, and even breaking that down to the column it is on and the row it is on.Static is something that does not change. So you could answer the question in a number of ways. If you type an actual value into a cell, that value will not change. Whereas if you type in a formula, the result it will display can change, depending on other things that happen in the spreadsheet. Other static information about a cell could be the actual cell reference, and even breaking that down to the column it is on and the row it is on.Static is something that does not change. So you could answer the question in a number of ways. If you type an actual value into a cell, that value will not change. Whereas if you type in a formula, the result it will display can change, depending on other things that happen in the spreadsheet. Other static information about a cell could be the actual cell reference, and even breaking that down to the column it is on and the row it is on.Static is something that does not change. So you could answer the question in a number of ways. If you type an actual value into a cell, that value will not change. Whereas if you type in a formula, the result it will display can change, depending on other things that happen in the spreadsheet. Other static information about a cell could be the actual cell reference, and even breaking that down to the column it is on and the row it is on.Static is something that does not change. So you could answer the question in a number of ways. If you type an actual value into a cell, that value will not change. Whereas if you type in a formula, the result it will display can change, depending on other things that happen in the spreadsheet. Other static information about a cell could be the actual cell reference, and even breaking that down to the column it is on and the row it is on.


What is the data called that is displayed in the formula bar in Excel?

It shows the cell contents which can be things like numbers, text, dates or formulas. It will always show values that are unformatted. It shows what is actually typed into a cell, like a formula, even though the cell may show an actual result of the formula.


What is the formula to calculate the value of cell J10?

What is the formula to calculate the value of cell J10?


Does the formula bar in Excel display the value or formula of an active cell?

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.


In excel if value is in one column automaticlly put formula in another column?

There is no way to have a value in one cell put a formula in another cell. However, you can put a formula in a cell that will change, based on the value of another cell. If you put the formula =A1 in cell B1, B1 will display the value of whatever you place in cell A1.


What is the formula that will place the word yes if a cell is less than 25 percent of another cell or No if this condition is not met?

You can use the following formula in Excel to achieve this: =IF(A1 < 0.25 * B1, "Yes", "No"). Replace A1 with the cell you want to check and B1 with the cell to compare against. This formula checks if the value in cell A1 is less than 25% of the value in cell B1, returning "Yes" if true and "No" otherwise.


What formula will divide the value in Cell e5 by the value in Cell e6?

=E5/E6


What are Type in the formula you would use (in Excel) to multiply the value of cell B4 with the value of cell D2?

In Excel, you would use the formula =B4 * D2 to multiply the value in cell B4 with the value in cell D2. Simply enter this formula into the cell where you want the result to appear, and it will calculate the product of the two values.


Is the entry bar the area where the text a number or formula is displayed for the active cell?

The proper name is the formula bar, but yes a formula or value can be seen there when you have entered a value or formula in a cell.


How do you change the value of a cell?

You can literally type in a new value into a cell. It can also be changed by using controls, such as scroll bars, dropdown lists, spinners etc. The value a cell has may change as a result of a formula, though tecjhnically if it has a formula in it, then that is not really a value even if it shows a value, as what is actually stored in the cell is a formula.


How do you replace the one number with other number using functions in Excel?

You would use the Replace facility rather than functions. Functions cannot change the content of other cells. They can only affect the cell they are in. If you have a number in cell C3 you cannot change it by typing in a function in C3. You would be immediately replacing what is in C3 with a formula. You could put a formula in another cell that will put a number into itself based on what is in C3. If you want to change the actual contents of C3, then use the Replace facility, which you can activate by pressing Ctrl - H. You would also use it to replace the same number occurring in multiple cells. So you could replace the contents of all cells with a particular value in them with a new value.