| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy down doesn't change row reference
I'm using XL2003. When I copy down a function (calculating the difference in
two cells in a blank cell between two pivot tables), the row remains the same but I want it to change to the next row number. Even pressing "Ctrl" doesn't help. Any solutions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy down doesn't change row reference
Could be you are set to manual at ToolsOptionsCalculation.
Change to automatic. Gord Dibben MS Excel MVP On Thu, 16 Nov 2006 14:13:01 -0800, jigger wrote: I'm using XL2003. When I copy down a function (calculating the difference in two cells in a blank cell between two pivot tables), the row remains the same but I want it to change to the next row number. Even pressing "Ctrl" doesn't help. Any solutions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy a formula that does not change the column or row number? | Excel Discussion (Misc queries) | |||
| Change location of auto saved back up copy of shared workbook? | Excel Discussion (Misc queries) | |||
| Trying to set up a cross reference chart, best way to copy formulas? | Excel Discussion (Misc queries) | |||
| Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
| How do I change the number on copy sheet so I don't have to renam | Excel Worksheet Functions | |||
Hybrid Mode
