R[13]C[-3]*RC[-3] instead of C1*C3 etc. in my cells ? what did i d
All of a sudden i'm seeing the above cell references vs. names or regular
cellnames like A3 , D1, etc. What did I do and how can I get my worksheet back to the regular names |
<Tools <Options <General tab,
And *UNCHECK* - "R1C1 reference style". -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "JanieAC" wrote in message ... All of a sudden i'm seeing the above cell references vs. names or regular cellnames like A3 , D1, etc. What did I do and how can I get my worksheet back to the regular names |
Hi
Tools.Options.General tab - uncheck "R1C1 reference style" Arvi Laanemets "JanieAC" wrote in message ... All of a sudden i'm seeing the above cell references vs. names or regular cellnames like A3 , D1, etc. What did I do and how can I get my worksheet back to the regular names |
Tools / Options / general / uncheck R1C1 reference style
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "JanieAC" wrote in message ... All of a sudden i'm seeing the above cell references vs. names or regular cellnames like A3 , D1, etc. What did I do and how can I get my worksheet back to the regular names |
All times are GMT +1. The time now is 06:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com