As an Auditor for I.T. my co-worker's expect me to be well versed in everything related to I.T. (which, I am not). Most of the time they come up to me with questions / problems that they encounter with their PCs or software. I try to help as much as I could especially if its just a small program tweak or an excel formula.
So starting today I will be posting here any questions / problems my co-workers encounter which I helped them solve. Other people may also experienced this problem and by posting it here I may also end up helping these people (although pressing F1 would probably give the same result).
Let's start with this one... An officemate needs to copy a formula with same cell reference. Of course my retort was the classic "press F1". The thing is she doesn't know what to look for in Excel Help. So I asked her to give me a few minutes while I figure out her quandary. And, of course, I pressed F1. To make sure I explain correctly I will just attach the help file from Microsoft.
Move or copy a formula
When you move a formula, the cell references within the formula do not change. When you copy a formula, the cell references may change based on the type of reference used.
1. Select the cell that contains the formula.
2. Verify that the cell references used in the formula will produce the result you want. Switch to the type of reference you need. To move a formula, use an absolute reference (absolute cell reference: In a formula, the exact address of a cell, regardless of the position of the cell that contains the formula. An absolute cell reference takes the form $A$1.).
3. On the Edit menu, click Copy.
4. Select the cell you want to copy it to.
5. To copy the formula and any formatting, on the Edit menu, click Paste.
6. To copy the formula only, on the Edit menu, click Paste Special, and then click Formulas.
