Range Value

[Rowdysmom]

Probably an easy question, but having been brought up using Lotus, I used to be able to do a /Range Value command that would turn formula's into values. I can't seem to find that same command in Excel 2010. Am I just missing it?

 

[Scott Huish]

Select the Range. Copy it. Right click the range and Click on Paste Special, then Values.

 

[Rowdysmom]

Thank you for you quick answer!!

 

[HalfAce]

In earlier versions of Excel you can also put up a button on one of your toolbars that is for PasteSpecial - Values. (Don't have XL 2010 here but I'd have to imagine that's still an option.)

If you can find the button, then you can simply select the range, hit the Copy button & hit the PasteSpecial Values button.

 

[Rowdysmom]

Thank you for your help!