ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel column headers (https://www.excelbanter.com/excel-discussion-misc-queries/62668-excel-column-headers.html)

Tara

Excel column headers
 
The column headers (in gray above my worksheet) are numbers instead of
letters. I have Excel 2003. How can this be changed? It is very confusing
when trying to write formulas.

DataMouse.biz

Excel column headers
 
Happy new year

This is one of your settings.

Go into
TOOLS OPTIONS
Then the GENERAL tab

There's an option for R1C1 refernce style

:-)

Danny

"Tara" wrote:

The column headers (in gray above my worksheet) are numbers instead of
letters. I have Excel 2003. How can this be changed? It is very confusing
when trying to write formulas.



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

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