Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel will not allow me to create a name of "C" for a cell!
I have created cell names of "A" and "B" successfully. However, when I try
to name the very next cell "C", Excel automatically changes it to "C_". In other words, it adds an underscore symbol. Why is it doing this? Thank you! |
#2
|
|||
|
|||
does "C" have a special value or meaning in Exce.?
|
#3
|
|||
|
|||
Just a guess.
C looks too much like a reference in R1C1 reference style. If I type C in the namebox (to the left of the formula bar), the column with the activecell is selected. andrea wrote: I have created cell names of "A" and "B" successfully. However, when I try to name the very next cell "C", Excel automatically changes it to "C_". In other words, it adds an underscore symbol. Why is it doing this? Thank you! -- Dave Peterson |
#4
|
|||
|
|||
that sounds like a good guess! Out of curiosity, what is R1C1 Reference style?
"Dave Peterson" wrote: Just a guess. C looks too much like a reference in R1C1 reference style. If I type C in the namebox (to the left of the formula bar), the column with the activecell is selected. andrea wrote: I have created cell names of "A" and "B" successfully. However, when I try to name the very next cell "C", Excel automatically changes it to "C_". In other words, it adds an underscore symbol. Why is it doing this? Thank you! -- Dave Peterson |
#5
|
|||
|
|||
Some people like to refer to columns by numbers (1:256) instead of (a:iv).
I say those people are nuts! But if you write a couple of formulas in some cells, then tools|options|general tab|check R1C1 reference style and look at those formulas (and the column headers). This formula (in G11) will look like: =A1+$B$3+SUM(E:E) =R[-10]C[-6]+R3C2+SUM(C[-2]) =Row[10 above]Column[6 to left] + Row3Column2 (absolute reference) + sum(column[2 to the left]) It does have one really nice advantage. If you turn this on, you can look at all the formulas in a column and see if there are any inconsistencies pretty quickly (since they'll all look the same). Don't forget how to toggle this setting. andrea wrote: that sounds like a good guess! Out of curiosity, what is R1C1 Reference style? "Dave Peterson" wrote: Just a guess. C looks too much like a reference in R1C1 reference style. If I type C in the namebox (to the left of the formula bar), the column with the activecell is selected. andrea wrote: I have created cell names of "A" and "B" successfully. However, when I try to name the very next cell "C", Excel automatically changes it to "C_". In other words, it adds an underscore symbol. Why is it doing this? Thank you! -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
Thank you, Dave! That was a very clear and helpful explanation!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel, I seem to be "locked" on a cell and unable to click off. | Excel Discussion (Misc queries) | |||
How to I create a pdf file from Word or Excel files | Excel Discussion (Misc queries) | |||
create hyperlink in one cell with URL in a different cell | Excel Worksheet Functions | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions |