ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   the row indicator at the top of worksheet from numerals to lette. (https://www.excelbanter.com/excel-discussion-misc-queries/2144-row-indicator-top-worksheet-numerals-lette.html)

purple flower

the row indicator at the top of worksheet from numerals to lette.
 
The row indicators for cell references are numeral instead of letters. How
do I change the row indicator to letters?

Frank Kabel

Tools - Options - General and uncheck 'R1C1 Reference Style'

--
Regards
Frank Kabel
Frankfurt, Germany

purple flower wrote:
The row indicators for cell references are numeral instead of
letters. How do I change the row indicator to letters?




Paulw2k

Tools-Options-General, then uncheck "R1C1 reference style".


"purple flower" <purple wrote in message
...
The row indicators for cell references are numeral instead of letters.
How
do I change the row indicator to letters?




Gord Dibben

Actually those are "Column" indicators.

The "Row" indicators are down the left side and are always numbers.

See other posts for fix of column indicators.

Gord Dibben Excel MVP

On Fri, 17 Dec 2004 12:21:02 -0800, "purple flower" <purple
wrote:

The row indicators for cell references are numeral instead of letters. How
do I change the row indicator to letters?




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

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