An curved arrow pointing right. The tool "Paste Special" in Excel can do so much more than just pasting values or formats. Here's how you can use it to transform your data in a variety of ...

Excel lets you choose more specifically which elements you want to paste into the selected cell ... and Ctrl+C in the cell containing the formula you want to copy, and then F2 and Ctrl+V where ...

There is nothing more frustrating than when someone pastes a value on top of a formula in your spreadsheet. This can ruin a beautiful excel model. And it can take awhile to fix because you have to ...