Microsoft Excel 2007 tutorial: delete cells, rows, columns on a worksheet


Delete cells, rows, columns on a worksheet

XX. Delete cells, rows, columns on a worksheet

When you don't need cells, rows, and columns on a worksheet, you can delete them. To delete the cells, rows, and columns, follow the following procedure.

+ Delete cells

- Select the cells that you want to delete

- Right-click the selected cells, and then click Delete on the shortcut menu.

Excel 2007 delete cells

The Delete dialog box appears:

Excel 2007 Delete dialog box

You have four options to choose in the dialog box including Shift cells left, Shift cells up, Entire row, and Entire column.

§ If you click Shift cells left, the remained cells move to the left of where the selected cells deleted.

§ If you click Shift cells up, the remained cells move up of where the selected cells deleted.

§ If you click Entire row, the row of the selected cells delete.

§ If you click Entire column, the column of the selected cells delete.

- Click any option you want.

- Click Ok

You can also use another way as the following:

- Select the cells that you intend to delete.

- On the Home tab, in the Cells group, click Delete if you don't want to choose the options of deleting cells. Click drop-down arrow next to Delete, and then click Delete cells if you want to choose the deleting options or you can use shortcut key by pressing Ctrl + -.

Excel 2007 Delete cells tool

- Click Ok after you choose any option of deleting cells.

For example, you have a worksheet as the figure below:

Excel 2007 Worksheet example of deleting cells

You want to delete two cells in column A (cells on the first and second rows) and want the remained cells on the same rows of deleted cells moving to the left. To do this task, follow the procedure below:

1. Select the two cells

2. Right-click the selected cells

3. Click Delete on the shortcut menu.

Excel 2007 delete two cells

The Delete dialog box appears.

4. Click Shift cells left

5. Click Ok

You can use another way by selecting the two cells, then go to the Home tab, in the Cells group, click Delete. Or click drop-down arrow next to Delete, and then click Delete Cells (Ctrl+ -). The Delete dialog box displays, click Shift cells left, and then click OK.

Excel deletes the two cells and moves the remained cells to the left of where the selected cells deleted. See the figure:

Excel 2007 delete cells result

+ Delete rows

- Select the rows that you want to delete.

- Right-click the selected rows

- Click Delete on the shortcut menu.

You can also select the cells of the rows, and then do the following:

- Right-click the selected cells

- Click Delete on the shortcut menu.

- Click Entire row on the Delete dialog box.

- Click Ok

You can also use another way as the following:

- If you select the rows, go to the Home tab, in the Cells group, click Delete.

- If you select the cells of the rows, go to the Home tab, in Cells group, click drop-down arrow next to Delete, and then click Delete Sheet Rows.

For instance, you intend to delete a couple of rows in the worksheet of example above. The rows that you plan to delete are the first and third rows. To do this task, do the following:

1. Select the first and third rows

2. Right-click the selected rows

3. Click Delete on the shortcut menu.

Excel 2007 delete rows

Or you can select the cells of the first and third rows, and then do the following steps:

1. Right-click the selected cells

2. Click Delete on the shortcut menu.

3. Click Entire row on the Delete dialog box.

4. Click Ok

Excel deletes the two rows and moves the remained row up to the first row of the worksheet.

Excel 2007 delete row result

If the two way above fail to satisfy you, use another way that we already showed you in the lesson.

 + Delete columns

- Select the columns that you want to delete.

- Right-click the selected columns

- Click Delete on the shortcut menu.

You can also select the cells of the columns and then do the following:

- Right-click the selected cells

- Click Delete on the shortcut menu.

- Click Entire column on the Delete dialog box.

- Click Ok

You can also use another way as the following:

- If you select the columns, go to the Home tab, in the Cells group, click Delete.

- If you select the cells of the columns, go to the Home tab, in Cells group, click drop-down arrow next to Delete, and then click Delete Sheet Columns.

 


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.