Skip to Content
0
Former Member
Oct 31, 2010 at 10:50 PM

Reg:expand option

14 Views

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