|
| 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
June 9th, 2008, 06:06 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 change column labels from numbers to letters
I am working in Excel 2007. Currently the column labels are showing up as
numbers naming cells as R1C1 etc. I'd much rather use letters for the column labels so the cells will be the usual A1, B2 etc. I've searched the help menus and have been unable to find out how to do this. 
|
|
#2
June 9th, 2008, 07:37 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2007 change column labels from numbers to letters
Office ButtonExcel Options
On the Formulas tab check or uncheck R1C1 reference................ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Victoriah" wrote in message ... I am working in Excel 2007. Currently the column labels are showing up as numbers naming cells as R1C1 etc. I'd much rather use letters for the column labels so the cells will be the usual A1, B2 etc. I've searched the help menus and have been unable to find out how to do this.
|
|
#3
June 10th, 2008, 05:12 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2007 change column labels from numbers to letters
Thanks, Ron! I knew there had to be a simple fix. I just couldn't find it.
"Ron de Bruin" wrote: Office ButtonExcel Options On the Formulas tab check or uncheck R1C1 reference................ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Victoriah" wrote in message ... I am working in Excel 2007. Currently the column labels are showing up as numbers naming cells as R1C1 etc. I'd much rather use letters for the column labels so the cells will be the usual A1, B2 etc. I've searched the help menus and have been unable to find out how to do this.
|
|
#4
July 3rd, 2008, 06:35 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2007 change column labels from numbers to letters
Ron
I am having same problem and I read your reply and can't fiure out what you mean. Can you help me too? Susan "Ron de Bruin" wrote: Office ButtonExcel Options On the Formulas tab check or uncheck R1C1 reference................ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Victoriah" wrote in message ... I am working in Excel 2007. Currently the column labels are showing up as numbers naming cells as R1C1 etc. I'd much rather use letters for the column labels so the cells will be the usual A1, B2 etc. I've searched the help menus and have been unable to find out how to do this.
|
|
#5
July 3rd, 2008, 06:44 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2007 change column labels from numbers to letters
Hi Susan
The Office Button is the big round circle next to the Home tab on the ribbon. Click on it and you see a "Excel Options" button. Click on Formulas and uncheck the R1C1 option in the "working with formulas" section -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Susan" wrote in message news  Ron I am having same problem and I read your reply and can't fiure out what you mean. Can you help me too? Susan "Ron de Bruin" wrote: Office ButtonExcel Options On the Formulas tab check or uncheck R1C1 reference................ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Victoriah" wrote in message ... I am working in Excel 2007. Currently the column labels are showing up as numbers naming cells as R1C1 etc. I'd much rather use letters for the column labels so the cells will be the usual A1, B2 etc. I've searched the help menus and have been unable to find out how to do this.
|
|
#6
July 3rd, 2008, 06:58 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2007 change column labels from numbers to letters
Yikes - I'm no programmer - I'm sorry - can you explain where this "Home" tab
and ribbon are? Is this Visual Basic? "Ron de Bruin" wrote: Hi Susan The Office Button is the big round circle next to the Home tab on the ribbon. Click on it and you see a "Excel Options" button. Click on Formulas and uncheck the R1C1 option in the "working with formulas" section -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Susan" wrote in message news Ron I am having same problem and I read your reply and can't fiure out what you mean. Can you help me too? Susan "Ron de Bruin" wrote: Office ButtonExcel Options On the Formulas tab check or uncheck R1C1 reference................ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Victoriah" wrote in message ... I am working in Excel 2007. Currently the column labels are showing up as numbers naming cells as R1C1 etc. I'd much rather use letters for the column labels so the cells will be the usual A1, B2 etc. I've searched the help menus and have been unable to find out how to do this.
|
|
#7
July 3rd, 2008, 07:04 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2007 change column labels from numbers to letters
I figured out! Thanks!
"Ron de Bruin" wrote: Hi Susan The Office Button is the big round circle next to the Home tab on the ribbon. Click on it and you see a "Excel Options" button. Click on Formulas and uncheck the R1C1 option in the "working with formulas" section -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Susan" wrote in message news Ron I am having same problem and I read your reply and can't fiure out what you mean. Can you help me too? Susan "Ron de Bruin" wrote: Office ButtonExcel Options On the Formulas tab check or uncheck R1C1 reference................ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Victoriah" wrote in message ... I am working in Excel 2007. Currently the column labels are showing up as numbers naming cells as R1C1 etc. I'd much rather use letters for the column labels so the cells will be the usual A1, B2 etc. I've searched the help menus and have been unable to find out how to do this.
|
|
#8
November 5th, 2008, 06:30 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2007 change column labels from numbers to letters
I have the same problem but with Excel 2008 for MAC. Any solutions? thnaks
"Victoriah" wrote: I am working in Excel 2007. Currently the column labels are showing up as numbers naming cells as R1C1 etc. I'd much rather use letters for the column labels so the cells will be the usual A1, B2 etc. I've searched the help menus and have been unable to find out how to do this.
|
|
#9
May 29th, 2010, 11:21 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2007 change column labels from numbers to letters
"Ron de Bruin" wrote: Office ButtonExcel Options On the Formulas tab check or uncheck R1C1 reference................ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Victoriah" wrote in message ... I am working in Excel 2007. Currently the column labels are showing up as numbers naming cells as R1C1 etc. I'd much rather use letters for the column labels so the cells will be the usual A1, B2 etc. I've searched the help menus and have been unable to find out how to do this.
|
|
#10
November 29th, 2010, 09:18 AM
|
|||
|
|||
|
Quote:
Open Excel and click on the "Excel" menu option in the furthest top left corner. Scroll down and select "Preferences" from the menu selections. A new window will pop up.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
