0
How do you select a large range of contiguous cells Which key do you press and hold?
Wiki User
∙ 13y ago
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.
Wiki User
∙ 14y ago
Wiki User
∙ 14y agoYou put your mouse on one corner of the cell then hold it to select the other cells you want to be highlighted.
Add your answer:
Earn +20 pts
What key to used in Excel for a range of 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.
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.
What do you do if you want to select cell A1 and cell B4 in Excel?
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
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.
How do scrolling effects directv?
Press menu Setting & help press select Settings press select Display press select Preferences press select Scrolling effects press select On press select
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)
How do you select cells that are not next to each other in Excel?
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.
How do you select a row in Excel?
Click on the label for the row you want, then hold 'Ctrl' and click on any extra row you want. You can also press the Shift key and the spacebar to select the current row or rows, if cells from more than one row are already selected.
How do you select a group of cells in Excel with keyboard commands?
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.
In how many ways you can select a row and a column in MS Excel?
Click on the row header or column header. Press Ctrl-Spacebar to select a column. Press Shift-Spacebar to select a row. If you have cells in more than one column or row selected when you do either of these it will select all of the columns or rows that have selected cells. If you go to the first cell in a completely blank row and press Ctrl-Shift right arrow, it will select the entire row. If you go to the first cell in a completely blank column and press Ctrl-Shift down arrow, it will select the entire column. If there is some data in any cells in the row/column or if you are not in the first cell when you do it, these commands will select part of the row/column only, depending on where data is.
How do you insert the content across multiple cells?
There are a few different ways. You can use the fill handle. You can select the area and press Ctrl - R to copy to the right. You can select the area, type what you want into the first cell and press Ctrl - Enter to put it into all of the cells that have been selected.
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.
