0
To do something with them. Once they are selected you can delete them, format them, edit them, fill them, copy them, paste something to them, create a chart based on them and do lots of other things. When you are creating a formula, you would often select a range of cells that are to be used in the formula, particularly in functions. Being able to select cells is a critical thing in a spreadsheet or any kind of table.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What is range on a spreadsheet?
An input range could be the range of cells a function needs to be entered to do its task. Many functions use input ranges. If you wanted a sum of a range of cells and specified them in a range, that would be an input range. In the following example the cells from A2 to A20 are the input range: =SUM(A2:A20)
What happens when you select a cells fill handle?
Nothing happens if you just select the handle. But, if you click, hold, and drag, you will copy one of two ways.If you select a single cell or a range of cells with the same entry, you will copy the contents of the original cell to the other cells you highlight.If you select a range of cells that has a recognizable sequence, you will continue that sequence to the other cells you highlight.
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.
When pasting a group of copied cells to target range you need the only select the what cell of the target range?
Usually you select the top left cell of the range.
When using a function to perform a calculation how would you select the range of numbers to use?
Drag the cursor through the set of 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.
To paste a range of cells you only need to select the cell in the corner of the target destination?
You select the cell which will act as the top left cell of the destination.
How do you select a Range in using the name box in Microsoft Excel?
The range is the cells that are selected or used in some way. For example, a SUM function using a range of A2:A4 would add the values in A2, A3, and A4, or all of the cells within the range. Ranges can span many rows, columns, or both. They can be called a range or a block.
What do you use to restrict a range of cells to only displaying three decimal places?
-- Select the range of cells.-- Pull down Format \ Cells \ Number \ Decimal Places: (fill in '3')
What will happen if you select a range of cells such as D5 D7 then press the ctrl key and select a different range of cells such as D11 D13?
You will highlight all the selected cells (assume you hold the Ctrl key down while you click on the selected cells). D5, D6, D7, D11, D12, D13
How do you change a cell to 26pt on exell program 2003?
Select the cell or range of cells you would like to change.From the formatting toolbar, click the font size drop-down box and select 26.
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.
