| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill Format or Copying Formulas
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Fill Format or Copying Formulas
Make sure that excel is automatic calculation mode.
In xl2003 menus, it's tools|options|calculation tab. Marie wrote: 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. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying formulas with fill handle | New Users to Excel | |||
| Copying formulas by dragging fill box | Excel Discussion (Misc queries) | |||
| auto fill of formulas | Excel Discussion (Misc queries) | |||
| How do I auto fill formulas | Excel Worksheet Functions | |||
| Any way toturn off the "Auto Fill Options" pop-up after copying ce | Excel Discussion (Misc queries) | |||
Hybrid Mode
