ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Column reference got changed (https://www.excelbanter.com/new-users-excel/34390-column-reference-got-changed.html)

willy

Column reference got changed
 
Column references in my excel sheets which which usually show as A B C D
....... are now showing 1 2 3 4 5
Please help

VoG

willy wrote:
Column references in my excel sheets which which usually show as A B C D
...... are now showing 1 2 3 4 5
Please help


Tools | Options, General tab. Untick R1C1 reference style.


--
Message posted via http://www.officekb.com

Bill Ridgeway

Goto <Tools<Options<Settings and untick <R1C1 reference style.

Regards.

Bill Ridgeway
Computer Solutions

"willy" wrote in message
...
Column references in my excel sheets which which usually show as A B C D
...... are now showing 1 2 3 4 5
Please help





All times are GMT +1. The time now is 02:56 AM.

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