Replace formulas with values using this shortcut [quick tip]

Often in my work, I need to replace a bunch of formulas with values. Blame it on old habits, but this is what I used to do:

1. Copy the cells with formulas (CTRL+C)
2. Press ALT+ESV and then enter.

While this is ok, it does take quite a bit of time and key strokes.

Here is a shorter way I recently learned…

1. Copy the cells with formulas (CTRL+C)
2. Press menu key and then v
3. Done!

You can also right click after step 1 and press v. works just the same.

What about you? How do you save time when working with Excel?

Using keyboard shortcuts is one of the best ways to save time when working with Excel. When you combine this with strong knowledge of formulas (related: top 10 formulas for analysts) you will be on your way to Excel ninja status.

What about you? what techniques you use to save time when working with Excel? Please share your tips & ideas using comments.

More on keyboard shortcuts:

If keyboard shortcuts are your thing, go thru below to pick up a few more:

• 5 keyboard shortcuts to write better formulas
• 10 keyboard shortcuts I can’t live without
• Comprehensive list of Excel keyboard shortcuts
• Do not forget mouse shortcuts!
• Game: How fast can you finish this Excel challenge with keyboard?