Share via

Excel Control V paste values

Anonymous
2024-05-28T12:39:22+00:00

Hi,

I have never had control V = past values, it's always just paste, is this correct as I often see things that refer to v as values and p as paste, for me control p = printer , v = paste ?

Richard.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-05-28T14:36:46+00:00

    Hi,
    just found the answer , co pilot says ;

    In Excel, you can use the keyboard shortcut Ctrl + V to paste values without any formatting. This means that only the actual data will be pasted into the cell, without any additional styling or formulas^1^. If you want to avoid formatting and paste just the values, this shortcut is quite handy! 

    but it's actually ctrl shift V

    Richard

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2024-05-28T14:52:24+00:00

    just to add it is confusing when as you show the pop ups have paste as P and values as V

    1 person found this answer helpful.
    0 comments
  3. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-05-28T14:22:15+00:00

    Ctrl+V is simply Paste.

    If you click the lower half of the Paste button, you'll get a drop-down menu. Each option can be selected by pressing a single letter: P for standard Paste, V for Values, etc.

    You can see this by pressing Alt+H, V:

    (This is the version you'll see if there are Excel data on the clipboard)

    0 comments