Doubt on extending series. Someone could help?!
 

I am currently using excel extension feature (the "+" sign that drags and
apply the same formula from a cell to the subsequent ones), where the
"source" cells are organized in columns; however, I would like the "result"
cells to be organized in a line... Since excel does not recognize this change
on axis, I was wondering if someone could help me...

Doubt on extending series. Someone could help?!
 

Take a look at the TRANSPOSE function, which is actually an array formula.
Remember to make your cell range an absolute reference, copy it, and the use
CTRL+SHIFT+ENTER to activate the array
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Murilo" wrote:

I am currently using excel extension feature (the "+" sign that drags and
apply the same formula from a cell to the subsequent ones), where the
"source" cells are organized in columns; however, I would like the "result"
cells to be organized in a line... Since excel does not recognize this change
on axis, I was wondering if someone could help me...

Doubt on extending series. Someone could help?!
 

Hey Kan, thanks for the prompt response! However, 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...

Thanks again
"M Kan" wrote:

Take a look at the TRANSPOSE function, which is actually an array formula.
Remember to make your cell range an absolute reference, copy it, and the use
CTRL+SHIFT+ENTER to activate the array
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Murilo" wrote:

I am currently using excel extension feature (the "+" sign that drags and
apply the same formula from a cell to the subsequent ones), where the
"source" cells are organized in columns; however, I would like the "result"
cells to be organized in a line... Since excel does not recognize this change
on axis, I was wondering if someone could help me...