| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel & Copying Formulas
While working in Excel, how do you keep some of the formula constant while
copying and pasting? For example, when copying the formula =sum(B7+C8)-A40 from one cell to another, how do you keep the A40 constant so that no matter what cell it is in it will always subtract A40? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| Copying options: contents, results, formulas, etc. | New Users to Excel | |||
| Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) | |||
Threaded Mode
