Prev: Disable Email as Attachment
Next: Match formula
From: jtoy on 21 Apr 2010 18:50
For MS Excel 2007 versions go to:
Excel Options > Formulas > Working with formulas > Uncheck R1C1 reference
style.

"Dave Peterson" wrote:

> Excel picks up this setting from the first workbook opened in that session.
>
> If you happen to open a workbook that was saved in R1C1 reference style as the
> first workbook in that session, you'll see those numbers.
>
> So you'll want to remember how to toggle this setting.
>
>
> Kelly wrote:
> >
> > Awesome! It worked. Now I can't help but wonder how in the world that
> > setting got changed in the first place. It was so weird--I had forwarded it
> > to other computers and it would be "normal." Thanks so much for your help!
> >
> > "Barb Reinhardt" wrote:
> >
> > > Try Tools -> Options -> General
> > > Uncheck R1C1 reference style
> > >
> > >
> > > "Kelly" wrote:
> > >
> > > > Suddenly the columns in my Excell worksheet are numbered, not lettered. My
> > > > old worksheets are fine. However, when I open the program to a fresh
> > > > spreadsheet or go to this current one, both rows and columns are numbered.
> > > > My current worksheet has correct "answers" for formulas, but the actual
> > > > formulas are now really weird. Help! I've tried Help, Detect & Repair.
>
> --
>
> Dave Peterson
>
 | 
Pages: 1
Prev: Disable Email as Attachment
Next: Match formula