How do I restore column & row cell references

's Computer Specifications

When I open a workbook, my column headers display as numbers rather than the
alpha characters. When I build formulas, the cell reference is for example
RC(-1). How can a restore the colums in my workbook to display as A, B, C...
and cells to show as A2, etc?

's Computer Specifications

Hi
Tools>Options>General>uncheck the R1C1 option.

--
Regards

Roger Govier

"emitch511" <(E-Mail Removed)> wrote in message
news:415A1FB4-AADD-45D6-A911-(E-Mail Removed)...
> When I open a workbook, my column headers display as numbers rather
> than the
> alpha characters. When I build formulas, the cell reference is for
> example
> RC(-1). How can a restore the colums in my workbook to display as A,
> B, C...
> and cells to show as A2, etc?

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
use cell references for same function in column cells	Sonic	Microsoft Word Document Management	2	5th Oct 2009 12:35 AM
Retain cell references when column moves	Marlene	Microsoft Excel Charting	4	10th Jan 2009 09:22 PM
how do I change cell references in a column	=?Utf-8?B?UGF0dHk=?=	Microsoft Excel Worksheet Functions	2	9th Aug 2006 12:59 PM
Any way to change all references to one column (in a cell) to another column?	ModelerGirl	Microsoft Excel Misc	2	28th Feb 2004 12:57 AM
References last cell in a continually lengthening column.	Jeff Brown	Microsoft Excel Worksheet Functions	1	5th Aug 2003 01:27 AM