ExcelBanter - Cell References

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

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

- - Cell References (https://www.excelbanter.com/excel-discussion-misc-queries/234992-cell-references.html)

wlarson

Cell References

I recently opened my Excel 2007 and found that the cell reference points had
changed from a Letter at the top of the spreadsheet to a number. How do I
change it back to a letter format?

Luke M

Cell References

Tools-Options-General, Uncheck the R1C1 style.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"wlarson" wrote:

I recently opened my Excel 2007 and found that the cell reference points had
changed from a Letter at the top of the spreadsheet to a number. How do I
change it back to a letter format?

All times are GMT +1. The time now is 03:57 AM.