1) Which version of Excel are you using
2) Do you mean the column letters on top, or relative reference during recording a macro, or something else
Ok, click the Developer tab on the Ribbon, then click the Use Relative References button so it gets highlighted, as shown below
That should do it
Perhaps you are expecting something else from this option. Can you give an example showing that it is not working
This is not in the macro recording mode is it?
Ok, you need to use $ signs with the cell references in the formula so it can act as an absolute or a relative reference
Here, in this sample file the formula in E6 is relative, and the one in E7 is absolute
Copy E6 to F6, and copy E7 to F7 to see the difference
Press these 4 keys together and let me know if values in the cells change
CTRL + SHIFT + ALT + F9
Ok, that has nothing to do with absolute and relative reference, it is just that your calculation is set to Manual.
Click the Office button > Excel Options > Formulas tab (on the left pane), then select Automatic, and click OK
You said you have Excel 2007, so here is the Office Button in Excel 2007
Ok I will send you more screenshots. I think at this point it would be appropriate to click the Accept button
After you click the Office button, you should get this dialog box. At the bottom you will find the Excel Options button
Let me know so we can go to the next step
I sent you a new screenshot, did you see my last post?