Holding Shift and tab through worksheet

[Tony1322]

For some reason I am no longer able to simply hold down the shift key and hit tab to copy consecutive cells, rows, or columns and I do not know how to fix. I use this all the time - can someone please help me. I know it is probably simple, but simple answers are harder to find than more complex ones. thanks - Tony

[#2]

@Tony1322 

According to Keyboard shortcuts in Excel:

To do this	Press
Move to the previous cell in a worksheet or the previous option in a dialog.	Shift+Tab

In my experience, Excel has always worked like this...

[#3]

@Hans Vogelaar 

Hello Hans,

Thanks for the reply, but…that is the problem.

What you explained is how I always did it, but I must have clicked something on the tool bar that changed this procedure.

If I move to a previous cell, hold shift, then click tab, nothing happens. It doen not move or include etc.

What I need to do now is …from previous cell hold shift and then click on each additional cell with the mouse.

Very frustrating.

Do you understand?

Ciao,

TS

[#4]

@Tony1322 

Do you want to select multiple non-adjacent cells? If so, hold down Ctrl and click on each cell (don't use Tab).