98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copying down formulas
Copying down formulas
Resolved · Medium Priority · Version 2007
Tue 16 Feb 2010, 16:20Delegate Bianca said...
Bianca has attended:
PowerPoint Intermediate Advanced course
Excel Advanced course
Excel Intermediate course
Copying down formulas
If there is a blank row between data- is it possible to copy down the formula past this row so that the below rows receive the same formula?
Wed 17 Feb 2010, 10:58Trainer Stephen said...
RE: Copying down formulas
Hi Bianca
Thanks for the question
If you are using the autofill method (Double clicking on the cell containing the value), then it will stop at the first blank row.
If you have blank rows, the you have to manually drag the formula down.
One query, is it necessary for your data to contain blank rows? If not then removing them would solve the problem and improve the apperance of your data.
Regards
Stephen
Tue 23 Feb 2010: 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:Using an equal (=) sign that isn't part of a formulaBefore you type the equal sign, type an apostrophe: ' |
