Spreadsheet: 69547d1270073649-moving-multiple-cells-in-a-formula-example
Sheet: Sheet1

75 |  |  |  |  | 75
Force | Disp | u1 | f1 |  | Force | Disp | u1 | f1
0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
9.09069 | 2.79671e-07 | 7.736842105e-05 |  |  | 9.09069 | 2.79671e-07 | 7.736842105e-05 |  |  | See cell d5 and the highlighted refernces.
9.09069 | 2.79671e-07 | 0.0001547368421 |  |  | 9.09069 | 2.79671e-07 | 0.0001547368421 |  |  | Then see cell i5 and see how the referenced cells have all moved up one row.
488.691 | 1.54485e-05 | 0.00023210526315 |  |  | 488.691 | 1.54485e-05 | 0.00023210526315 |  |  | Is there a way to move all 9 references at once? At the moment I am just clicking and dragging the references one at a time.
762.306 | 3.05306e-05 | 0.0003094736842 |  |  | 762.306 | 3.05306e-05 | 0.0003094736842
838.039 | 3.62318e-05 | 0.00038684210525 |  |  | 838.039 | 3.62318e-05 | 0.00038684210525
939.413 | 4.47401e-05 | 0.0004642105263 |  |  | 939.413 | 4.47401e-05 | 0.0004642105263
1066.78 | 5.75584e-05 | 0.00054157894735 |  |  | 1066.78 | 5.75584e-05 | 0.00054157894735
1108.33 | 6.23462e-05 | 0.0006189473684 |  |  | 1108.33 | 6.23462e-05 | 0.0006189473684
1164.21 | 6.95047e-05 | 0.0006963157894499999 |  |  | 1164.21 | 6.95047e-05 | 0.0006963157894499999
1228.49 | 7.99667e-05 | 0.0007736842104999999 |  |  | 1228.49 | 7.99667e-05 | 0.0007736842104999999
1249.61 | 8.39255e-05 | 0.0008510526315499998 |  |  | 1249.61 | 8.39255e-05 | 0.0008510526315499998
1278.14 | 8.98827e-05 | 0.0009284210525999998 |  |  | 1278.14 | 8.98827e-05 | 0.0009284210525999998
1316.74 | 9.88265e-05 | 0.00100578947365 |  |  | 1316.74 | 9.88265e-05 | 0.00100578947365
1350.77 | 0.000107722 | 0.0010831578947 |  |  | 1350.77 | 0.000107722 | 0.0010831578947
1390.85 | 0.000116585 | 0.00116052631575 |  |  | 1390.85 | 0.000116585 | 0.00116052631575
1405.01 | 0.000119944 | 0.0012378947368 |  |  | 1405.01 | 0.000119944 | 0.0012378947368
1424.41 | 0.000124979 | 0.00131526315785 |  |  | 1424.41 | 0.000124979 | 0.00131526315785
1450.23 | 0.0001325 | 0.0013926315789 |  |  | 1450.23 | 0.0001325 | 0.0013926315789
1483.31 | 0.000143712 | 0.00146999999995 |  |  | 1483.31 | 0.000143712 | 0.00146999999995
1517.65 | 0.000160312 |  |  |  | 1517.65 | 0.000160312
1539.48 | 0.000184454 |  |  |  | 1539.48 | 0.000184454
1562.18 | 0.000220548 |  |  |  | 1562.18 | 0.000220548
1571.48 | 0.000234115 |  |  |  | 1571.48 | 0.000234115
1591.38 | 0.000254506 |  |  |  | 1591.38 | 0.000254506
1636.96 | 0.00028529 |  |  |  | 1636.96 | 0.00028529
1754.81 | 0.000332459 |  |  |  | 1754.81 | 0.000332459
1807.35 | 0.00035045 |  |  |  | 1807.35 | 0.00035045
1883.51 | 0.000377864 |  |  |  | 1883.51 | 0.000377864
2006.31 | 0.000420037 |  |  |  | 2006.31 | 0.000420037
2054.8 | 0.0004361 |  |  |  | 2054.8 | 0.0004361
2124.77 | 0.000460458 |  |  |  | 2124.77 | 0.000460458
2152.86 | 0.000469647 |  |  |  | 2152.86 | 0.000469647
2193.1 | 0.000483464 |  |  |  | 2193.1 | 0.000483464
2251.86 | 0.000504253 |  |  |  | 2251.86 | 0.000504253
2275.29 | 0.00051205 |  |  |  | 2275.29 | 0.00051205
2307.69 | 0.00052376 |  |  |  | 2307.69 | 0.00052376
2353.81 | 0.000541351 |  |  |  | 2353.81 | 0.000541351
2371.66 | 0.000547933 |  |  |  | 2371.66 | 0.000547933
2397.33 | 0.000557821 |  |  |  | 2397.33 | 0.000557821
2434.65 | 0.00057263 |  |  |  | 2434.65 | 0.00057263
2489.76 | 0.000594824 |  |  |  | 2489.76 | 0.000594824
2510.14 | 0.000603119 |  |  |  | 2510.14 | 0.000603119
2517.36 | 0.000606228 |  |  |  | 2517.36 | 0.000606228
2530.1 | 0.000610892 |  |  |  | 2530.1 | 0.000610892
2547.85 | 0.000617872 |  |  |  | 2547.85 | 0.000617872
2554.03 | 0.000620488 |  |  |  | 2554.03 | 0.000620488
2562.74 | 0.000624409 |  |  |  | 2562.74 | 0.000624409
2578.73 | 0.000630303 |  |  |  | 2578.73 | 0.000630303
2600.61 | 0.000639117 |  |  |  | 2600.61 | 0.000639117
2632.28 | 0.000652363 |  |  |  | 2632.28 | 0.000652363
2646.28 | 0.000657307 |  |  |  | 2646.28 | 0.000657307
2662.63 | 0.000664714 |  |  |  | 2662.63 | 0.000664714
2693.28 | 0.000675827 |  |  |  | 2693.28 | 0.000675827
2733.04 | 0.000692507 |  |  |  | 2733.04 | 0.000692507
2797.69 | 0.000717441 |  |  |  | 2797.69 | 0.000717441
2821.69 | 0.000726747 |  |  |  | 2821.69 | 0.000726747
2860 | 0.000740706 |  |  |  | 2860 | 0.000740706
2909.31 | 0.000761586 |  |  |  | 2909.31 | 0.000761586
2927.52 | 0.000769389 |  |  |  | 2927.52 | 0.000769389
2955.16 | 0.000781094 |  |  |  | 2955.16 | 0.000781094
2991.75 | 0.000798667 |  |  |  | 2991.75 | 0.000798667
3008.25 | 0.000805239 |  |  |  | 3008.25 | 0.000805239
3032.07 | 0.000815104 |  |  |  | 3032.07 | 0.000815104
3061.2 | 0.000829909 |  |  |  | 3061.2 | 0.000829909
3104.19 | 0.000852127 |  |  |  | 3104.19 | 0.000852127
3128.05 | 0.000860438 |  |  |  | 3128.05 | 0.000860438
3156.66 | 0.000872914 |  |  |  | 3156.66 | 0.000872914
3197.35 | 0.000891635 |  |  |  | 3197.35 | 0.000891635
3212.51 | 0.000898654 |  |  |  | 3212.51 | 0.000898654
3230.79 | 0.000909185 |  |  |  | 3230.79 | 0.000909185
3274.66 | 0.000924948 |  |  |  | 3274.66 | 0.000924948
3334.5 | 0.000948587 |  |  |  | 3334.5 | 0.000948587
3388.57 | 0.000977071 |  |  |  | 3388.57 | 0.000977071
3388.57 | 0.000977071 |  |  |  | 3388.57 | 0.000977071
3388.61 | 0.000977077 |  |  |  | 3388.61 | 0.000977077
3388.62 | 0.000977071 |  |  |  | 3388.62 | 0.000977071
3388.62 | 0.000977074 |  |  |  | 3388.62 | 0.000977074
3388.63 | 0.000977073 |  |  |  | 3388.63 | 0.000977073
3388.63 | 0.000977076 |  |  |  | 3388.63 | 0.000977076
3388.63 | 0.00097708 |  |  |  | 3388.63 | 0.00097708
3388.63 | 0.000977091 |  |  |  | 3388.63 | 0.000977091
3388.65 | 0.000977084 |  |  |  | 3388.65 | 0.000977084
3388.65 | 0.000977097 |  |  |  | 3388.65 | 0.000977097
3388.66 | 0.000977071 |  |  |  | 3388.66 | 0.000977071
3388.67 | 0.000977087 |  |  |  | 3388.67 | 0.000977087
3388.68 | 0.000977105 |  |  |  | 3388.68 | 0.000977105
3388.69 | 0.000977118 |  |  |  | 3388.69 | 0.000977118
3388.73 | 0.000977072 |  |  |  | 3388.73 | 0.000977072
3388.75 | 0.000977137 |  |  |  | 3388.75 | 0.000977137
3388.78 | 0.000977166 |  |  |  | 3388.78 | 0.000977166
3388.9 | 0.000977209 |  |  |  | 3388.9 | 0.000977209
3389.02 | 0.000977273 |  |  |  | 3389.02 | 0.000977273
3389.23 | 0.00097737 |  |  |  | 3389.23 | 0.00097737
3389.55 | 0.000977515 |  |  |  | 3389.55 | 0.000977515
3390.03 | 0.000977733 |  |  |  | 3390.03 | 0.000977733
3390.73 | 0.00097806 |  |  |  | 3390.73 | 0.00097806
3391.99 | 0.000978551 |  |  |  | 3391.99 | 0.000978551
3393.86 | 0.000979289 |  |  |  | 3393.86 | 0.000979289
3396.47 | 0.000980397 |  |  |  | 3396.47 | 0.000980397
3402.97 | 0.000982049 |  |  |  | 3402.97 | 0.000982049
3412.11 | 0.000984529 |  |  |  | 3412.11 | 0.000984529
3425.03 | 0.000988251 |  |  |  | 3425.03 | 0.000988251
3443.79 | 0.000993838 |  |  |  | 3443.79 | 0.000993838
3473.54 | 0.00100222 |  |  |  | 3473.54 | 0.00100222
3507.23 | 0.00101481 |  |  |  | 3507.23 | 0.00101481
3521.66 | 0.00101954 |  |  |  | 3521.66 | 0.00101954
3541.66 | 0.00102662 |  |  |  | 3541.66 | 0.00102662
3567.95 | 0.00103726 |  |  |  | 3567.95 | 0.00103726
3617.34 | 0.00105319 |  |  |  | 3617.34 | 0.00105319
3632.2 | 0.00105917 |  |  |  | 3632.2 | 0.00105917
3661.03 | 0.00106813 |  |  |  | 3661.03 | 0.00106813
3695.2 | 0.00108159 |  |  |  | 3695.2 | 0.00108159
3713.21 | 0.00108662 |  |  |  | 3713.21 | 0.00108662
3742.1 | 0.00109417 |  |  |  | 3742.1 | 0.00109417
3782.36 | 0.00110548 |  |  |  | 3782.36 | 0.00110548
3848.33 | 0.00112244 |  |  |  | 3848.33 | 0.00112244
3920.85 | 0.00114794 |  |  |  | 3920.85 | 0.00114794
4006.17 | 0.00118627 |  |  |  | 4006.17 | 0.00118627
4033.85 | 0.00120064 |  |  |  | 4033.85 | 0.00120064
4079.81 | 0.00122218 |  |  |  | 4079.81 | 0.00122218
4106.94 | 0.00123023 |  |  |  | 4106.94 | 0.00123023
4144.79 | 0.00124231 |  |  |  | 4144.79 | 0.00124231
4196.38 | 0.00126049 |  |  |  | 4196.38 | 0.00126049
4218.89 | 0.00126731 |  |  |  | 4218.89 | 0.00126731
4247.73 | 0.00127755 |  |  |  | 4247.73 | 0.00127755
4281.33 | 0.00129292 |  |  |  | 4281.33 | 0.00129292
4335.69 | 0.00131596 |  |  |  | 4335.69 | 0.00131596
4424.14 | 0.00135049 |  |  |  | 4424.14 | 0.00135049
4445.59 | 0.00136346 |  |  |  | 4445.59 | 0.00136346
4482.65 | 0.00138292 |  |  |  | 4482.65 | 0.00138292
4499.07 | 0.00139021 |  |  |  | 4499.07 | 0.00139021
4534.35 | 0.00140111 |  |  |  | 4534.35 | 0.00140111
4576.46 | 0.00141748 |  |  |  | 4576.46 | 0.00141748
4662.1 | 0.00144196 |  |  |  | 4662.1 | 0.00144196
4732.26 | 0.00147569 |  |  |  | 4732.26 | 0.00147569