Although Excel 2013 offers many options for performing calculations in new cells using data from existing cells, sometimes you want to work on data in the original cells. As an example, you might have ...
It’s not easy to fool Excel, but with a few extra clicks, you can work around this odd pasting behavior. If you paste formatted values into a cell with another applied format, the pasted format wins.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results