Excel 2007 : PC just reformatted all my spreadsheets!

**eisman** · 04-27-2011, 01:12 AM

Help!

As noted above I turned on my PC this morning and all my spreadsheets now have columns with numbers instead of letters. This has caused some of the formulas to go berserk. Anybody know how I can change the column headings back?

**pike** · 04-27-2011, 01:19 AM

Hi eisman
Welcome to the forum , this seams to be happing a lot . you will have to change the files setting by looking in thecommanad bar and selecting
file>options>Formulas
Uncheck R1C1 reference style

**eisman** · 04-27-2011, 01:58 AM

Pike;

Thanks for the assist.

Now, I'm feeling kind of stupid, because I cannot find that selection/option. Is is under a specific tab? This is driving me nuts, because it's obviously something in a place I don't use and I do formulas and spreadsheet daily.

**pike** · 04-27-2011, 02:18 AM

hmmm.. Im not using 2003 but it should be the top first upper right select "File"
then in that dropdown find "Options" ect... it will be in the setting some where your looking for R1C1

**eisman** · 04-27-2011, 02:32 AM

Pike;

I'm in 2007; if it was 2003 it would be easier.

But thanks again; you gave me a reference that I could work from. I really hate the "buttons/tabs" approach MS seems to dumb down to.

Got it fixed, and made notes for the rest of my crew in case they get stuck.

Kevin

**pike** · 04-27-2011, 02:45 AM

Dude you should change your profile something like to 2007 home 2003 work
Glad to hear you found it
If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save