Making "paste value" and "paste format" easier

We often want to "paste values" or "paste formats" into a cell. The native Excel keystrokes are cumbersome, and the ribbon commands are unintelligible.

The native Excel keystroke for paste value is Alt, H, V, V.
For paste format, it's Alt, H, V .... and then god knows what.

I mean what on earth do any of these options mean?

We've simplified this with a couple of additional Productivity Pack macros:

Paste format


Paste values



Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.

Subscribe to Financial Modelling Handbook

Don’t miss out on the latest financial modelling guides. Sign up now to get access to the library of members-only guides.