Changing column names to letters

**esa** · 04-08-2010, 04:42 PM

in Excel 2007 can I change the columns names to Letters, such that the equation will use absolute cell name values and not relative positions ?

**Paul** · 04-08-2010, 04:44 PM

Hi Esa, welcome to the forum.

Are you saying that you currently have numbers down the left hand side and across the top, i.e. "R1C1" reference style?

In Excel 2003 you can change that to A1 style (numbers down left, letters across the top) in Tools -> Options -> General -> un-check R1C1 reference style.

In Excel 2007 click the Office button (top left) -> Excel Options -> Formulas -> un-check R1C1 reference style.

**esa** · 04-08-2010, 04:49 PM

I have Excel 2007. This system is Chinese for me (almost).

**esa** · 04-08-2010, 05:08 PM

My version is in Hebrew. When I Right click the Office Mark (which is in the upper right corner) I get the New, Open, Save, Save As, Print, Prepare, Send, Publish, Close. Is this the list you refer to ?

**esa** · 04-08-2010, 05:09 PM

Sorry, not right click, but tapping the pad.

**Paul** · 04-08-2010, 05:10 PM

Below and to the right of "Close" in that list you should see a button labeled 'Excel Options'. Click that, then click 'Formulas' and you'll see 'R1C1 reference style' in the right-hand window. Un-check that.