Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copying down formulas
|
|
|
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. |
Copying down formulas
Resolved · Medium Priority · Version 2007
Reply 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?
For upcoming training course dates see: Pricing & availability
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.
|