Excel and Formulas
Posted on 2016-10-25
Hi I have what I hope is a relatively simple question.
I have a user that is simply trying to copy a small area of cells to another worksheet, that is an updated version of the source.
The range being copied has formulas and when pasted on the updated sheet, I can't seem to make the formulas visible. Just seems to show the results of the formula and not the formula as well.
I'm pretty sure the range pasted to is not protected or else I wouldn't be able to paste to that range.
I just cant seem to figure out how the formulas are visible
in the source, but not seen in the destination after I paste ?
Any direction on this would be helpful.
I did forget the Exact Excel version, but it is either 2010 or 2013 for sure.