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

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

Guest

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?
 
Tools>Options>General tab, Uncheck R1C1 Reference style
I don't know what you mean: "wont let me copy" What happens?

--
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?
 
You must log in or register to reply here.

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

Procedure to change Column heading from R1C1 to A1? 2
Scrabble Value calculation for Welsh words 0
R1C1 referencing 4
Using a cell value for row in R1C1 2
Using R1C1 stylewithin A1 style 1
R1C1 formula question 2
Columns are numbers (instead of letters). How to revert? XLS 1
Columns headings have changed to numbers instead of letters 2

Back
Top