Hi All,
I was trying to create a demo for my friend to help him understand creating dependent lists. While doing so I noticed a strange scenario which is I am mentioning below....please help me understand why this happens.
I entered sub-category names in column-A (Gold,Silver,Diamond,Fire,Water,Air,Red,White,Blue) from A2:A10.
Similarly, Category names in Column-B (A,A,A,B,B,B,C,C,C) in B2:B10
In the Name Manager Dialog box, when I specify Range (A2:A4) and name it "A", it accept this name......when I specify Range (A5:A7) and name it "B", it accepts this name it but when I specify Range(A8:A10) and try to name it like "C", excel doesn't allow me to use this name.
I tried to type "C" in the NameBox and it selects the entire column of the ActiveCell. Similarly if I type "R" in the NameBox it selects the entire Row of the activecell.
So it seems that excel by default use "C" for the entire Column and "R" for the entire Row for the active cell. But I am unable to understand its usage.
Can anyone help me with this?
I was trying to create a demo for my friend to help him understand creating dependent lists. While doing so I noticed a strange scenario which is I am mentioning below....please help me understand why this happens.
I entered sub-category names in column-A (Gold,Silver,Diamond,Fire,Water,Air,Red,White,Blue) from A2:A10.
Similarly, Category names in Column-B (A,A,A,B,B,B,C,C,C) in B2:B10
In the Name Manager Dialog box, when I specify Range (A2:A4) and name it "A", it accept this name......when I specify Range (A5:A7) and name it "B", it accepts this name it but when I specify Range(A8:A10) and try to name it like "C", excel doesn't allow me to use this name.
I tried to type "C" in the NameBox and it selects the entire column of the ActiveCell. Similarly if I type "R" in the NameBox it selects the entire Row of the activecell.
So it seems that excel by default use "C" for the entire Column and "R" for the entire Row for the active cell. But I am unable to understand its usage.
Can anyone help me with this?