Microsoft Excel has many keyboard shortcuts, but surprisingly, paste without formatting is not one of them. That’s finally changing with a new update that Microsoft is testing.
Microsoft said in a blog post: “It’s common to copy text from a web page, email, or other document and then paste it into Excel. Often your goal is to match formatting that’s already in the cell or range you’re pasting into. Until now, it was not possible to paste as plain text using shortcut keys.”
Microsoft has released a new keyboard shortcut in Excel for Windows, starting in the Office Insiders beta channel with version 2210 (build 15726.20000) or later. You can now press Ctrl + Shift + V to paste content into an Excel sheet without also pasting the original formatting, unlike the usual Ctrl + V shortcut, which preserves the original text formatting.
The new shortcut to paste Microsoft
There were already some ways to paste in Excel without formatting, such as with the Paste Options flyout that appears after you paste content, or by opening the Paste Special dialog with Ctrl + Alt + V and selecting “Text”. However, they all require more than a mouse click or keyboard press, which ultimately fixes the new shortcut.
Microsoft says the option is “coming soon” to Excel for Mac.
Source: Office Blog