Question

how will you select a range and non adjacent cell in a worksheet ​

Answer 1

Hello

First select the cells and click on CTRL when you select the cells then press shift+ F+8 to another cell or range of cell to the selection then to stop selecting range of cells or cell press SHIFT+F8 again....

Hope it will help you ✌️

Answer 2

With ctrl key and mouse key :-

• With ctrl key and mouse key :-Go to first cell which you want to select, click mouse pointer and make it an active cell.
• With ctrl key and mouse key :-Go to first cell which you want to select, click mouse pointer and make it an active cell.Press and hold ctrl key on the keyboard.
• With ctrl key and mouse key :-Go to first cell which you want to select, click mouse pointer and make it an active cell.Press and hold ctrl key on the keyboard.Now click on rest of the cells which you want select without releasing ctrl key and as the required cells are selected release the ctrl key.

Note: Don’t click you mouse pointer anywhere else once you release the ctrl key else you will lose all of the highlighted cells.Be careful while selecting cells with using ctrl key, unwanted selection can’t be deselected.In case you release the ctrl key very soon and you wish to select more cells all you need to do is simply press and hold the ctrl key (earlier cells must be highlighted) and start clicking on the additional cells again.