0
The simplest way is to press and hold the Ctrl key and then click on the other cells you want. As long as you keep the Ctrl key held, any cells you select will remain selected. It can also be done using the F8 key to turn the selection and extend modes on and off, but that is far more awkward, so just use the Ctrl key and the mouse.
Wiki User
∙ 14y ago
Wiki User
∙ 11y agoThe Ctrl key can do it, when used in conjunction with the mouse. You can also use the F8 key to select cells, and using combinations with shift, you can select non-adjacent cells.
Add your answer:
Earn +20 pts
What keys on the key board select adjacent cells?
The Ctrl key can do it, when used in conjunction with the mouse. You can also use the F8 key to select cells, and using combinations with shift, you can select non-adjacent cells.
What key do you use in Excel to pick two different groups of cells?
Hold down the Ctrl key as you click on the cells or group of cells you want to select.
How do you select a large range of contiguous cells Which key do you press and hold?
The simplest way is to click on the first cell and drag across the other cells you want whicle holding the mouse button. You can also do it by pressing and holding the Shift key and then use the arrow keys to select the cells around it. You can also press the F8 key and then use the arrow keys to select the cells around it.
How do you use a command to center the number in the selected cells?
Select the cells you want to affect and press E on the keyboard while holding down the Control key.
Is it true that you can select cells using the keyboarding by pressing and holding the control key and using the arrow keys to extend the selection?
No it is not true. You would use the Shift key, not the Ctrl key to do it.
How can you select nonadjacent ranges of cells?
Select your first range in the normal way. Then press and hold the Ctrl key and with the mouse select the next area. The original area will remain selected. If you do this you can select cells that are non adjacent. A less common way to do it is using the F8 key. Put the cursor in the first cell. Press the F8 key. To select several adjacent cells use the arrow keys. To stop the selection press F8 again. To stop the selection but retain the selected cell and move to a non-adjacent cell to select again, press and hold the Shift key and then press F8. Go to the cell you want using the cursor keys and then press the F8 key when you want to start selecting again. You could also just drag the mouse over different areas of the worksheet having pressed Shift and F8, in the same way as you can with the Ctrl key. Within a formula cells that are not adjacent can be specified by listing them with a comma in between them. Ranges are specified with colons. It is possible to use both: =SUM(A1:A20,B16,C45,D11:D13)
Can you select nonadjacent ranges using the shift key in excel?
No. You need to use the Ctrl key to select non adjacent ranges.
Use what to check which cells are referenced in the formula assigned to the active cell?
Pressing F2 will show the formula and the referenced cells in it will be colour-coded and highlighted. Pressing and holding the Ctrl key and then pressing the [ key will select the cells referenced in the formula.
How do you select multiple cells?
There are several ways. The simplest is to use the mouse. Click on the first cell you want. Then holding the left mouse button, drag out over the area you want to select. Another is to click on the initial cell and then holding the Shift key down, use the arrow keys to select in the direction you want. Another way is to click on the first cell and press the F8 key. Then using the arrow keys select in the direction you want.
How do you get rid of an array in Excel?
Select the entire array and press the Delete key. There are usually only problems if you want to delete some, but not all of the cells in the array.
How do you copy the value in a single cell to adjacent cells on the right in Excel?
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
In order to select more than one slide at a time in slide sorter view hold down this key and select?
There are two answers to that. You can use the Shift key to select a group of contiguous slides, in other words slides that are together. You can use the Ctrl key to select non-contiguous slides.
