Google Product Forums

Re: Hi! I would really appreciate a keyboard shortcut for special pasting of only values. Thanks for all your work!


Joseph Stein Dec 5, 2011 9:00 AM
Posted in group: Google Docs

Categories: Ask a "how-to" question : Sheets :

Thanks for answering.

See, I mean, when you are in Google Docs spreadsheets and you want to copy data from one spreadsheet to another, but you want to copy only data values without cells formatting.

For example, if you are working with a spreadsheet in Google Docs and you copy data to the clipboard (i.e. by selecting a group of cells and then pressing "Ctrl+C"), and then you place the cursor in another spreadsheet, then you have various options for pasting what it is in the clipboard:

1- To paste data all together with the format of the original cells. For doing that you can click to "Edit" in the menu and then click to "Paste", or you can just press "Ctrl+V".

2- To paste only data, without the format of the original cells. This is the option I mean. For doing that you can click to "Edit" in the menu and then click to "Paste Special" and then to "Paste values only", so, you can only do that by following those options on the menu, and there is not a keyboard shortcut, which is what I'd like to have, if possible.

Thank you.