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.

  1. Click the Microsoft Office Button Office button image, and then click Excel Options.

  2. 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.

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language