copy/paste vaules, not formulas

  • Thread starter jeremy via OfficeKB.com
  • Start date
J

jeremy via OfficeKB.com

Is there an easier way to copy and paste the values of a cell without using
notepad? When i paste directly to new column the formulas get copied--i
only want to paste the final values...
Makes sense?
Jeremy
 
R

Ron de Bruin

Hi jeremy

Copy the cells
Right click on the target cell
Choose Paste Special
Select Values
OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
How to paste this down? 3
How to make repeating drop-down lists? 2
Pages are changing pasted image... 0
Embed the same Excel multiple times 0
Convert Formula Results to Absolute 1
VB Script reference cells for in current table? 1
Copy/Paste (Clipboard) Issues 1

Top