ExcelBanter - Copy down doesn't change row reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copy down doesn't change row reference (https://www.excelbanter.com/excel-discussion-misc-queries/119120-copy-down-doesnt-change-row-reference.html)

jigger

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?

Gord Dibben

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?

All times are GMT +1. The time now is 06:36 AM.