|
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 |
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 |
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 |
| All times are GMT +1. The time now is 05:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com