How to convert a formula into a value only?

  • Thread starter Thread starter Guest
  • Start date Start date
Select your range
edit|copy
edit|paste special|values



geol2222 wrote:
 
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
 
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"
 
You must log in or register to reply here.

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

Which is the best MBOX Converter Tool different formats conversion? 4
Converting formula into values 2
How to Convert MBOX to PST Online? 3
Convert to Values 2
How can I migrate MBOX to PST? 2
How to Convert EML to PST? 2
How to Convert EML to PST in 2025? 2
how do you convert a forumula into the formula's answer 1

Back
Top