Richard Willis
Blogger
Share this content
0
9
854

Excel - Question or Suggestion?

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.

Replies

Please login or register to join the discussion.

avatar
By blok
22nd Jan 2013 15:27

hold down the shift key and then select the other cells.

Thanks (0)
22nd Jan 2013 16:17

Have I misunderstood?

I thought you meant if you had highlighted A1, A7 and A10 (using ctrl clicks), can you make it so it then highlights B1, B7 and B10 without having to select each.

If they are sequential, then Blok has it.

Thanks (0)
avatar
22nd Jan 2013 17:07

A variation on a theme

A variation on blok's method is to click the top left cell, go to the bottom right cell, hold shift and click.

Thanks (0)
avatar
22nd Jan 2013 19:41

Constantly has got it

Both the other solutions will highlight both the original and subsequent selections.  I am highlighting a selection of sequential rows in a fairly massive sheet to take a quick look at the aggregate (but don't want to add sub-totals).  So having selected the cells in column B I then need to highlight the same rows in C (without B!) and so on.  As the selection is quite large it means a lot of scrolling up and down to do the job and would be so much easier if one could just shift the selection block sideways.

Thanks (0)
avatar
23rd Jan 2013 08:28

Try this

Sorry - misunderstood the question.

With your first column highlighted, using shift, extend the selection to the 2nd column as well.

Press Ctrl & . (the full stop)

Press shift & Right arrow

As ever with these things, easier to do than explain!

The CTRL & . moves the focus around the corners of the selection thus allowing you to resize it.

Thanks (1)
23rd Jan 2013 09:41

I see what you are doing

paulwakefield1 wrote:

Sorry - misunderstood the question.

With your first column highlighted, using shift, extend the selection to the 2nd column as well.

Press Ctrl & . (the full stop)

Press shift & Right arrow

As ever with these things, easier to do than explain!

The CTRL & . moves the focus around the corners of the selection thus allowing you to resize it.

I see what you are doing, but unless I am doing it wrong (a distinct possibility!) that only highlights 1 cell in the next column.  So you end up with A1, A3, A5 and B5.

But I've learned a new trick at least!

Thanks (0)
avatar
23rd Jan 2013 10:21

Brilliant Paul

That works (Constantly, you're doing it wrong!)

Thank you Paul

Thanks (0)
avatar
24th Jan 2013 08:57

Sorry constantly

you may NOT be doing it wrong; I am using sequential cells; I am not sure whther it will work for non-sequential ones!

Ed.  I just tried it.  The first Shift-R Arrow only moves the last cell highlighted so it will only work for sequential cells.

Thanks (0)
avatar
24th Jan 2013 09:28

I am not aware

that you can move non sequential selections without a macro (very happy to be proved wrong). However, the very wonderful ASAP Utilities does allow you to do this as well as a myriad of other things.

Thanks (0)