Excel and Formulas

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.

Thank you
GST-GRIDTECHAsked:
Who is Participating?
 
yo_beeConnect With a Mentor Director of Information TechnologyCommented:
so you what to see =K7 + L7 in the cell rather than the value 15
0
 
yo_beeDirector of Information TechnologyCommented:
you need to enable "Show formulas in cells instead of their calculated results" or toggle between the results or formula using Ctrl + `  (key next to the 1)

Here is a good link that will explain it better than I can.
https://www.ablebits.com/office-addins-blog/2016/01/13/show-formulas-excel/
0
 
GST-GRIDTECHAuthor Commented:
Hi Yo_bee

i see what you mean  by  Show formulas in cells instead of their calculated results" or toggle between the results or formula using Ctrl + `

but that seems to be in addition to the example image i have attached..
excel.jpg
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
yo_beeDirector of Information TechnologyCommented:
I am not sure exactly what that image illustrates.
I see values for a formula in the cell and not the formula.
0
 
GST-GRIDTECHAuthor Commented:
That an example of what I'm trying to get for the user.

The formulas to show like in the example image
0
 
GST-GRIDTECHAuthor Commented:
yes
0
 
yo_beeDirector of Information TechnologyCommented:
if a Cell has a formula and you press the key combination CTRL + ` it will show the formulas in all the cells rather than the value of the results.
0
 
GST-GRIDTECHAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.