ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column and Row Labels (https://www.excelbanter.com/excel-discussion-misc-queries/173591-column-row-labels.html)

Girly821

Column and Row Labels
 
On every excel worksheet I have seen, the labels are A,B,C for columns and
1,2,3 for rows. On my excel worksheets they both are numeric. How do you
change it back to one is alpha and the other is numeric?

PCLIVE

Column and Row Labels
 
Tools-Options-General (Tab).
Uncheck R1C1 reference style.

Regards,
Paul

--

"Girly821" wrote in message
...
On every excel worksheet I have seen, the labels are A,B,C for columns and
1,2,3 for rows. On my excel worksheets they both are numeric. How do you
change it back to one is alpha and the other is numeric?





All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com