Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Formula
Resolved · Medium Priority · Version 2010
Reply Tue 6 Sep 2011, 16:47Delegate Lydia said...
Lydia has attended:
Excel Introduction course
Formula
I'd like to know if there is a way to copy a formula down vertically, but using the data running horizontally.
For upcoming training course dates see: Pricing & availability
RE: Formula
Hello Lydia,
When you copy a formula, the row reference automatically changes when you copy down a column whereas the column reference changes when you copy across a row.
The results of the calculations are usually positioned at the bottom of the column of data being calculated or at the end of the row.
To place your formulas elsewhere on the sheet could be very confusing but if you really have a need to do this, you will need to edit your formulas after copying them, to get them to process the correct information.
Kind regards,
Ruth
Reply Fri 9 Sep 2011, 16:17Delegate Lydia said...
RE: Formula
Hi Ruth,
So is the answer to my question essentially 'no' then?!
To clarify, what I'd want to happen would be to copy a formula down a column, but rather than it following as, for example =E1, =E2, =E3, =E4, it would follow =E1, =F1, =G1, =H1 etc
RE: Formula
Hello Lydia,
The answer IS no. What you want to happen is not what WILL happen when you copy a formula down a column.
Also, normally a formula would include a range not just a single cell bt it does depend on what you are trying to do.
Kind regards,
Ruth
Fri 16 Sep 2011: Automatically marked as resolved.
|