Changing the headers on an excel worksheet from Numbers back to le

's Computer Specifications

Hi

I have somehow managed to change my worksheet default to have column numbers
rather than letters, and its driving me mad! Does anyone know how to change
them back?

Many Thanks

Maxine

's Computer Specifications

In xl2003 menus, it's:
Tools|Options|General Tab|Uncheck R1C1 Reference style

Excel picks up this setting from the first workbook you open in that session.

Maxine wrote:
>
> Hi
>
> I have somehow managed to change my worksheet default to have column numbers
> rather than letters, and its driving me mad! Does anyone know how to change
> them back?
>
> Many Thanks
>
> Maxine

--

Dave Peterson

's Computer Specifications

Tools|Options|General tab
uncheck R1C1
Regards
Cimjet
"Maxine" <(E-Mail Removed)> wrote in message
news:0BE03886-58A5-4439-AC51-(E-Mail Removed)...
> Hi
>
> I have somehow managed to change my worksheet default to have column
> numbers
> rather than letters, and its driving me mad! Does anyone know how to
> change
> them back?
>
> Many Thanks
>
> Maxine

's Computer Specifications

Try

Tools|Options|General
Un-Check R1C1 reference style

Mike

"Maxine" wrote:

> Hi
>
> I have somehow managed to change my worksheet default to have column numbers
> rather than letters, and its driving me mad! Does anyone know how to change
> them back?
>
> Many Thanks
>
> Maxine

's Computer Specifications

Thanks to all three of you - it worked!

"Cimjet" wrote:

> Tools|Options|General tab
> uncheck R1C1
> Regards
> Cimjet
> "Maxine" <(E-Mail Removed)> wrote in message
> news:0BE03886-58A5-4439-AC51-(E-Mail Removed)...
> > Hi
> >
> > I have somehow managed to change my worksheet default to have column
> > numbers
> > rather than letters, and its driving me mad! Does anyone know how to
> > change
> > them back?
> >
> > Many Thanks
> >
> > Maxine
>
>

's Computer Specifications

What if it's changing automatically?

What macro might I use to force it to keep R1C1 unchecked?

"Mike H" wrote:

> Try
>
> Tools|Options|General
> Un-Check R1C1 reference style
>
> Mike
>
> "Maxine" wrote:
>
> > Hi
> >
> > I have somehow managed to change my worksheet default to have column numbers
> > rather than letters, and its driving me mad! Does anyone know how to change
> > them back?
> >
> > Many Thanks
> >
> > Maxine

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel sheet with numbers as column & row headers - How?	cg-ksd	Microsoft Excel Misc	3	14th Dec 2009 09:40 PM
Excel Index of Worksheet Headers	Julie Cook	Microsoft Excel Discussion	2	10th Nov 2009 06:50 PM
Changing column headers from alphabetical characters to numbers?	dylan	Microsoft Excel Misc	2	24th Jul 2008 04:27 PM
Changing the Column Headers back to letters from #s	=?Utf-8?B?Y29hY2hfZmxldGNoZXI=?=	Microsoft Excel Misc	2	7th Jul 2006 03:20 PM
How to switch column headers from numbers back to letters?	=?Utf-8?B?TWVhc3VyZW1lbnQgQ29uc3VsdGFudA==?=	Microsoft Excel Worksheet Functions	2	14th Jan 2006 03:30 PM