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.