|
| 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
February 25th, 2009, 03:31 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
column labels
My column labels start apearing as numbers instead of letters A, B, C...
I want letters back as formulae are easier to read with A,B,C rather than R[-2] etc 
|
|
#2
February 25th, 2009, 03:44 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
column labels
In XL 20003 (an before): Tools / Options / General tab / uncheck first item
"R1C1 reference style" In XL 2007: Office / Excel options / Formulas tab / Working with Formulas (second group), uncheck first item "R1C1 reference style" best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Djolexyz" wrote in message ... My column labels start apearing as numbers instead of letters A, B, C... I want letters back as formulae are easier to read with A,B,C rather than R[-2] etc
|
|
#3
February 25th, 2009, 04:04 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
column labels
Perfect! Thanks a lot.
"Bernard Liengme" wrote: In XL 20003 (an before): Tools / Options / General tab / uncheck first item "R1C1 reference style" In XL 2007: Office / Excel options / Formulas tab / Working with Formulas (second group), uncheck first item "R1C1 reference style" best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Djolexyz" wrote in message ... My column labels start apearing as numbers instead of letters A, B, C... I want letters back as formulae are easier to read with A,B,C rather than R[-2] etc
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
