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







share|improve this 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-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










  • 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

















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







share|improve this 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-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










  • 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















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







share|improve this question













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






share|improve this question













share|improve this question











share|improve this question




share|improve this question










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-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










  • 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










  • 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

















active

oldest

votes






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes

-

Popular posts from this blog

Сан-Квентин

Image
Сан-Квентин Местоположение Сан-Квентин, Калифорния Координаты 37°56′13″ с. ш. 122°29′20″ з. д. H G Я O L Текущий статус Действует Режим безопасности минимальный и максимальный Количество мест 3 302 Открытие Июнь 1852 Находится в ведомстве California Department of Corrections and Rehabilitation Начальник Mike Martel, начальник  Сан-Квентин на Викискладе Сан-Квентин (англ.  San Quentin ) — тюрьма, располагающаяся на 432 акрах (около 1,7 км²), на мысе Сан-Квентин, в округе Марин, штат Калифорния, США. Тюрьма штата Калифорния Сан-Квентин была открыта в июле 1852 года и является старейшей в штате. Она была построена заключёнными, которые проживали в течение строительства на тюремном судне Вабан. В Сан-Квентине отбывали наказание и мужчины, и женщины до 1934 года, когда построили женскую тюрьму в Техачапи и туда перевели всех заключённых женщин. В Сан-Квентине приводятся в исполнение смертные казни, для этого имеется газовая камера, но...
Read more

8-я гвардейская общевойсковая армия

Image
8-я гвардейская общевойсковая ордена Ленина армия Награды: Войска: РККА → Советская армия → СВ России Род войск: Формирование: 1943 Расформирование (преобразование): 1992 Предшественник: 62-я армия (1942—43) → 8-я гвардейская общевойсковая армия (1943—92) → 8-й гвардейский армейский корпус (1992—98) Боевой путь Изюм-Барвенковская операция Донбасская операция Запорожская операция Битва за Днепр Днепропетровская операция Березнеговато-Снигирёвская операция Одесская операция Люблин-Брестская операция Варшавско-Познанская операция Восточно-Померанская операция Берлинская наступательная операция У этого термина существуют и другие значения, см. 8-я армия. Фотография Гвардейского Красного Знамени (лицевая сторона) 8-й гвардейской армии , образца 1943 года. Фотография Гвардейского Красного Знамени (оборотная сторона) 8-й гвардейской армии , образца 1943 года. 8-я гвардейская общевойсковая ордена Ленина армия  — гвардейское фор...
Read more

Алькесар

Image
Муниципалитет Алькесар Alquézar Герб 42°10′16″ с. ш. 0°01′27″ в. д. H G Я O L Страна Испания   Испания Автономное сообщество Арагон Провинция Уэска Комарка Сомонтано-де-Барбастро Алькальд Хосе Марияно Альтемир Ласкорс (ИСРП) История и география Площадь 32,36 км² Высота НУМ 660 м Часовой пояс UTC+1, летом UTC+2 Население Население 313 человек ( 2010 ) Плотность 9,92 чел./км² Этнохороним alquezarano/-a Цифровые идентификаторы Телефонный код +34 974 Почтовые индексы 22112 Автомобильный код HU alquezar.org   (исп.) Показать/скрыть карты Алькесар Алькесар Алькесар  Аудио, фото и видео на Викискладе Алькесар (исп.  Alquézar ) — муниципалитет в Испании, входит в провинцию Уэска, в составе автономного сообщества Арагон. Муниципалитет находится в составе района (комарки) Сомонтано-де-Барбастро. Занимает площадь 32,36 км². Население — 321 челове...
Read more