New Keyboard Shortcut for Paste Values in Excel 365

If you're a fan of using keyboard shortcuts, you might have been eagerly awaiting the one for Paste Values in Excel. Well, the good news is that it's finally here, thanks to Microsoft's recent update.

While keyboard shortcuts may not be everyone's preferred method, they can be a game-changer for those who invest the time to learn a few and gradually expand their repertoire. The time saved and increased efficiency gained through mastering these shortcuts can lead to improved productivity, greater accuracy, and faster spreadsheet management and navigation.

Paste Values in Excel is an essential feature that enables you to copy then paste unchanging, static values derived from calculations into other cells or cell ranges. Typically, when you copy data in Excel, it includes not just the values but also the formatting and associated calculations. While this is necessary in many cases, there are instances where you specifically need to copy and paste values without the underlying calculations. This is where Paste Values comes into play.

You can find Paste Values as an option on the Paste button, but it can now also be activated using a keyboard shortcut:

Ctrl + Shift + V

Paste Values is an invaluable function within Excel, ensuring that the transferred data remains constant and unaltered, unaffected by changes in the source data.

If you've got any questions about this feature or any others, please feel free to get in touch. We are happy to answer any questions you may have.

We use cookies, which are placed on your computer or other device. By using this site, you agree to such cookies being used. To find out more please see our cookies policy.