ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   in excel, workbook column heading is displaying numbers not lette. (https://www.excelbanter.com/excel-discussion-misc-queries/260750-excel-workbook-column-heading-displaying-numbers-not-lette.html)

Dawn

in excel, workbook column heading is displaying numbers not lette.
 
in excel 2007 when i open up a new page i noticed that the top default
heading show number instead of letters. ex: horizontal should be numbers and
vertical should be letters

Emece

in excel, workbook column heading is displaying numbers not lette.
 
In Excel, click on Tools | Options | General tab | uncheck the
"R1C1 reference style" box | OK.


"dawn" wrote:

in excel 2007 when i open up a new page i noticed that the top default
heading show number instead of letters. ex: horizontal should be numbers and
vertical should be letters


trip_to_tokyo[_3_]

in excel, workbook column heading is displaying numbers not lette.
 
In EXCEL 2007:-

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Formulas

- make sure that there is no tick (check) in the box called:-

R1C1 reference style

If my comments have helped please hit Yes.

Thanks.



"dawn" wrote:

in excel 2007 when i open up a new page i noticed that the top default
heading show number instead of letters. ex: horizontal should be numbers and
vertical should be letters



All times are GMT +1. The time now is 08:18 PM.

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