Auto Fill Format or Copying Formulas

M

Marie

When using auto fill (or copy paste)to copy a formula in a spreadsheet it is
copying the value rather than the formula, this has happened on several
different spreadsheets lately and I can't figure out how to format the cell
to accept the formula rather than the value.

Help is greatly appreciated.
 
D

Dave Peterson

Make sure that excel is automatic calculation mode.

In xl2003 menus, it's tools|options|calculation tab.
 

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 2
Odd Formula copying Behavior 3
Excel Auto Fill Options 1
Excel 2003 - fill down error 1
Copying formulas from file to file 2
Filtered Mode Copying and pasting as value yield as error? 1
Want to turnoff the Auto Fill Option 2
Auto Fill Defaults 3

Top