Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert to Values
Hi Thomas
See this page for code examples http://www.rondebruin.nl/values.htm You can add a macro in your personal.xlsb if you want or create a add-in http://www.rondebruin.nl/personal.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Thomas M." wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert to Values
Thanks for the reply.
So I can setup a macro with a hot key combination, and that should suffice, but I'm still curious as to whether or not there is any way to add a custom command to a context menu in Excel. Is there any way to do that? --Tom "Ron de Bruin" wrote in message ... Hi Thomas See this page for code examples http://www.rondebruin.nl/values.htm You can add a macro in your personal.xlsb if you want or create a add-in http://www.rondebruin.nl/personal.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Thomas M." wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert to Values
Hi,
How about adding the Paste Values tool to your toolbar, there is one under View, Toolbars, Customize, Commands tab, Edit Category. Actually there is also a Paste Special button available and if you are using 2007 there is a Paste Special shortcut key - Ctrl+Alt+V -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Thomas M." wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert to Values
Hi Thomas
You you can add a Paste Values button to the Cell menu if you want. You must do this wil code one time. Below you find a macro to add it and to delete it Sub Add_Paste_Special_Button() ' This will add the Paste Special button to the cell menu Application.CommandBars("cell").Controls. _ Add Type:=msoControlButton, ID:=370, befo=1 End Sub Sub Delete_Paste_Special_Button() On Error Resume Next Application.CommandBars("cell").FindControl(ID:=37 0).Delete On Error GoTo 0 End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Thomas M." wrote in message ... Thanks for the reply. So I can setup a macro with a hot key combination, and that should suffice, but I'm still curious as to whether or not there is any way to add a custom command to a context menu in Excel. Is there any way to do that? --Tom "Ron de Bruin" wrote in message ... Hi Thomas See this page for code examples http://www.rondebruin.nl/values.htm You can add a macro in your personal.xlsb if you want or create a add-in http://www.rondebruin.nl/personal.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Thomas M." wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert the values into 3 digits? | Excel Discussion (Misc queries) | |||
Automatically Convert values to $M | Charts and Charting in Excel | |||
convert column values | Excel Worksheet Functions | |||
Convert Values to formulas | Excel Worksheet Functions | |||
convert $ value to day values | Excel Worksheet Functions |