How to move a formula a given number of cells [on hold]
up vote
-1
down vote
favorite
I have six rows with various formulae and I want to copypaste them a given number of times so that references are adapted to each row, by moving six rows each.
For example, in a row I have =60-D7. When I copypaste the six rows, six rows below, I want this formula to be =60-D13.
How can I do it?
microsoft-excel spreadsheet cells
asked Nov 15 at 10:15
zest16
21
put on hold as off-topic by fixer1234, Twisty Impersonator, Toto, bertieb, K7AAY Nov 19 at 16:38
- This question does not appear to be about computer software or computer hardware within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
up vote
-1
down vote
favorite
I have six rows with various formulae and I want to copypaste them a given number of times so that references are adapted to each row, by moving six rows each.
For example, in a row I have =60-D7. When I copypaste the six rows, six rows below, I want this formula to be =60-D13.
How can I do it?
microsoft-excel spreadsheet cells
asked Nov 15 at 10:15
zest16
21
put on hold as off-topic by fixer1234, Twisty Impersonator, Toto, bertieb, K7AAY Nov 19 at 16:38
- This question does not appear to be about computer software or computer hardware within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
"When I copypaste the six rows, six rows below" <-- what did actually you get (the formula) ? Do you mean you get=60-D7too after the copypaste operation?
– p._phidot_
Nov 15 at 10:25
What is happening when you try it now? Unless you use the $ symbol to fix the column and / or row, the row number will change automatically.
– Stephen
Nov 15 at 11:07
Yes you're right, that's not the problem I have. I'm closing this post. Sorry for the inconvenience.
– zest16
Nov 15 at 11:24
5
I'm voting to close this question as off-topic because the OP states that there isn't a problem to solve.
– fixer1234
Nov 15 at 13:04
Note to close voters: OP posted an answer stating that the problem had been solved. It was deleted as a non-answer, so not visible to <10K users. As indicated in OP's earlier comment, they consider the question closed.
– fixer1234
Nov 15 at 22:14
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I have six rows with various formulae and I want to copypaste them a given number of times so that references are adapted to each row, by moving six rows each.
For example, in a row I have =60-D7. When I copypaste the six rows, six rows below, I want this formula to be =60-D13.
How can I do it?
microsoft-excel spreadsheet cells
asked Nov 15 at 10:15
zest16
21
I have six rows with various formulae and I want to copypaste them a given number of times so that references are adapted to each row, by moving six rows each.
For example, in a row I have =60-D7. When I copypaste the six rows, six rows below, I want this formula to be =60-D13.
How can I do it?
microsoft-excel spreadsheet cells
microsoft-excel spreadsheet cells
asked Nov 15 at 10:15
zest16
21
asked Nov 15 at 10:15
zest16
21
asked Nov 15 at 10:15
zest16
21
asked Nov 15 at 10:15
zest16
21
asked Nov 15 at 10:15
zest16
21
21
put on hold as off-topic by fixer1234, Twisty Impersonator, Toto, bertieb, K7AAY Nov 19 at 16:38
- This question does not appear to be about computer software or computer hardware within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
put on hold as off-topic by fixer1234, Twisty Impersonator, Toto, bertieb, K7AAY Nov 19 at 16:38
- This question does not appear to be about computer software or computer hardware within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
"When I copypaste the six rows, six rows below" <-- what did actually you get (the formula) ? Do you mean you get=60-D7too after the copypaste operation?
– p._phidot_
Nov 15 at 10:25
What is happening when you try it now? Unless you use the $ symbol to fix the column and / or row, the row number will change automatically.
– Stephen
Nov 15 at 11:07
Yes you're right, that's not the problem I have. I'm closing this post. Sorry for the inconvenience.
– zest16
Nov 15 at 11:24
5
I'm voting to close this question as off-topic because the OP states that there isn't a problem to solve.
– fixer1234
Nov 15 at 13:04
Note to close voters: OP posted an answer stating that the problem had been solved. It was deleted as a non-answer, so not visible to <10K users. As indicated in OP's earlier comment, they consider the question closed.
– fixer1234
Nov 15 at 22:14
add a comment |
"When I copypaste the six rows, six rows below" <-- what did actually you get (the formula) ? Do you mean you get=60-D7too after the copypaste operation?
– p._phidot_
Nov 15 at 10:25
What is happening when you try it now? Unless you use the $ symbol to fix the column and / or row, the row number will change automatically.
– Stephen
Nov 15 at 11:07
Yes you're right, that's not the problem I have. I'm closing this post. Sorry for the inconvenience.
– zest16
Nov 15 at 11:24
5
I'm voting to close this question as off-topic because the OP states that there isn't a problem to solve.
– fixer1234
Nov 15 at 13:04
Note to close voters: OP posted an answer stating that the problem had been solved. It was deleted as a non-answer, so not visible to <10K users. As indicated in OP's earlier comment, they consider the question closed.
– fixer1234
Nov 15 at 22:14
"When I copypaste the six rows, six rows below" <-- what did actually you get (the formula) ? Do you mean you get
=60-D7 too after the copypaste operation?– p._phidot_
Nov 15 at 10:25
"When I copypaste the six rows, six rows below" <-- what did actually you get (the formula) ? Do you mean you get
=60-D7 too after the copypaste operation?– p._phidot_
Nov 15 at 10:25
What is happening when you try it now? Unless you use the $ symbol to fix the column and / or row, the row number will change automatically.
– Stephen
Nov 15 at 11:07
What is happening when you try it now? Unless you use the $ symbol to fix the column and / or row, the row number will change automatically.
– Stephen
Nov 15 at 11:07
Yes you're right, that's not the problem I have. I'm closing this post. Sorry for the inconvenience.
– zest16
Nov 15 at 11:24
Yes you're right, that's not the problem I have. I'm closing this post. Sorry for the inconvenience.
– zest16
Nov 15 at 11:24
5
5
I'm voting to close this question as off-topic because the OP states that there isn't a problem to solve.
– fixer1234
Nov 15 at 13:04
I'm voting to close this question as off-topic because the OP states that there isn't a problem to solve.
– fixer1234
Nov 15 at 13:04
Note to close voters: OP posted an answer stating that the problem had been solved. It was deleted as a non-answer, so not visible to <10K users. As indicated in OP's earlier comment, they consider the question closed.
– fixer1234
Nov 15 at 22:14
Note to close voters: OP posted an answer stating that the problem had been solved. It was deleted as a non-answer, so not visible to <10K users. As indicated in OP's earlier comment, they consider the question closed.
– fixer1234
Nov 15 at 22:14
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
"When I copypaste the six rows, six rows below" <-- what did actually you get (the formula) ? Do you mean you get
=60-D7too after the copypaste operation?– p._phidot_
Nov 15 at 10:25
What is happening when you try it now? Unless you use the $ symbol to fix the column and / or row, the row number will change automatically.
– Stephen
Nov 15 at 11:07
Yes you're right, that's not the problem I have. I'm closing this post. Sorry for the inconvenience.
– zest16
Nov 15 at 11:24
5
I'm voting to close this question as off-topic because the OP states that there isn't a problem to solve.
– fixer1234
Nov 15 at 13:04
Note to close voters: OP posted an answer stating that the problem had been solved. It was deleted as a non-answer, so not visible to <10K users. As indicated in OP's earlier comment, they consider the question closed.
– fixer1234
Nov 15 at 22:14