ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why is my header row numbers instead of letters? (https://www.excelbanter.com/excel-discussion-misc-queries/186064-why-my-header-row-numbers-instead-letters.html)

raula

Why is my header row numbers instead of letters?
 
The standard header row used to be letters (A - B - C) and the left column
was and still is numbers (1 - 2 - 3). When I logged in today, my standard
header row is now numbers (1 - 2 - 3). If I need to create a formula it's
now 11 or 12 instead of A1 or A2. How can I change this back to letters?

Dave Peterson

Why is my header row numbers instead of letters?
 
In xl2003 menus:
Tools|Options|General Tab|Uncheck R1C1 reference style

raula wrote:

The standard header row used to be letters (A - B - C) and the left column
was and still is numbers (1 - 2 - 3). When I logged in today, my standard
header row is now numbers (1 - 2 - 3). If I need to create a formula it's
now 11 or 12 instead of A1 or A2. How can I change this back to letters?


--

Dave Peterson

Gary''s Student

Why is my header row numbers instead of letters?
 
Tools Options General clear the R1C1 checkbox
--
Gary''s Student - gsnu200783


All times are GMT +1. The time now is 07:02 PM.

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