0
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)
Wiki User
∙ 13y ago
Wiki User
∙ 12y agoA range can only be cells that are adjacent and in a rectangular shape. It is possible to select non-adjacent cells but this would not be regarded as a range. See the related question below for instructions on how to select non-adjacent cells.
Wiki User
∙ 6y agoThe Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
The Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
The Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
The Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
The Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
The Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
The Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
The Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
The Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
The Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
The Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
Wiki User
∙ 11y agoSelect your first set of cells in the normal way you would. Then press and hold the Ctrl key to select any other sets of cells. You can also press the F8 key and using the arrow keys, select cells. Then press Shift-F8 and move to another area and press F8 again to start selecting again.
Wiki User
∙ 7y agoSelect the cells and then copy them. You can copy them by many different methods, such as the icon on the ribbon, doing Ctrl - C, taking the Copy option on the shortcut menu and other ways. Go to where you want the first cell in the range to be. Then do a paste. Like copying, there are different ways, such as Ctrl - V and also from the ribbon or shortcut menu. Another way to copy it is to select the range, put the mouse on the edge and press the Ctrl key and then when you see a small cross above the mouse pointer, keep holding the Ctrl key and drag to where you want the new copy to go.
Wiki User
∙ 14y agoTo specify separate cells and ranges in a function, you separate them by commas, like this:
=SUM(A2:A10,B16:B30,D5,G20)
If you are selecting the cells, you hold the CTRL key and then click in the other area of the sheet that you want to select cells from.
Wiki User
∙ 11y agoThe Ctrl key. You hold it while selecting the other cells with the mouse. It can also be done with the F8 key. Press the F8 key and then using the cursor keys you can select cells. The press Shift and F8 and it will stop selecting and you can move the cursor to another part of the worksheet and select more cells.
Wiki User
∙ 7y agoHold down the Ctrl key as you click on the cells you want to select.
Wiki User
∙ 11y agoPress Ctrl and use the mouse to highlight the range. Do this, without releasing he Ctrl key, until you have selected the cells you want.
Wiki User
∙ 6y agoHold down the control key (Ctrl) and click in the various cells you wish to select. The chosen cells will become highlighted.
Add your answer:
Earn +20 pts
Can you select nonadjacent ranges using the shift key in excel?
No. You need to use the Ctrl key to select non adjacent ranges.
What could be a nonadjacent range in Excel?
A range can only be cells that are adjacent and in a rectangular shape. It is possible to select non-adjacent cells but this would not be regarded as a range. Each would be a separate range. So usually non-adjacent ranges will have gaps between them, although it is possible to have cells from to separate ranges right beside each other. You will know them by their boundaries around them.
Describe the two types of cell ranges in Excel 2007?
Adjacent and nonadjacent
What is a group of cells that can be adjacent or nonadjacent called?
A range.
How many times do you click the format painter button and then drag through the nonadjacent ranges to paint the formats to the ranges?
Double Click
What key on the keyboard is used to select nonadjacent objects in a publication?
CTRL (controle)
Is the ALT key used to select different placeholders or different paragraph text that are nonadjacent?
false
What is a contiguous range in Excel?
There is no such thing as a non-contiguous range. A range is a group of cells that are together in a rectangular block. Non-contiguous refers to cells that are not touching. So you can have more than one range which do not touch, so what you have are non-contiguous ranges. It is possible to select non-contiguous ranges by first selecting one range and then while holding the Ctrl key, select other ranges.
How do you select nonadjacent columns or rows in excel?
After selecting the first row or column, press and hold the ctrl key and click on the header of the next row or column you want to select.
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 are some sentences using the word nonadjacent?
I'm not very interested in nonadjacent properties.
How do you select two different ranges on Excel?
Select the first range as normal. Then press and hold the Ctrl key and select the other range with the mouse. The first range will stay selected. You can select as many ranges as you want using this method.
