Excel if then formulas auto copying
 

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?

ToolsOptions, Edit tab, uncheck Extend data range formats and formulas

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"bf" wrote in message
...
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?

That fixed it! Thanks!

"Niek Otten" wrote:

ToolsOptions, Edit tab, uncheck Extend data range formats and formulas

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"bf" wrote in message
...
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?