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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Go to Tools > Options. General Tab. Uncheck the box that
reads "R1C1 reference style".

HTH
Jason
Atlanta, GA
 
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

Showing Letters For Column Headers Rather Thann Numbers ? 1
How to change collumn heading numbers into letters? 1
Filling in cells (or not) based on the entry in a specific collumn 3
Excel - reference to cell 1
Column headers numbers instead of letters 2
Using zero's for the first number in excell collumns 5
How can I change column designation from number to letters? 3
Making a CSV from several collumns in excell 3

Back
Top