ExcelBanter - excel colums and rows

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

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - excel colums and rows (https://www.excelbanter.com/setting-up-configuration-excel/173368-excel-colums-rows.html)

vic

excel colums and rows

my colums changed from letters to numbers. How do I change it back from R1,
C1 to A1

Dave Peterson

excel colums and rows

In xl2003 and below:
Tools|Options|General|Uncheck R1C1 reference style

vic wrote:

my colums changed from letters to numbers. How do I change it back from R1,
C1 to A1

--

Dave Peterson

All times are GMT +1. The time now is 06:50 AM.