Auto Fill Format or Copying Formulas

  • Thread starter Thread starter Marie
  • Start date Start date
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.
 
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 a formula 1
Excel Help to copy information from one row at a time to another sheet 1
Working on multiple spreadsheets at the same time 4
Odd Formula copying Behavior 3
Excel Auto Fill Options 1
Excel VBA 1
Copying Formulas 2
Paste Special Values 2

Back
Top