If you’re a fan of Microsoft Excel, you’ll be happy to know that they’ve just released a new keyboard shortcut that can save you a lot of time when pasting data. The new shortcut is Ctrl+V (or Cmd+V on Macs), and it will automatically paste the data into the current cell without formatting it. This is great news if you’re often copying and pasting data from one cell to another, because it will save you a lot of time formatting it each time. This new keyboard shortcut is available in both Excel 2016 and 2017, so if you’re using either of those versions of the software, be sure to check it out. ..
Microsoft Excel has many keyboard shortcuts, but surprisingly, the option to paste without formatting isn’t 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, an email, or another document, and then paste it into Excel. Often, your goal is to match the format that’s already in place in the cell or range where you’re pasting. Until now, it was not possible to paste as plain text using shortcut keys.”
Microsoft has rolled out 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 retains the original text formatting.
There were already a few ways to paste in Excel without formatting, like with the floating Paste Options box that appears after pasting content, or opening the Paste Special dialog with Ctrl+Alt+V and selecting “Text.” However, all of those require more than one mouse click or keyboard press, which the new shortcut finally fixes.
Microsoft says the option is “coming soon” to Excel for Mac.
Source: Office Blog
