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.
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
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.
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)
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.
Depending on the context, you'd use the tab key or arrow keys.
what keys are used to select characters
Keep hold of the Ctrl key when you are selecting separate cells with the mouse. You can also press the F8 key and using the cursor keys select some cells. The press Shift-F8 and it will stop selecting and then using the cursor keys you can move to another part of the worksheet and press F8 again and start selecting with the cursor keys and the initial selection will remain selected. Press F8 again to stop completely.
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
Yes it does. Cells can be selected with the mouse or the keyboard by using the arrow keys to move to the cells you want to use in the formula.
In some cases, yes, and in others no. You can use the arrow keys to select cells or the mouse in point mode. If the last entry isn't a cell in your formula, then you can use the arrow keys to complete the entry. So the following formula could be entered using the arrow keys or mouse to select cells and completing it with the arrow keys: =A3*10 The following formula could not be: =A3*B3
Keys - as in a board of keys = keyboard
This goes back to the first typewriters in the 1800s that were mechanical manual machines. Originally the keys were arranged in alphabetical order. However typing english text on such a keyboard resulted in too many hammer clash jams (adjacent hammers would get stuck against each other and the typist would have to stop and unjam the machine). The fix, after some experimentation, was to jumble the keys into the modern "qwerty" order so that it was very rare for adjacent keys to be typed in sequence.