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.![]