ExcelBanter - Excel Row & Column Labels

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel Row & Column Labels (https://www.excelbanter.com/excel-worksheet-functions/22385-excel-row-column-labels.html)

heartless866

Excel Row & Column Labels

How do I change the column labels in excel back to letters, right now both
rows and columns are labelled as numbers rather than rows-numbers,
columns-letters?

JE McGimpsey

Tools/Options/General uncheck the "R1C1 reference style" checkbox.

In article ,
heartless866 wrote:

How do I change the column labels in excel back to letters, right now both
rows and columns are labelled as numbers rather than rows-numbers,
columns-letters?

All times are GMT +1. The time now is 03:19 PM.