Excel - Question or Suggestion?

Does anyone know whether there is a trick to 'move' a selection from one column to the next?  I don't mean move the data but if I highlight a string of cells in column b I then want to highlight the same rows in column c, then d, and so on.

If it can't be done it jolly well should be able to be done!  It would be very useful.

Comments
There are 9 comments. Login or register to view them.

hold down the shift key and

blok |
blok's picture

Have I misunderstood?

Constantly Confused |
Constantly Confused's picture

A variation on a theme

paulwakefield1 |

Constantly has got it

Richard Willis |
Richard Willis's picture

Try this

paulwakefield1 |

I see what you are doing

Constantly Confused |
Constantly Confused's picture

Brilliant Paul

Richard Willis |
Richard Willis's picture

Sorry constantly

Richard Willis |
Richard Willis's picture

I am not aware

paulwakefield1 |