How can I make the collumn headers in excel be letters rather tha.

I

Ian Hunt

I have just changed laptops and now excel shows its cell references as R1C1
for cell A1 how do i make it use letters for collumns?
 
J

Jason Morin

Go to Tools > Options. General Tab. Uncheck the box that
reads "R1C1 reference style".

HTH
Jason
Atlanta, GA
 
C

ChristinaC

Hi Ian,
Go into Tools, Options and the General Tab. In there untick the R1C1
reference style. This should then solve your problem.

Chris
 

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

Merging from an Excel file with graphics 1
Filling in cells (or not) based on the entry in a specific collumn 3
How to change collumn heading numbers into letters? 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
How to rename the head A,B,C,D,E etc. on every column 0
Column headers numbers instead of letters 2
Changing margins on 2nd page of letterhead template 4
code 'summing' - access query creating an excel-sheet 1

Top