Columns are numbers how to change to alphabet default

C

charlieb

Help!

My Excel sheet has Numbers running down the side and
numbers running on the top as well instead of the
alphabets. When I create a new spreadsheet this is also
the case. I guess it is a setting somewhere but I cant
find where. or is this a bug, I dont really want to
reinstall. Does anyone know the setting to change it back
to use alphabet reference for columns

Thanks
 
P

Paul B

Tools, options, general, uncheck R1C1 reference style
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
G

Guest

thankyou :)
-----Original Message-----
Tools, options, general, uncheck R1C1 reference style
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **



.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to mention rows in alphetical format instea dof numbers 2
Excel columns 1
how to change the alphabets to numbers and numbers to alphabets in 2
VBA word change keys 0
How do i change the heading values in workbooks 1
Column headings to numbers and row headings to alphabets? 2
Column Headings (Excel 2007) 2
Changing column headers from alphabetical characters to numbers? 2

Top