View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Excel - create button to replace cell content with cell value

That's far too dangerous, if you can live with ctrl + C and then click on an
icon you can do viewtoolbarscustomize and in the commands tab
select edit under categories and under commands scroll down to an icon with
12 on it and drag it to the menu, then close the customize window
However having an icon that would turn formulas into values with just a
click is not good IMHO

--

Regards,

Peo Sjoblom

"blackmot" wrote in message
...
I frequently wish to replace the formulas in a cell(s) with the values.
Currently this requires several steps. Although I could shorten this by
creating a macro, I would suggest that this is a common operation for many
users and creation of a standard function for this would be valuable.

Many
users could not create the required macro.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow

this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...et.f unctions