ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   what made my columns change from a b c to 1 2 3 ? Rows are 1 2 3 a (https://www.excelbanter.com/excel-discussion-misc-queries/71556-what-made-my-columns-change-b-c-1-2-3-rows-1-2-3-a.html)

j kelly

what made my columns change from a b c to 1 2 3 ? Rows are 1 2 3 a
 


L. Howard Kittle

what made my columns change from a b c to 1 2 3 ? Rows are 1 2 3 a
 
Tools Options General R1C1 uncheck

HTH
Regards,
Howard

"j kelly" <j wrote in message
...




via135

what made my columns change from a b c to 1 2 3 ? Rows are 1 2 3 a
 

hi!

in the menu bar select

Tools Options select "General" tab in settings, select "R1C1
Reference Style" clikc "ok"

-via135

j kelly Wrote:



--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=512330



All times are GMT +1. The time now is 10:35 PM.

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