ExcelBanter - How can I change the settings on the row headers/

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

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

- - How can I change the settings on the row headers/ (https://www.excelbanter.com/excel-worksheet-functions/70076-re-how-can-i-change-settings-row-headers.html)

Kevin Vaughn

How can I change the settings on the row headers/

Sounds like you accidentally turned on R1C1 view. Go into
Tools/Options/General and uncheck R1C1 reference style.

--
Kevin Vaughn

"Ngozi Nmezi" wrote:

How can I change the section on the row header so that the cells identities
are classified by alphabets and not numbers. example A1, A2, A# and NOT C2
R28, or C2 R45 and so on. This number setting is confusing?

All times are GMT +1. The time now is 01:22 AM.