Top Excel Power Shortcut #2: Converting formulas to values

Published by | Monday, August 9th, 2010

We’re very excited about our upcoming course, Excel 2010 Power Shortcuts with Dennis Taylor, that’s due to be released soon—so excited that we’ve decided to give you a sneak peek at some of his top power shortcuts. Here’s the second:


If you want to convert formulas to values in Excel, you don’t need to use a multi-step copy and paste process. This time-saving shortcut shows how you can convert formulas with a simple drag.

Did you miss the first top shortcut? Watch Top Excel Power Shortcut #1: Entering the same data into nonadjacent cells.

Share this:Share on Facebook0Tweet about this on Twitter0Share on Google+0Pin on Pinterest0Share on LinkedIn0

lynda.com - start learning today

Tags: ,


One Response to “Top Excel Power Shortcut #2: Converting formulas to values”

  1. Dennis says:

    I’ve been using Excel for over 20 years. I find something new every month. I keep kicking myself for not taking a course decades ago. I’ve probably wasted hundreds of hours because of lack of knowledge, although I have several Excel text books. (I did take a course in Lotus, but the professor’s text had so many errors, she skipped the first two chapters and I dropped the course.

    I am interested to see what more you have to offer. I am not sure just yet how I would use your impressive first three examples in my projects.

    Dennis

Leave a Reply