LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert the values into 3 digits? Eric Excel Discussion (Misc queries) 5 February 2nd 08 10:23 PM
Automatically Convert values to $M Steve D Charts and Charting in Excel 1 June 15th 06 08:52 PM
convert column values charles Excel Worksheet Functions 5 June 15th 06 07:13 PM
Convert Values to formulas TSter Excel Worksheet Functions 4 January 15th 06 09:26 PM
convert $ value to day values bo Excel Worksheet Functions 2 May 15th 05 05:37 PM


All times are GMT +1. The time now is 07:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"