Excel Cells

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.

To select cell B2, click on the box at the intersection of column B and row 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.
CTRL+SPACEBAR: Select the entire column

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

You may also select the row 2 without using a mouse using this shortcut.
SHIFT+SPACEBAR: Select the entire row

---

Insert Row, Column

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

Select row 3.

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.

---

This post is designated as a reviewer for Basic Excel trainings I conduct.

Feel free to share with anyone. 😉

Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva.![]