Shift + Insert replacement

R

Rasmus

Is there any way one can set Excel to set the SHIFT+INSERT command as to
only inserting VALUES and not FORMAT and everything ?

(c:
Rasmus
 
P

Peter Atherton

-----Original Message-----
Is there any way one can set Excel to set the SHIFT+INSERT command as to
only inserting VALUES and not FORMAT and everything ?

(c:
Click to expand...
Rasmus

Try Edit, PasteSpecial, Values

Regards
Peter
 
R

Rasmus

Try Edit, PasteSpecial, Values
Click to expand...

Yes but that doesn't change Excel's default SHIFT+INSERT shortcut. Anyway
I've created a macro that uses CTRL+I instead. I guess that'll have to do...

Rasmus
 

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

Excel --> Word 4
How to insert Certificated digital signature in Word for Mac 0
Insert multiple objects at once ? 3
Time/Date auto insert upon click 0
Re-title multiple MS Project .mpp files at once 0
Printing from Word my Inserted Pictures colors are dull and lack color 0
Prompt For Replace in Selection And More... 0
Autonumber field in Excel that behaves the same as Access 0

Top