0
You can click and drag from one cell along a row, down a column, or to the opposite corner of a rectangle.
Wiki User
∙ 13y ago
Wiki User
∙ 14y agoThe Shift key. If you hold it down and click on another cell, the range that is created with those two as opposite corner cells will be selected.
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.
When you move the mouse while holding down the mouse button to select a range of cells?
If you drag across the cells while pressing the right mouse button, it will select the cells.
Can you create formulas in Excel using the mouse?
Not entirely, but you can use a mouse to select ranges you include in a formula.
What is the easiest way to copy data into the cells adjacent to the original?
A quick way to copy data to adjacent cells is to use the Fill Handle (small square in bottom right corner of the cell). Just click and drag the handle to the number of cells you choose (in the same row or column). When you release the mouse button, Excel will copy the contents of the original cell to the cell range you have highlighted with the mouse.
What does pointing mean in Excel?
Move the mouse cursor to what you want to select.
What allows cells to be selected?
Cells can be selected by the mouse or the keyboard. Pressing and hold the left mouse button and dragging across cells will select them. Pressing and holding the shift hey and then using the cursor keys can select cells. The F8 key can also be used to select cells.
What key do you use to select noadjacent cells?
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.
Why in excel when you copy non-adjacent cells does excel copy all the cells between them For Example I select and copy cells A1 B1 and E1 Yet when I paste them it paste A1 B1 C1 D1 and E1?
If you use the fill handle, it will fill all the cells in between. If you select non adjacent cells at one time and then paste, it automatically pastes them beside each other. So if you select A1, B1 and E1 and copy them, and then put the cursor in A2 and do a paste, the values will be pasted into A2, B2 and C2. The best thing to do is copy them separately and paste them where you want to. So select A1 and B1 and do a copy. Go to where you want to put them and do a paste. You can do a copy in lots of ways, like through the Edit menu, Ctrl and C, the copy icon or by right clicking on the mouse. Paste can be done through the menus and icons or by using pressing Ctrl and V.
Which key would you use in conjunction with the mouse to select adjacent files?
[Shift] + mouse click will select all from the first selected to the one you shift click. [Ctrl] + click will select individual files, adding them to the group selected, without adding any others.
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)
What is the most efficient way to select cells?
Clicking on a cell with the mouse and dragging out across the cells that you want selected.
What is the definition Point Mode for Excel 2007?
In Excel it allows you to enter formulas using the mouse, by clicking on cells as you type a formula, instead on typing the cell references.
