Tom’s Tutorials For Excel: Shortcutting a Cell for PasteSpecial to Values
Here’s a quick way to use your keyboard for achieving the effect of copying a cell, and pasting it special for values.
Instead of mouse clicks and menus that are commonly used, it only takes 3 easy steps:
Step 1: F2 | Step 2: F9 | Step 3: Enter
Step 1
Step 2
Step 3
I do not know if its a keyboard thing, but this tip does not seem to work here! Would love to see it work given its popular usage.
Where is here? Maybe you are in a country where keyboard shortcuts do not do the same things they do in other countries, which is not uncommon. I know the process works here in the US, so I’d be very interested to know where you are, and maybe we can figure out a shortcut that achieves the same result.
Hello,
What about ctrl+alt+V option for paste special.
What is the shorcut for formulas and values?
I am from India actually. And that is how I do use paste special functions. The key combination opens the paste special dialog box. But i don’t exactly remember the fourth key in sequence.
For example: Ctrl+Alt+V; W pastes the data with same column width.
Hello, I have found the shortcut for paste special function. Please have a look.
Ctrl+Alt+V opens the PASTE SPECIAL dialog box.
Now…For pasting values press V and then Enter.
Please let me know if you find it a valid shortcut. I will provide you the whole list.
Respected sir,
How to add tamil font in filter section?
Note: already use tamil font (vanavil) in excel but not support in filter section.
how to solve it?
My cell no. 9840094062
useful. how do we do it for multiple cells?
For multiple cells, this sequence, assuming the cells of interest are currently selected:
Ctrl+C
Alt+S+V V Enter OR Ctrl+Alt+V V Enter
Esc (to exit copy mode)
You can also do it in the VBE. Hit Alt+F11 > Ctrl+G then type in
selection.value = selection.value
and hit Enter
Alt+Q to return to the worksheet.