Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

a new hotkey for copy cell values

we need a hotkey for copy cell values. ctrl+c copies cell. but usually we need to copy the "text" or "number" that stored in the cell.

1 vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

sertan özer shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
already supported  ·  Dan Battagin [MS XL] responded  · 

Hi Setan,

Good news – This is already supported in Excel, but it’s done as part of Paste, rather than as part of Copy.

1. Select the range you want to copy values from
2. Ctrl+C
3. Select where you want to Paste
4. Ctrl+Alt+V (Paste Special)
5. Choose “Values”

The reason we do this is so that you don’t need to make the decision about what you want to paste until you actually do the paste operation, and you can paste several different things with one copy operation (you could paste values and formatting for example).

Hope that helps,
Dan [MS]

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • John McCallum commented  ·   ·  Flag as inappropriate

    I would like a way to select what the default CTRL+V paste option would be, as I too usually want to paste just values or formulas, but never formats. As far as I know, this option is not supported and we must go through three menu selections each paste. That is not too bad once you get used to it, but I suspect this is what Sertan was looking for, too.

Feedback and Knowledge Base