Copy & paste vlaue of cell

[RickeyS]

How do you copy and paste a value of a cell without pasting the formula that was in the cell? I only want the cell contents and not the formula to be pasted to the new cell.

Thanks
Rick

 

[Andrew Poulsom]

Use Copy then Paste Special Values.

 

[Von Pookie]

Use PasteSpecial to paste just the values.

- Right-click the destination
- Select "Paste Special" (or select PasteSpecial from the Edit menu)
- Select "Values" from the list that appears
- Click "OK."

 

[orysiar]

Use PasteSpecial to paste just the values.

- Right-click the destination
- Select "Paste Special" (or select PasteSpecial from the Edit menu)
- Select "Values" from the list that appears
- Click "OK."

Or.... you can hold down the "Alt" key and type the "E" letter and then the letter "S"