Formula Fill properties

  • Thread starter Thread starter vfalzone
  • Start date Start date
V

vfalzone

I have a typical table of numbers, rows and columns. Then i total o
column and then use fill right to copy the function to th eothe
columns, the cell contents shows the formula changing cell references
but the total numer itself remains that of the first cell. I have don
this with correct results hundreds of times before. IS there a fil
property that I may have inadvertantly changed?

Vfalzone :confused
 
Hi

check tools / options /calculation and set to automatic

cheers
julied
 
Hi
mae sure automatic re-calculation is enabled ('Tools - Options - calculation'
 
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

Excel VBA 1
Fill Series only changing one input 2
Excel Subtracting multiple columns from another column 3
Macro Fill Formula 1
Filling formulas with specific cell references remaining the same 1
Nameing a function 1
date formula 1
Fill handle formula 9

Back
Top