How to select multiple cells in excel without Mouse

I need to know about excel sheet cell selection. I want to select cell in excel like this:



without mouse. It means I want to select them by using only keyboard. Suggest me if you know about it.

 

Just select a cell...and then pressing down the shift key.....press the up or down key simultaneously....this should help you select cells in a column.

For selecting cells in a row.....press and hold shift and press left or right key...

Regards,

RightMan

 

My question is different. In the image you can see there are different cells has been selected by mouse but this thing I want to do by keyboard. Is it possible or not?

 

Are you using laptop with a touch pad? Just press and hold the shift key and move using the left and right key.

After that we you want to move to different column, just use your touch pad to move the pointer and then while holding down the ctrl key, touch and select another cell. Repeat the steps above.

Other than the touch pad, I don't find any other ways possible. Maybe others can help...

 

I knew one can do that with the help of mouse.....but OP wanted to do the same without mouse...so was wondering..how does one move the cursor away from the already selected cells with just KB....?

Regards,

RightMan

 

No there's no way to do that without a mouse.

 

Your, suggestion is good. I tried to do and I was succeed but some guys announce that it is not possible on desktop as you have already said.

 

Sure it's possible, it's called extend mode. To support users with disabilities, most everything is possible without a mouse in well designed software products.

To turn extend mode on or off, press F8. You will see EXT in the status bar.

To add another range of cells to the selection, press SHIFT+F8, you will see ADD in the status bar, then use the arrow keys to move to the start of the range you want to add; press F8 and the arrow keys to select the next range, and so on.

HTH

J McAhren

 

There is. select the first group of cells. Press Shift+F8 key to keep your selection selected move around your excel sheet. select the other group of cells as you select normally.Press Shift+F8 again if you wish to select more non sequential cells

 

Excel, if properly practised, does not require mouse at all

 

That's true. We have try out all the key and explore ourselves. There is also a short-cut keys list available.

 

Great answer.I am not an expert in excel.But i always try to learn new things while it strikes me.Thanks for putting the piece of information right here.

 

Thank wooderson for the tips.. I never know this as well.