ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   R[13]C[-3]*RC[-3] instead of C1*C3 etc. in my cells ? what did i d (https://www.excelbanter.com/excel-discussion-misc-queries/11403-r%5B13%5Dc%5B-3%5D%2Arc%5B-3%5D-instead-c1%2Ac3-etc-my-cells-what-did-i-d.html)

JanieAC

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

RagDyer

<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


Arvi Laanemets

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




Ken Wright

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