About This Shortcut
A common task in Excel is to copy and paste unformatted text into a worksheet, or to copy and paste a formula as a value. Traditionally, the Paste Special dialog box has been the best way to do this. However, this new shortcut removes the extra step. Basically, this shortcut in windows that behaves like Paste Special > Values. In other words, it will paste content from the clipboard as values only:
- If the clipboard contains formatted text, the formatting will be removed
- If the clipboard contains a formula, the formula will be removed
In versions of Excel that don't have this shortcut, you can use a two-step process:
- Use Command + Option + V to open Paste Special
- Type "v" to select "Values", then press OK
Note: this feature is currently beta only, available to Beta Channel users running Version 2210 (Build 15726.20000) or later in Excel for Windows. A dedicated Mac shortcut is expected in the future. The official announcement is here.