column header labels are numbered but need to be lettered

's Computer Specifications

I need column heads to be lettered but both column and rows are numbered ..
help !

's Computer Specifications

Which version of Excel are you using?

In 2007 go to the office button and down to Excel Options, in the formula
tab unselect the checkbox labeled R1C1 reference style.

I am sure the same checkbox exists in earlier versions under Tools, Options
in the menu bar.

Hth
Stu

"solgash" wrote:

> I need column heads to be lettered but both column and rows are numbered ..
> help !

's Computer Specifications

Change under Excel Options.

--
Regards
Dave Hawley
www.ozgrid.com
"solgash" <(E-Mail Removed)> wrote in message
news:1447FEEA-BD1A-4F60-9AD5-(E-Mail Removed)...
>I need column heads to be lettered but both column and rows are numbered ..
> help !

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why are my columns numbered instead of lettered?	=?Utf-8?B?dmFseQ==?=	Microsoft Excel Misc	6	2nd Oct 2010 11:39 PM
Excel columns are now numbered instead of lettered	=?Utf-8?B?S2VsbHk=?=	Microsoft Excel Misc	4	21st Apr 2010 11:50 PM
My columns in excel are numbered rather than lettered-how to fix?	Ladybug	Microsoft Excel Misc	2	1st Mar 2010 09:14 PM
Columns are Numbered rather than lettered?	Firman	Microsoft Excel New Users	1	27th Nov 2007 07:22 AM
1) Numbered (and lettered) Lists 2) Spellcheck	Jack Tennier	Microsoft Access ADP SQL Server	1	21st Mar 2004 03:13 PM