Tom’s Tutorials For Excel: Shortcutting a Cell for PasteSpecial to Values

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

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,
8 comments on “Tom’s Tutorials For Excel: Shortcutting a Cell for PasteSpecial to Values
  1. chrisham says:

    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.

    • Tom Urtis says:

      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.

  2. ashutosh says:

    Hello,
    What about ctrl+alt+V option for paste special.
    What is the shorcut for formulas and values?

  3. ashutosh says:

    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.

  4. ashutosh says:

    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.

  5. kamaladasan says:

    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

  6. chakravarthy svgk says:

    useful. how do we do it for multiple cells?

    • Tom Urtis says:

      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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*