Excel if then formulas auto copying

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Tools>Options, Edit tab, uncheck Extend data range formats and formulas

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Fill Format or Copying Formulas 1
Excel VBA 1
Excel keeps copying formulas into other cells!! 2
Date and If problem 6
Excel Auto Fill Options 1
Excel Count If Formula Question 1
Sheet Names and Auto-calculation 2
Auto numbering in Excel 1

Back
Top