98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Formula
Formula
Resolved · Medium Priority · Version 2010
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
Fri 16 Sep 2011: Automatically marked as resolved.
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. |
Excel tip:Adding up time greater than 24 hoursWhen you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours. |