If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Columns are numbers how to change to alphabet default
Help!
My Excel sheet has Numbers running down the side and numbers running on the top as well instead of the alphabets. When I create a new spreadsheet this is also the case. I guess it is a setting somewhere but I cant find where. or is this a bug, I dont really want to reinstall. Does anyone know the setting to change it back to use alphabet reference for columns Thanks |
#2
|
|||
|
|||
Columns are numbers how to change to alphabet default
Tools, options, general, uncheck R1C1 reference style
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "charlieb" wrote in message ... Help! My Excel sheet has Numbers running down the side and numbers running on the top as well instead of the alphabets. When I create a new spreadsheet this is also the case. I guess it is a setting somewhere but I cant find where. or is this a bug, I dont really want to reinstall. Does anyone know the setting to change it back to use alphabet reference for columns Thanks |
#3
|
|||
|
|||
Columns are numbers how to change to alphabet default
thankyou -----Original Message----- Tools, options, general, uncheck R1C1 reference style -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "charlieb" wrote in message ... Help! My Excel sheet has Numbers running down the side and numbers running on the top as well instead of the alphabets. When I create a new spreadsheet this is also the case. I guess it is a setting somewhere but I cant find where. or is this a bug, I dont really want to reinstall. Does anyone know the setting to change it back to use alphabet reference for columns Thanks . |
Thread Tools | |
Display Modes | |
|
|