How to move selection in Excel?

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.

You probably have to resort to macros to do this. I would assign a shortcut key to a macro that looks like this

Dim myRange As Range
Set myRange = Selection
myRange.Offset(0, 1).Select

Can be done with Mac version of Excel, but not Windows version. Option-return moves section vertically; Option-tab moves selection horizontally; Add shift to reverse direction.

On a keyboard with a separate numeric keypad, use Option-return because Option-enter does nothing. On a MacBook, return and enter are the same and with the option key moves the selection as advertised. The most general answer therefore might be to use Option-return.

I had the same exact question and my solution was in downloading ASAP utilites which is a set of tools used by macros. After the quick download you should see a new tab in Excel, "ASAP Utilities". From here there are two ways:

1. Ctrl + Alt + M

   and, if for some weird reason that doesn't work:

2. Select ASAP Utilities tab => Click Selection => Move or Resize Selected range (Ctrl + Alt + M)

I normally would use paste special for making the similar range yellow. In your example, I would copy the currently selected range and then I will click on the first cell of new range and will go to paste special formats.

It will not only apply the previous formatting as it was in the previous range to the similar number of cells, but will also keep the new range selected and this way you can easily choose a new color. simpler is better, Hope it helps.