Column Labels

B

Brandon

All of my columns have been re-labeled from A,B,C...etc
to numbers. Instead of being in cell A1, I am now in
cell C1R1. This has thrown off a lot of formulas and
references I am using.

Anyone have any idea how to change these back?

Brandon
 
G

Gord Dibben

Tools>Options>Genral. Uncheck "R1C1 Reference Style".

Gord Dibben Excel MVP
 

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

Trying to create custom labels from an csv file + Need items numerically counted out 0
Display weeks from a Milestone 0
Automation of scanned file storage based on content 0
Excel 2007 change column labels from numbers to letters 8
determine a range using a formula 2
Excel 2013 Merge Data 2
Label alignment of XY-plot, center is a bit off. Any ideas? 0
Copy corresponding cell in Column B if cell in A contains certain text? 1

Top