I am afraid I did not make
my question correctly, so let me rephrase it: When creating a new cell
series, i.e., montlhy net profits from a company, where monthly gross profits
are organized in a line and monthly taxes are organized in a column: After
creating the formula, and let's suppose I want net profits arranged over a
line: when "dragging" it to extend the results, Excel tend to extend the
formula following the same "axis", that is, it goes horizontal, instead of
vertical... I am now having to transpose the taxes column into a line to make
it work, but was wondering if there would be a way to solve it without having
to create this line that repeats the info shown in the column...