For example, I have a formula that uses both absolute and relative references that I want to automatically put into other cells using another formula. However, whenever I try this, the value of the original cell is copied and not the formula itself. My only option right now is to copy the original formula each time into the desired cells. Does anybody have any ideas? [Note: I understand absolute and relative references and do not need help with those concepts.] Thank you.
2007-02-26 03:38:12 · 4 answers · asked by Greg 1 in Computers & Internet ➔ Software
I am asking about copying a formula from another formula. I understand how to copy and paste. Example: if cell A1 = A2 + 26; A2 = 4. How do I reference the formula, not the value in the following: B1 = A1? I want B1 to be: B2 + 26. I want to keep B1 = A1, but I also want the original formula to copy, not the value of the original formula. It would be useful in some instances. Thank you
2007-02-26 08:31:53 · update #1
Now that you edited, I think i see what you want. If you need them on the same page, you might be stuck copying cell by cell so you can add an apostrophe, but if you just want to toggle between formula and value on the whole spreadsheet, that can be done. I couldn't find a function that does exactly what you are looking for. This might help though:
Go to Tools-Options and on the View tab, click Formulas, and you'll be looking at formulas instead of values. Also, adding the Formula Auditing toolbar will help you trace errors in the formulas by showing visually where the variables come from and lead to.
I'll see if I can come up with something better, but I doubt it.
2007-02-26 03:41:31 · answer #1 · answered by wayfaroutthere 7 · 0⤊ 1⤋
Just highlight the cells with the formula you want to use and then click the bottom right hand corner of the last cell you highlighted and drag it down or right depending on where your putting the formulas.
2007-02-26 03:42:44 · answer #2 · answered by sandee 2 · 0⤊ 1⤋
In the formula bar, drag and copy the whole formula.
Go to the other cell, again in the formula bar, paste the formula & edit or add to the forumula.
2007-02-26 15:15:12 · answer #3 · answered by unnga 6 · 0⤊ 1⤋
Your additional details are confusing. You say, "I want B1 to be: B2 + 26." However, in the next sentence you say, "I want to keep B1 = A1..."
What is the exact formula you want in B1?
2007-02-26 10:17:12 · answer #4 · answered by Joliet Jake 3 · 0⤊ 1⤋