ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Column headings (https://www.excelbanter.com/setting-up-configuration-excel/53145-column-headings.html)

freida

Column headings
 
I don't know how, but Column headings in my Excel changed from letters to
numbers. Now it's very difficult to write formulas. How can I get back Column
headings as letters?

Paul B

Column headings
 
freida, tools, options, general, un check R1C1 ref. 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

"freida" wrote in message
...
I don't know how, but Column headings in my Excel changed from letters to
numbers. Now it's very difficult to write formulas. How can I get back
Column
headings as letters?




freida

Column headings
 
I did like Paul B told and Column headings are back to letters now. Thank you!

"Paul B" wrote:

freida, tools, options, general, un check R1C1 ref. 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

"freida" wrote in message
...
I don't know how, but Column headings in my Excel changed from letters to
numbers. Now it's very difficult to write formulas. How can I get back
Column
headings as letters?






All times are GMT +1. The time now is 12:35 AM.

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