How do I change excel sheet from R1C1 for cells to A1 for cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

plock - 16 Aug 2006 21:23 GMT

I'm working in an excel spreadsheet that has a row of "1" and a column of "1"
resulting a cell being R1C1. How do I change that be a row of "1" column of
"A"? And why wont it let me copy my formulas into other fields?

Reply to this Message

Niek Otten - 16 Aug 2006 21:28 GMT

Tools>Options>General tab, Uncheck R1C1 Reference style
I don't know what you mean: "wont let me copy" What happens?

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm working in an excel spreadsheet that has a row of "1" and a column of "1"
| resulting a cell being R1C1. How do I change that be a row of "1" column of
| "A"? And why wont it let me copy my formulas into other fields?

Reply to this Message