ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Column and Row header (https://www.excelbanter.com/setting-up-configuration-excel/55541-column-row-header.html)

RAL

Column and Row header
 
When I open Excel to start a new work book, the column and row headers are
both numeric. How do I change the Column header to alphbetic?
--
Good Group

Paul B

Column and Row header
 
RAL, tools, options, general, uncheck R1C1 reference style
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"RAL" wrote in message
...
When I open Excel to start a new work book, the column and row headers are
both numeric. How do I change the Column header to alphbetic?
--
Good Group




RAL

Column and Row header
 
Thanks Paul B - it was driving me nuts.
--
Good Group


"Paul B" wrote:

RAL, tools, options, general, uncheck R1C1 reference style
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"RAL" wrote in message
...
When I open Excel to start a new work book, the column and row headers are
both numeric. How do I change the Column header to alphbetic?
--
Good Group





Paul B

Column and Row header
 
RAL, your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"RAL" wrote in message
...
Thanks Paul B - it was driving me nuts.
--
Good Group


"Paul B" wrote:

RAL, tools, options, general, uncheck R1C1 reference style
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"RAL" wrote in message
...
When I open Excel to start a new work book, the column and row headers
are
both numeric. How do I change the Column header to alphbetic?
--
Good Group








All times are GMT +1. The time now is 01:34 AM.

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