January 16, 2013

treating Excel formulas as actual values

This is one of my all time favorite things to know about Excel. Often times, you'll create a column whose values are the result of a formula calculation. If you've ever tried to copy that column and paste it somewhere else, you'll notice that it goes haywire. That's because what you're actually doing is copying the formula. What you're trying to do is copy and paste the VALUES.

In fact, this is quite easy to do. Just copy the column and then right-click and choose "Copy Special," and choose "Values." That's it.

No comments:

Post a Comment