Excel Gurus

Science & Technology Information Technology, Gaming, Machines, Gadgets
1

How can I make a shortcut for “pasting values” on the toolbar?

2

Re: Excel Gurus

The "Paste" command is already there on the toolbar. If its not, open tools menu, select customize, go under commands tab, select edit from the left list and then select "Paste" from the list on the right and drag and drop onto the desired location on the toolbar.

3

Re: Excel Gurus

^ I think she wants to past values. i.e. The cell has a formula =A1*B1 and she wants to copy it and then paste the answer as value, not as formula. As far as I know, there's no shortcut for it except right-clicking it and selecting paste values. I am pretty sure you can do some macro (sub) but I am not sure how to do it.

Last person to answer this post wins!!!!
4

Re: Excel Gurus

Please go do "Add/Remove Buttons", then "customize", then "Commands" then "Edit" in categories and then click "Paste Value" in the commands section.

Timepaas
5

Re: Excel Gurus

create a macro and you can paste this in it.

Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False

6

Re: Excel Gurus

my co-worker has it..it shows up as a happy face on his toolbar :D

us1415...please guide me

7

Re: Excel Gurus

  • Click on the View menu, Toolbars and then Customize (at the bottom)
  • Go to the Commands tab
  • Click Edit on the left and in the right window scroll down to where it says Paste Values
  • Click on it and drag it to where u want the icon

PS: Your friend prob has the macro that us1415 mentioned.

8

Re: Excel Gurus

Thank you Mr. TofiBaba...Happy face hi na sahi but at least I have it :D

9

Re: Excel Gurus

^
Click on the View menu, Toolbars and then Customize (at the bottom)
- Go to the Commands tab
- Click Edit on the left and in the right window scroll down to where it says Paste Values
- Click on it and drag it to where u want the icon
*at this point while Edit and Paste Values are selected click on Modify Selection then select Change Button Image and then Select your Happy Face :) *