Excel Cell



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.

Cell

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

Name Box

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.

Cell B2

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

column B

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

ctrl keyboard button + space

 

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

row 2

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

shift +space


Insert Row, Column

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

2040 row

1. Select row 3.

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.

after insert row



 

Published by Cash Heaven

Excel Expert and Financial Analyst Excel / Google Sheets / Financial Modelling, Valuation and Analysis Effective communicator / High quality / Affordable / Reliable / Quick Turnover I've successfully completed over 200 financial modelling, valuation and analysis projects with start-up stage and corporate companies over the past 4 years. I love to solve problems, have an eye for design, and have built business excel templates. I fix Excel formulas in 10 minutes.

One thought on “Excel Cell

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: