Shift + Insert replacement

  • Thread starter Thread starter Rasmus
  • Start date Start date
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
 
-----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
 
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
 
Back
Top