Is there a keyboard shortcut for "paste values"?

S

Sirritys

or can I define one ?

I'm really using a lot of paste values, and it's pain in the *** to use
right click menu every time

Regards,
Sirritys
 
P

Pete_UK

It is quite easy to define a macro to do this for you. Highlight a
range, then turn the macro recorder on (Tools | Macro | Record new
macro) and define a keyboard shortcut, eg CTRL-SHIFT-P - you might also
like to locate the macro in personal.xls using the pull-down. While the
macro recorder is running, click <copy> then Edit | Paste Special |
Values (check) then OK followed by <Esc>. Then click <close> on the
macro recorder icon.

In future, all you will need to do is highlight your range and do
CTRL-SHIFT-P to fix the values.

Hope this helps.

Pete
 
S

Sirritys

Thanks for help.

However I think that is not going to work for me, since I need to copy
paste a lot from different sheets and stuff :-/

Pete_UK kirjoitti:
 
D

Dave Peterson

I think that you'll find that Pete's suggestion will work.

As will this:

How about just adding another icon to your favorite toolbar.

Tools|Customize|commands tab|edit category
scroll down the right hand side and drag "paste values" to that favorite
toolbar.
 
P

Pete_UK

Dave,

I thought the OP would want to paste the values in place - it would
need a slight modification (i.e. do <copy> outside of recording the
macro) to enable him to paste the values into a separate sheet. Then he
would have to highlight the range, click <copy>, move to the cell(s) in
the other sheet and then CTRL-SHIFT-P - not really much of a shortcut
!!

Pete
 
D

Dave Peterson

Ah. Copying first, then recording the macro when paste special may have been
what the OP wanted.
 
J

Jay

Sirritys said:
or can I define one ?

I'm really using a lot of paste values, and it's pain in the *** to use
right click menu every time

Regards,
Sirritys
Click to expand...

Alt + E S V <enter>

I use it dozens of time a day and it takes a fraction of a second.

Jason
 
Top