Windows Mac
CtrlShiftV VV

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:

  1. Use Command + Option + V to open Paste Special
  2. 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.

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.