View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Thomas M. Thomas M. is offline
external usenet poster
 
Posts: 68
Default Convert to Values

Excel 2007

One thing that I do frequently in Excel is convert a range to formulas to
values. The thought hit me today that it would be handy if there was a
Convert to Values option on the context menu so that a person would just
need to highlight the range, right-click, and select the Convert to Values
option. All Excel would need to do is run an automatic copy and paste
special.

Are there any add-ons out there that make this possible? If not, it there a
way for me to add this functionality myself via a custom function or
something?

Thanks for any help that you can offer.

--Tom