auto compute

J

Joseph

My excel's formula is not currently funtioning automatically.
An example is when I'm copying a formula to be pasted in multiple cells
either any direction, it only gives me the amount that I copied although the
formula bar shows the formula copied refers to different cells and values. I
also found out that it will only calculate everytime I press F2 and enter.
What if I need tens thousands of cells, I cannot afford to do it on every
cell. Please help. tnx
 
T

T. Valko

Make sure calculation is set to automatic...

In versions prior to Excel 2007...

Tools>Options>Calculation tab>Automatic>OK
 

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

Top