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.
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
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,
1 commentComments are closed
John McCallum commented
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.