Excel – How to move the selection down one row in Excel 2007

Windows Microsoft Excel 2013, options available only for contiguous selections (say A10:A20):

Option A (moving any selection around):
1. Make your selection A10:A20.
2. Press Shift and keep it pressed.
3. Press → until you reach your desired symmetrical column where you want your selection pattern cloned. (selection is now let's say A10:D20)
4. Press Tab while still keeping Shift pressed until it lands into D column (usually it's only once)
5. Press again → and the selection will shrink from A to D until D is selected.
6. Release Shift.

You now have D10:D20 selected. Seems long but once you practice a bit it's lightning fast.

Option B (if only for formatting cloning), answered previously too:
1. Make your selection (A10:A20).
2. Ctrl + C (copy)
3. Let's say you want to clone formatting to D10:D20.
4a. Right click D10 cell.
5a. Paste special menu,
6a. Choose Formatting (or press R).

Or, if you want it faster, keyboard only, from point 3:
4b. Press Alt + E + S (paste special window opens)
5b. Press T (format option is selected)
6b. Press Enter and voila.

Hope this helps, I needed it as well to clone some conditional formatting faster.

What you can do is use the INDIRECT formula along with another cell where you specify your range. The INDIRECT formula allows you to return a cell reference or range based on a text string. For example, you can set a cell equal to =INDIRECT("A2") and it will show the value of cell A2.

As for how this pertains to your question, if for example we place the text string A1:A15 in cell B1, you can then get the sum of that range with this formula: =SUM(INDIRECT(B1)). Modifying the range in cell B1 will then modify the computed sum accordingly, and you can also perform other formulas with that, like =MEAN(INDIRECT(B1)).