Enable or disable automatic extending of formats and formulas to additional rows
By default, Microsoft Office Excel automatically formats new data that you type at the end of a range to match the preceding rows, if those formats appear in at least three of the five last rows preceding the new row. Excel also automatically copies formulas that have been repeated in at least three of five last rows preceding the new row, and extends them to the new row.
You can turn this option on or off as needed.
Click the Microsoft Office Button , and then click Excel Options.
In the Advanced category, under Editing options, select or clear the Extend data range formats and formulas check box to turn this option on or off.