So using the keyboard shortcut Control + Control + V once you have copied and pasted the data, would remove all the formatting and you would be left with non-formatted text only. While you can click and then see all the options available to you (including the option to only paste values), you can also get the same options by hitting the control key twice (in quick succession). Whenever you copy and paste in Excel, it shows a ‘Paste Options’ icon at the bottom right part of the pasted data. Hit the control key twice in quick succession.this would paste the data as well as the formatting from the copy data Paste the data as you would normally do (such as using Control + V).If you’re not a big fan of memorizing a lot of keyboard shortcuts, while still being able to use only your keyboard to copy formatted text but paste only the non-formatted text in excel, you can use the steps below: If you’re using a Mac instead of a Windows PC, use the below keyboard shortcut to paste only the values and strip all the formatting from the copied cells Option + Shift + Command + V Alternate Shortcut to Paste Non-Formatted Text in Excel Also read: How to Copy and Paste in Excel Without Changing the Format? Keyboard Shortcut to Paste Without Formatting in Excel (Mac) To use this keyboard shortcut, you will first have to copy the cell or range of cells from which you only want to get the values, then select the destination cell where you want to paste these values, and then use the above keyboard shortcut. The above keyboard shortcut opens the paste special dialog box, and selects the option not only pastes the values (i.e., non-formatted text) You need to press these keys in succession, ALT then E then S, and then V. Keyboard Shortcut to Paste Without Formatting in Excel (Windows)īelow is the keyboard shortcut to paste without formatting in Excel: ALT + E + S + V Alternate Shortcut to Paste Non-Formatted Text in Excel.Keyboard Shortcut to Paste Without Formatting in Excel (Mac).Keyboard Shortcut to Paste Without Formatting in Excel (Windows).

Mac paste shortcut text only