Paste Special Shortcut?

  • Thread starter Thread starter hef
  • Start date Start date
Hi
you may record a macro while doing this manually and assign a shortcut
to this macro
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste special shortcut 5
Excel Copy and Paste (Greyed) 2
Keyboard Shortcuts for Paste Special Values and Formats 2
Can't Explain N/A in Vlookup 2
Paste Values and Source Formatting Shortcut 3
Macro that copies values from column A (from formula) to B (paste value) 1
Macro for Copy Paste special Values 13
Excel 2007 Copy paste - numeric along with comment 4

Back
Top