Paste Special Shortcut?

[hef]

Is there a short cut for "paste special" -> "values" ?

Thanks!!

Hillar

 

[Frank Kabel]

Hi
you may record a macro while doing this manually and assign a shortcut
to this macro

 

[Ron de Bruin]

Or this

You can add a button on your toolbar if you want

View>ToolBars>customize
click on the commands tab
choose Edit
Drag the Paste Values button on that list to a Toolbar

 

[Casey]

Hef
The keyboard shortcut for paste special>values is ALT>E>S>V. Paste
Special is also available in the destination cell by "right clicking"
and choosing "Paste Special" from the shortcut menu.

Hope this helps
Casey

 

[David McRitchie]

Hi Hillary,
An example of a macro to Paste Values
http://www.mvps.org/dmcritchie/excel/paste.htm#values

Haven't used in years, I use the menus.