I am looking for a symbol to repeat the same Column letter into a running series of formulas.
A1*2 =
A2*2=
A3*2=
A4*2=
I am looking for a symbol to repeat the same Column letter into a running series of formulas.
A1*2 =
A2*2=
A3*2=
A4*2=
Your question is unclear. First, what you wrote in the question does not look like formulas in calc, where formulas begin with =
, and there’s no assignments to cells (=
is used for comparison). Second, when written like =A1=2
, (drag-)copying the cell downwards retains the column, and modifies the row part of reference (since A1
is a relative notation). So, clarification of the question needed to understand what you do and what you need.
And don’t post as wiki please.
You should read everything of [Tutorial] Ten concepts that every Calc user should know (View topic) • Apache OpenOffice Community Forum.
Concerning this topic chapter 8 of the mentioned post is most relevant.