Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Doubt | Excel Discussion (Misc queries) | |||
I have a doubt! | Excel Discussion (Misc queries) | |||
Extending a date series | Links and Linking in Excel | |||
some doubt | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |