Fill formulas into adjacent cells does not take formula only data

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

Guest

When using the autofill function to copy a formula down a column, only the
data is being copied so when you click onn on of the filled cells the formula
is correct but the data is a copy of the first cell only.
 
Tools>Options>Calculation.

Make sure you are set the "Automatic".


Gord Dibben MS Excel MVP
 

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

Copying formulas from one cell to another 7
Autofill only copying initial value, not filling formula 2
autofill down won't work!!!! 3
Excel VBA 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Formulas That Reference ADJACENT Sheet 4
Paste special from cells without formulas/formats 2
fill down sequentially 1

Back
Top