Excel delete rows:Deleting cells, rows, or columns

delte_rows_1

YOUR OBJECTIVE

An Excel worksheet has too many empty rows between the heading and the contents. You don’t like this and want to delete an empty row. There is also a column with sales in British Pounds in your table, which you would like to remove.

In this learning module “Excel delete  rows” you will learn how to delete rows or columns.

Excel delete rows: HOW DOES IT WORK?

Before you delete cells, rows or columns from your table, you have to select them first.

On the Home tab, in the Cells group, click the  button. A click on this button will delete the rows, columns, or cells selected.

You can also delete one or more cells in the same way. Select them and click . The selected cell or cell range will then be deleted. Cells will be shifted upwards into the gap created.

You can also delete a cell, row or column by selecting a cell within the row or column you want to delete, and then clicking the arrow on the button. As your next step, select whether you want to delete the selected cell, or the column or row where the cell is located.

 

When you select Delete Cells…, the following dialog box where you can determine what action you want to take will open:

 

If you want to delete an individual cell and fill the gap by shifting the cells on its right to the left, select this option.

If you want to delete an individual cell and fill the gap by shifting the cells below it upwards, select this option.

If you want to delete the entire row where the selected cell is located, select this option.

To delete the entire column where the selected cell is located, select this option.

Excel delete rows: KEY COMBINATION:

You can also delete cells, rows, or columns with the [Ctrl]+[-] key combination.

 

Excel cell color: Coloring and shading cell backgrounds

cell_color_1

YOUR OBJECTIVE

You already formatted your Excel table. Now you want to add color to your table by using background colors, i.e., shading.

In this learning module “excel cell color”, you will find out how to fill the backgrounds of cells and cell ranges with colors.

 

HOW DOES EXCEL CELL COLOR WORK?

First select the cell or cell range that you want to fill with background color. Then click the small black arrow on the Fill Color button (Home tab, Font group).

The Theme Colors catalog will appear. Here you can select the color of your choice by clicking on it. The background(s) of the selected cell(s) will now be filled with the selected color:

 

HINT

If you do not see a color you like, click .

If you want to control the fill-color characteristics more closely, click the dialog box launcher on the Home tab, in the Font group.

 

The Format Cells dialog box will appear. Now go to the Fill tab.

 

In the Background Color area, you will find a variety of colors. Click on the color you want to use.

If you are looking for a special color, you can find a greater variety or mix a color yourself by clicking More Colors…

In the Pattern Color and Pattern Style selection lists, you can specify a pattern style to serve as a background and color it as well.

To use a special color effect (i.e., graduated shading) on cell backgrounds, click Fill Effects…

If you do, the Fill effects dialog box will appear:

 

In the excel cell Colors area, you can specify how many colors you want to use for the fill effect.

Select the excel cell colors you want to use in the Color 1 and Color 2 selection lists.

Use the Shading styles area to select a look that suits your purpose.

For some shading styles, you can also apply a Variants option.

In the Sample area, you can see the result of your current settings.

When satisfied with your settings, click OK.