We can select non-adjacent cells by holding down the control key and then simply choosing the desired ones by a single click of a mouse.
However this can be very frustrating at times, because if you have mistakenly released the control key and you are not through with your selection yet,then you will have to start all over again.
We can get around this problem by just pressing the (shift + F8) keys once and then highlighting the cells that you need,using the mouse.
When you are through with your selection, you can press the same keys again or just hit the “Esc” key.
Popularity: 19%