How to move selection in Excel?

Question

I know how to create or extend selections, i.e., via F8 or Shift F8. When I have created the desired selection, I would like to move that particular selection a few cells to the right and/or down.

I now need to select the similar form selection on another place in the worksheet. Does anyone know how I can do this?

Example:

Selection made on A1..B3, C3 and D5 and, for instance, made it Yellow. I now want to move this complete selection four places to the right, to E1..F3, H3 and I5 (to be able to make it another color).

It has nothing to do with the cut and paste to move cells.

Answer 1

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

Answer 2

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

Answer 3

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)

Answer 4

You can move a single selection shape to another location by right-clicking on selection, then select copy. To move the shape, select the upper-left cell of the destination, then click paste-special with something like comments or formats selected. If you are not using comments, selecting paste-special-comments is ideal since nothing happens except that the select region moves.

Answer 5

The only solution I know of is cut & paste. That's also what all the excel tutorials recommend for thing.

Simply click on the column header, then Ctrl+X, then on the new col-header, and Ctrl+V.