How to convert a formula into a value only?

G

Geoff Lilley

Good call, Dave.

Other thing you can do to make it an easier shot:
1) Tools
2) Customize
3) Click on "Commands."
4) Choose the category "Edit."
5) Under "Edit," there's a custom button called "Paste Values" that you can
drag to your toolbar for ready, easy use.

That's if you're going to use the button all the time. Just a thought.

Cheers,
Geoff
 
D

Dave Peterson

Another method if your a mouse user:

select your range
rightclick on the border of the range
move the selected range slightly to the right (or left/up/down)
put it back where you started.

You'll see a popup that allows you to "copy here as values only"
 
Top