0
How do you select a group of cells in Excel with keyboard commands?
Wiki User
∙ 9y ago
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.
Wiki User
∙ 9y ago
Wiki User
∙ 9y agoThere 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.
Add your answer:
Earn +20 pts
In Excel When selected a column header how many cells are selected?
When you select a column header in Excel, all the cells in that column are selected. This means 65536 cells (the maximum number of rows in Excel). Similarly, if you select a row header, this will select 256 cells (the maximum number of columns in Excel). For more information on Excel Size and Cells: http://www.excel-hocam.com/mod/resource/view.php?id=18&username=guest
What is the purpose of the cell cursor in an excel sheet?
to select cells
What does the f8 function do in Microsoft Excel?
It is a way of allowing you to select cells with the keyboard. If you press F8 and then start pressing the arrow keys, you will find it starts to extend the selection. Shift F8 can be used to help you to select non-contiguous cells. Alt-F8 can be used to run Macros.
How do you name a selected range of cells in Excel 2007?
Select your cells. Go to the Formulas tab. Select the Name Manager. Then you can create a name for the selected cells.
What is semi-selection in excel?
A semi-selection in Microsoft Excel is the action of selecting a few cells in a worksheet. To select the cells, you would click on them to highlight.
Which Excel feature enables you to select certain types of cells like number cells or text cells?
The Goto Special command.
Does Point mode allow you to select cells for use in a formula by using the keyboard?
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.
What is the range of cell when you select all cells in Excel?
That depends on the version of Excel. Up to Excel 2003 it would be A1:IV65536. From Excel 2007 onwards it would be A1:XFD1048576.
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.
Which key do you hold if you want to select a large range of contiguous cells in excel?
shift key
What button causes Excel to insert dollar symbols in front of the row?
Right click on the cell, select format cells, select currency and $.
How do you get excel to ignore blank cells in a chart or how can you select only specific cells to put into the chart?
Excel is too alert and observant to ignore anything. The second method is therefore the correct one.
