Search for adaptive elements (16)-auto-downward filling Formula

Search for adaptive elements (16)-auto-downward filling Formula

Key design points: excle, interface, automatic adjustment

Xiuxiu: There is also a particularly powerful function.

Ajin: What?

Xiuxiu: Automatically fill down the formula.

Ajin: Well, to be honest, this function is very useful.

Xiuxiu: You also know?

Ajin: Of course! This function is also available for pivot tables! Just use "Import external data.

Xiuxiu: However, there are not so many additional conditions as long as you set "Extended Data region format and formula" in "Tools"-"options"-"editing.

Ajin: Ah, did you win again ?!

Search for adaptive elements (16)-auto-downward filling Formula