ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Column labels show as numbers (https://www.excelbanter.com/excel-discussion-misc-queries/246610-excel-column-labels-show-numbers.html)

mrudnet

Excel Column labels show as numbers
 
I am working in Excel 2007 and suddenly the columns are showing as numbers
and not the usual letters (A, B, C...). How do I change this back? Thanks.

Bob I

Excel Column labels show as numbers
 
office Button, Excel Options, Formulas, UNcheck "R1C1 reference style"

mrudnet wrote:

I am working in Excel 2007 and suddenly the columns are showing as numbers
and not the usual letters (A, B, C...). How do I change this back? Thanks.



JBeaucaire[_131_]

Excel Column labels show as numbers
 
Click the Office Button
Click the Excel Options
Go to Formulas tab
Go to Working with Formulas section
UNCHECK the R1C1 reference style


--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"mrudnet" wrote:

I am working in Excel 2007 and suddenly the columns are showing as numbers
and not the usual letters (A, B, C...). How do I change this back? Thanks.



All times are GMT +1. The time now is 05:46 AM.

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