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

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

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

thanks much...worked perfectly!

"JLatham" wrote:

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