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.
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
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
