Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
<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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |