![excel how to paste values shortcut excel how to paste values shortcut](https://i.ytimg.com/vi/6bLcvRb70_Y/maxresdefault.jpg)
Then, click Paste values only (or use the keyboard shortcut CTRL + SHIFT + V).Īs a result, the Word data is pasted to Column C in the Google spreadsheet with the same formatting already in Column C.Right-click the cell where you want to paste (C1).You can also paste data from the third application and match destination formatting in Google Sheets.įirst, copy the data. Match Destination Formatting in Google Sheets Instead of right-clicking a cell and choosing match destination format, you can just select that cell and click on this icon in the toolbar in order to paste data and keep the Excel formatting. Step 3: Now, click the drop-down of the Ctrl menu.
![excel how to paste values shortcut excel how to paste values shortcut](https://www.wallstreetmojo.com/wp-content/uploads/2019/12/Shortcut-Paste-Values-Example-4.png)
Step 2: Select Cell B11 to paste the data. Now the Paste and Match Destination Formatting icon is in the Toolbar. Step 1: First, select the data from the cell range of B4:C9 that we want to transpose. Select Paste and Match Destination Formatting in the list, click Add, and OK.
![excel how to paste values shortcut excel how to paste values shortcut](https://support.content.office.net/en-us/media/46a31607-9eac-44d0-83bc-5448de2f753d.png)