Excel if then formulas auto copying

B

bf

I am using IF/Then formulas in a worksheet; however, they seem to auto
filling in some of the cells below as I enter data. I have cleared all the
cells that do not contain the formula but it continues to happen. How can I
correct this?
 
N

Niek Otten

Tools>Options, Edit tab, uncheck Extend data range formats and formulas

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
B

bf

That fixed it! Thanks!

Niek Otten said:
Tools>Options, Edit tab, uncheck Extend data range formats and formulas

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
Click to expand...
 
Top