# desparately need help

#### silvertree

##### New Member
I've selected a cell range, say A1:A10

now I want to move the entire range down 10 cells, so the new range will be from A11:A20.

can I do this using a formula?

thank u so much!!!!!!!!!

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### agihcam

##### Well-known Member
Hi -
Welcome to the board. position the cursor outside the selected range and when the cursor turn to arrow, left click then drag to the specified range.

#### Richard Schollar

##### MrExcel MVP
Hi Silvertree

Welcome to the Board!

I'm not sure I follow you, but you can use Cut & Paste to move the cells elsewhere. You could use formulas to reference the existing range, but the range would still subsequently exist in A1:A10, with duplicate values resulting from the reference in A11:A20.

Perhaps you can explain in more detail exactly what you are trying to do?

Best regards

Richard

#### silvertree

##### New Member
Sorry, I didn't explain it clearly.

I have lots of data so I cannot do that manually to all the data.

Actually I want to sum the values A1:A10 then I want to sum values in A11:A20 then sum values in A21:A30 and so on and so on...

Is there a way I can move the range down 10 cells every time?

How can I do that?

#### agihcam

##### Well-known Member

then where would you want to put the sum

#### Richard Schollar

##### MrExcel MVP
Well, you could use the following formula in an adjacent free column:

=SUM(OFFSET(\$A\$1:\$A\$10,(ROW()-1)*10,0))

enter this in the first row eg B1 or C1 or D1 and copy down.

Richard

PS You may find pivot tables to be of use depending on your specific situation.

#### silvertree

##### New Member
Thank you so much Richard. But that doesn't work........
what is ROW()-1*10?

Replies
2
Views
84
Replies
4
Views
57
Replies
3
Views
97
Replies
3
Views
62
Replies
8
Views
80

1,136,347
Messages
5,675,235
Members
419,555
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back