Reg:expand option

[Former Member]

Hi Experts,

I have a problem with the expand functionality. the user will do a vlookup in the data region and send data.

the first cell of the the input data region contains vlookup formula and when the expand option is pressed the

vlookup formula gets distributed to all the cells.How to restrict the expand functionality in excel for formulas.

Regards,

Vinoth

[Former Member · Accepted solution]

Hi Vinoth,

Expansion will copy any formula defined in one cell to the other cells. So, if you want to stop this, the only option is to not having expansion.

Hope this helps.