How to use Excel : Excel Basics – Different parts of Excel worksheet area


Introduction

Though there are a lot of important sections of MS excel but as Excel is basically a data tool, hence it is quite obvious that the most crucial part if excel will be that portion where on ecan enter data. In other words the most important part is the main worksheet area of excel. It is therefore very important to know how the worksheet area is divided into cells,rows and columns and how each cell gets its uniqueness from the row and column it belongs to.

Different sections of Main worksheet area of excel

Here are the different parts of the main worksheet area of excel

Cells

The main worksheet area consists of the cells in which we can enter, manipulate and display data as per our requirements. These cells are the rectangular spaces in which we enter data.

Different parts of the worksheet area
Rows/Columns

These cells can be grouped into rows and columns.

The horizontal group of cells are called the rows.

Different parts of the worksheet area

The vertical group of cells are called the columns.

Different parts of the worksheet area

Every cell on the sheet has a unique name. This name depends on the naming system of cells that we are using and the row and the column in which the cell is residing. We have a detailed tutorial on how the cells are named.

Current Cell

The cell that is active i.e. the cell that has the focus at any moment is called the current cell. One can enter and edit data only in the current cell.

There are three ways in which excel differentiates the current cell from the others -

  • A dark green border appears around the current cell.
  • The name box of the formula bar shows the address of the cell
  • The row number and the column letters of the current cell are shaded in the row and column headings area.
Different parts of the worksheet area

Conclusion

Now that we know how the worksheet has rows and columns and how cells can be identified by the row and column it belongs to. It is very important that users know the nomenclature of excel cells and how each cell is given a name according to its row and column. This knowledge makes jumping from one cell to another easy.