Column labels changed from A,B,C to 1,2,3

  • Thread starter Thread starter Brandon
  • Start date Start date
B

Brandon

My cells are not A1, B2, C3 etc.. anymore. Now they have
changed to R1C1, R2C2 etc.. I don't know how or why they
changed but they are throwing off a lot of my formulas
and references. Can anyone help me change my columns
back to letters?

Thanks,
Brandon
 
Tools>options>general and uncheck R1C1 reference style

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

Excel Help to copy information from one row at a time to another sheet 1
Columns headings have changed to numbers instead of letters 2
How can change column title back to alphabet (A,B,C..) 2
Convert numbers 1,2,3,etc to A,B,C,etc. 2
Write formula for simple copy and paste to another cell 1
How do I increment the row and column of a cell in a formula? 2
Vlookup for Column b 1
Change Column gridlines headings A,B,C.....versus 1,2,3.... 1

Back
Top