columns read 1,2,3 rather than A,B,C

's Computer Specifications

Column headings are numbered rather than A B C. If I open a new worksheet, it
is also numbered. I probably had too many files open and Excel froze - I
couldn't close the files and had to shut down.

's Computer Specifications

Hi,

Go to Tools->Options, in the General tab, make sure "R1C1 reference style"
is NOT checked...

--
Hope that helps.

Vergel Adriano

"Clueless in Indio" wrote:

> Column headings are numbered rather than A B C. If I open a new worksheet, it
> is also numbered. I probably had too many files open and Excel froze - I
> couldn't close the files and had to shut down.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
trying to sum columns in which some cells read n/a	=?Utf-8?B?Q2FtYXJv?=	Microsoft Excel Misc	3	3rd Aug 2006 07:51 PM
Read value of all columns from datatable together	neeraj	Microsoft VB .NET	2	5th Jun 2006 06:13 PM
Read CSV - string Columns - Int columns	=?Utf-8?B?YmVub2l0?=	Microsoft ASP .NET	0	8th May 2006 03:11 PM
How do I get For Each C in Range to read columns first?	pedi	Microsoft Excel Discussion	2	22nd Sep 2005 10:32 PM
Read 500 columns of CSV data into a spreadsheet	=?Utf-8?B?QmlsbCBBbmRlcnNvbg==?=	Microsoft Excel Programming	1	2nd Jun 2005 11:51 AM