ExcelBanter - Alpha column references

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Alpha column references (https://www.excelbanter.com/excel-discussion-misc-queries/149027-alpha-column-references.html)

grono

Alpha column references

some how my excel sheet got into r1c1 format and I would like the column
references to go back to alpha. I have the new version of excel so I cannot
go to the options general tab. How can i do this?

Mike H

Alpha column references

Try,

Tools|options|general

Uncheck R1C1 style.

Mike

"grono" wrote:

some how my excel sheet got into r1c1 format and I would like the column
references to go back to alpha. I have the new version of excel so I cannot
go to the options general tab. How can i do this?

All times are GMT +1. The time now is 08:09 PM.