1
When copying cells, I often need to keep value & formation of the cell but NOT the original formulas.
Copying large range of cells, I couldn't see the paste icon to choose the associative options. Even though having the icon showed up, it's also a tiring steps.
Would love to have the fastest way possible. Please help.
Nam G VU
Posted 2012-07-16T07:10:02.100
Reputation: 10 255
2
You have the old keyboard shortcuts, work great for me (I use the values option constantly).
Paste-special 'values'
ALT + E , S , V
Paste-special 'formats
ALT + E , V , T
Alternatively, I believe there is an option to change the default paste option in Office 2010 (not sure about earlier versions) or you could just record a macro to do this and then set a keybinding.
James
Posted 2012-07-16T07:10:02.100
Reputation: 1 185
In office 2010 you can just (1) Paste - (2) press CTRL - (3) then the shortcut for the mode you need ("V" for "values only"). – Nickolay – 2012-10-10T14:16:01.247
Let us know if you want code to do this, VBA or C#.
Range.Value2 = object[,]is the fastest unless you write directly to the file, eg Excel XML files – Jeremy Thompson – 2012-07-16T07:31:37.057