Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 67
  • Last Modified:

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
0
GST-GRIDTECH
Asked:
GST-GRIDTECH
  • 4
  • 4
1 Solution
 
yo_beeDirector of ITCommented:
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
 
yo_beeDirector of ITCommented:
I am not sure exactly what that image illustrates.
I see values for a formula in the cell and not the formula.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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
 
yo_beeDirector of ITCommented:
so you what to see =K7 + L7 in the cell rather than the value 15
0
 
GST-GRIDTECHAuthor Commented:
yes
0
 
yo_beeDirector of ITCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now