Click the Office button and the Excel Options at the bottomed.

Select Formulas from the left hand pane.

R1C1 reference style is in the Working with formulas section.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I'm not at a machine with 2007 on it right now and don't have it all
memorized yet. But the equivalent of Tools | Options is to click on the
"office button" at the upper left of the window, then near the lower right
corner of that window is a link "Options" - should be in there somewhere.
If
no one comes up with the map to it beyond that, I'll give more detail once
I
get to a machine with 2007 on it.

"Beas2007" wrote:

I just got a new HP with Vista and Excel 2007 and the worksheet is
formatted
in the R1C1 reference style (numbers along the top vs. letters). I can't
figure out how to change it to have letters on top.

In the old version it was done through
ToolsOptionsGeneralSettingsR1C1
reference style. I can't find where the "Tools" command is as the new
layout
for Excel is totally different. Can anyone help?!

thanks,
Gary