0
With the range selected, press the delete key.
With the range selected, use the fill handle and drag back up over the range and it will clear the cells.
With the range selected, go to the Edit menu and use the Clear option.
Wiki User
∙ 14y ago
Wiki User
∙ 10y agoYou can use the cut option and the paste option to move a range. You can also select the range and put the mouse on the border of it until you see the cross with 4 arrow heads. You can then drag the range to a new position.
Wiki User
∙ 14y agoClick on the row number to select the row. Then go to the Edit menu and pick Delete. You can also right-click on the mouse and pick Delete from that menu. You don't always have to select the row, but if you don't when you do any of the deleting options, you will be asked what you want to delete. Delete on any of the menus will remove the row completely. If you only want to remove the contents and not the row itself, pick Clear from the menus or just press the Delete key.
Wiki User
∙ 12y agoSelect the row you want to delete, then right click and pick delete.
Wiki User
∙ 12y agoFirst select all the cells. Then press the Delete key.
Add your answer:
Earn +20 pts
Is it true that a rectangular group of cells is called a range?
A rectangular group of cells in a spreadsheet can be called a range or a block.
What is more smallest a column or a row?
There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.
Why would you select a range of cells?
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.
How many cells would be included in the cell range B3D18 in a spreadsheet?
There is 16 rows and 3 columns, so it is 48 cells.
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)
Adjacent cells in a row or column are called a?
In terms of a database, they would be a record. In a spreadsheet it would be a range.
How can you reduce the number of cells in an Excel spreadsheet?
While the size of the entire worksheet will always remain the same, you can delete cells completely or just their content. Select the cells you want to delete. To delete their content only, just press the Delete key. To delete the cells completely, right click, select Delete... and choose the appropriate option, to either delete cells and move cells up or left, or to delete and entire row or column.
How can users clear a cell or range of cells?
The simplest way is to press the delete key when the cell or cells have been selected.
What happens In Excel when you insert or delete cells from a spreadsheet?
Extra cells or rows or columns are inserted or removed, though the total amount of each stays the same. As there are so many columns/rows/cells, Excel can effectively push off blank cells at the ends of the spreadsheet. Formulas can update themselves when changes are made, so it is not necessary to change formulas.
What is global formatting in Excel?
It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.It is formatting that is applied to the entire spreadsheet, as opposed to just some cells in it.
What is the term for all of the cells that go across the spreadsheet horizontally?
The cells that go across the spreadsheet horizontally is called a row of cells.
What is a collumn in a spreadsheet?
A spreadsheet column - is a vertically stacked series of cells.
