answersLogoWhite

0


Best Answer

To remove the contents, just press the delete key. You can also drag the fill handle back up over the selected cells and it will also remove the contents. To remove the cells completely, go to the Edit menu and pick the Delete option and pick the option you want on the dialogue box that appears. The Delete option will also appear on the shortcut menu if you click the right mouse button.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How to Remove a range of cells after selecting it?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is selecting the process of highlighting a cell or range of cells?

Yes.


What is the difference between adjacent and non adjacent cell range in Excel?

In Excel, an adjacent cell range is the selection of nearby cell range that is touching another range, but is still a separate range. A non-adjacent cell range is the selection of cell range that is not touching any other cell range. In either case, it can only be when more than one range is selected. After selecting one range, pressing and holding the Ctrl key while selecting a range can select another range.


What is the purpose of selecting cells in MS Excel?

The purpose is to do something with those cells. For example, if you want to delete a range of cells; or change the font name or font size; or turn bold on or off; or draw a border around them, you first select the cells, to specify which cells you want to work on.


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.


Why do all cells need a cell membrane?

At times, you might need to remove, or clear, all the formatting applied to a cell or range of cells


What happens when the SUM button is clicked?

Excel will attempt to sum cells by selecting nearby cells which it presumes are the ones to be selected and summed. Usually this will be the cells above. If you select a range of cells and then click the Autosum button it will use the selected cells and sum them, putting the total at the bottom of the column, or it can do it for several columns, giving a total for each.


What is a series of two or more adjacent cells in a column or row or a rectangular group of cells in Excel?

A Range


How do you delete on excel?

It depends on what you want to delete. Deleting what is in cells can be done by selecting them and pressing the Delete key. You can also delete charts by selecting them and pressing the Delete key. To delete full rows and columns, you can select them and use the menu/ribbon options to remove them completely.


To combine two or more cells by selecting which option from the table menu is used?

Merge Cells.


You can change the range to which you want to apply the sum function by just selecting the desired range?

Yes you can.


A range of cells is a contiguous block of cells?

Yes, a range is a contiguous block of cells.


Selecting the maximum value out of a range A1 to B20?

A1 to B20