ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   The column name on Excel are numbers instead of letters (https://www.excelbanter.com/excel-discussion-misc-queries/143525-column-name-excel-numbers-instead-letters.html)

Sab

The column name on Excel are numbers instead of letters
 
Right now for some reason, I have numbers for both rows and columns' names. I
would like to go back to the original setting of having letters as columns'
names. Can anyone help? Thanks!


Treesy

The column name on Excel are numbers instead of letters
 
Go into Tools, Options, General and uncheck the R1C1 Reference Style box.

"Sab" wrote:

Right now for some reason, I have numbers for both rows and columns' names. I
would like to go back to the original setting of having letters as columns'
names. Can anyone help? Thanks!



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

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