ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Column headings changed from ABC to 123 format (https://www.excelbanter.com/setting-up-configuration-excel/136188-column-headings-changed-abc-123-format.html)

ytran

Column headings changed from ABC to 123 format
 
Somehow the column headings in Excel 2003 changed from ABC to 123 (so cell
references would be 11 instead of A1) How do I change them back?

Sandy

Column headings changed from ABC to 123 format
 
ToolsOptionsGeneral tab Uncheck R1C1 reference style

Sandy

"ytran" wrote in message
...
Somehow the column headings in Excel 2003 changed from ABC to 123 (so cell
references would be 11 instead of A1) How do I change them back?




ytran

Column headings changed from ABC to 123 format
 
Thanks! I did finally find what to check after I posted the question, but it
is one that is not easy to find in the office help.

"Sandy" wrote:

ToolsOptionsGeneral tab Uncheck R1C1 reference style

Sandy

"ytran" wrote in message
...
Somehow the column headings in Excel 2003 changed from ABC to 123 (so cell
references would be 11 instead of A1) How do I change them back?






All times are GMT +1. The time now is 06:41 PM.

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