---

---

In Microsoft Excel, a cell is a rectangular box that occurs at the intersection of a vertical column and a horizontal row in a worksheet.

Thus, it is defined by a combination of column and row e.g., A1

A cell stores 1 data at a time. These data can be a formula, text value, numeric value.

---

Cell, Row, Column

Let’s start by selecting a cell, row and column.

1. To select cell B2, click on the box at the intersection of column B and row 2.

2. To select column B, click on the column B header.

You may also select the column B without using a mouse using this shortcut

+

 

3. To select row 2, click on the row 2 header.

You may also select the row 2 without using a mouse using this shortcut

+

---

Insert Row, Column

To insert a row between the values 20 and 40 below, execute the following steps.

1. Select row 3.

2. Right click, and then click Insert.

Result:

The rows below the new row are shifted down. In a similar way, you can insert a column.

---

---