AutoFill

[iggydarsa]

Hi Everyone,

On my home computer the following scenario works, but it doesnt at my work computer... I think it has to do with some type of settings issue.

lets say I have a formula on cell B1 that says =A1 and i dragged down for 10 rows so the formula is populated on all 10 rows on column B. When I insert a new row on Row 5 it doesnt automatically fills B5 with the formula of =A5 (but it does on the other computer)

does anyone know what kind of settings i should play with?

Thanks is advance!!

 

[wigi]

Hi

have a look at Tools > Options > Edit > Extend data range formats and formulas.

Wigi

 

[iggydarsa]

Yes, it works now!

Thank you very much