Ms-Excel 2007
About Lesson

The cell which is a rectangular box formed by the intersection of row and column can be named with the names of it’s column and row.

Example: Cell name A5 means Cell in Column A and Row 5.

The name of cell is known as Address or name of cell.  One cell can be activated to accept data which is known as active cell.  Active cell has thick border than others.

The name of active cell is displayed in the name box.

Activate any cell:

Click inside the cell

(or)

type name of cell in name box–>press enter

Entering Data into Cells:

  1. Select the cell
  2. Type required data
  3. press enter/tab/arrows to accept data
  4. press Esc to reject data

Editing contents of cell:

Double click on cell

(or)

activate cell–>Click in formula bar

(or)

activate cell–>press F2

Excel cell stores contents along with format, formulas and comments.

clearing contents of cell:

Right click on cell–>clear contents (or) select cell(s)–>press del (Only contents will be cleared)

(or)

Home tab–>Editing group–>Clear–>Clear All/formats/contents/comments

You cannot copy content of this page