By default, Microsoft Excel automatically formats new data that you type at the end of a range to match the preceding rows. Excel also automatically copies formulas that have been repeated in the preceding rows and extends them to additional rows.

Note  In order to be extended to new rows in the range, the formats and formulas must appear in at least three of the five preceding rows.

You can turn this option off (or back on again) at any time:

1. On the Tools menu, click Options.
2. On the Edit tab, clear the Extend data range formats and formulas check box to turn automatic formatting off.

   To turn automatic formatting back on again, select the Extend data range formats and formulas check box.