Extend data range formats and formulas Automates formatting of new items added to the end of a data range to match the format ...

Extend data range formats and formulas
Automates formatting of new items added to the end of a data range to match the format of the rest of the data range. Formulas that are repeated in every row are also copied. To be extended, formats and formulas must appear in at least three of the five rows preceding the new row.
English
English (United States)
Deutsch (Deutschland)
German (Germany)
Español (España)
Spanish (Spain)
Français (France)
French (France)
italiano
Italian
日本語
Japanese