Keep Your Formatting
Did you try yesterday’s Paste Special trick in MS Excel? If so, did you find that the formatting of the cells, where the paste occurred, was gone?
If you did, I’m sure you’d like a way to prevent that transformation while the Paste Special does its thing, right?
Assuming that’s the case, I’m here to show you a small change you can easily accomplish while making your Paste Special choices.
As you choose which operation Excel should perform on the data, go ahead and select Values from the top portion of the dialogue window as well.
There you have it. No more formatting changes for you!