Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel column headings to be letters not numbers?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel column headings to be letters not numbers?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel column headings to be letters not numbers?
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel column headings to be letters not numbers?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Headings showing numbers instead of letters | Excel Discussion (Misc queries) | |||
Help, my column headings have turned from letters into numbers! | Excel Discussion (Misc queries) | |||
My Excel column headings were letters and it switched to numbers? | Excel Discussion (Misc queries) | |||
column headings in numbers vs letters | Excel Discussion (Misc queries) | |||
Excel column headings from numbers to letters | Excel Discussion (Misc queries) |