Organization of the worksheet area
Rows and Columns
A worksheet is made up of rows and columns and 65,536 rows. Row numbering in Excel
is straightforward. The first row is called row 1,the second row is called row 2, and the fifth row
is called row 5 and so on. The first 26 Columns are referred to by letters A through Z. the 27th
Column is called AA,
Cell and cell address
The area formed by the intersection of a row and column is called a cell. The cell is the
smallest unit in the worksheet that is used to store data. The column letter followed by the row
number forms the cell's address. For Eg: A1 is the cell address of the upper left cell. Cells can
contain text, numbers, or formulas to refer to a particular cell, you call it by its column letter, and
then by its row letter. For example, the cell in the uppermost left comer would be "A1." The
current cell(s) will always be listed in the "Name Box,"which appears on the left below the
toolbars.
Active cell
In the worksheet there is a thick border around one of the cell.
Range
In Excel, a range is any rectangular area in the worksheet. A range may include just a single
cell, a number of consecutive cells in a row or column, or cells from consecutive rows and
columns. In Excel, a range is defined by specifying its first and the last cell. For example A1:A5
or A1.A5
Insert Rows & Columns:
You may find that you need to insert a new, blank row where there isn't a blank row any more.
To insert a new blank row, place your cursor directly below where you would like a new row.
Select Insert >>Rows. To insert a new column, place the cursor in a cell directly to the right of
where you would like the column. Select Insert >>Columns.
Cell Formatting:
You may notice that, by default, Excel will leave as many decimal points as possible within the
cell's width restraints., as you increase the cell's width, the number of decimal points increases.
Select "Cells" from the "Format" menu. A new window will appear with a wide variety
For example, if we wanted to set the percentages fixed to only two decimal points, you can
make this selection under the "Number "category within the "Number"tab. You can also set the
formatting for things such as the date, time, currently, etc.
Rows and Columns
A worksheet is made up of rows and columns and 65,536 rows. Row numbering in Excel
is straightforward. The first row is called row 1,the second row is called row 2, and the fifth row
is called row 5 and so on. The first 26 Columns are referred to by letters A through Z. the 27th
Column is called AA,
Cell and cell address
The area formed by the intersection of a row and column is called a cell. The cell is the
smallest unit in the worksheet that is used to store data. The column letter followed by the row
number forms the cell's address. For Eg: A1 is the cell address of the upper left cell. Cells can
contain text, numbers, or formulas to refer to a particular cell, you call it by its column letter, and
then by its row letter. For example, the cell in the uppermost left comer would be "A1." The
current cell(s) will always be listed in the "Name Box,"which appears on the left below the
toolbars.
Active cell
In the worksheet there is a thick border around one of the cell.
Range
In Excel, a range is any rectangular area in the worksheet. A range may include just a single
cell, a number of consecutive cells in a row or column, or cells from consecutive rows and
columns. In Excel, a range is defined by specifying its first and the last cell. For example A1:A5
or A1.A5
Insert Rows & Columns:
You may find that you need to insert a new, blank row where there isn't a blank row any more.
To insert a new blank row, place your cursor directly below where you would like a new row.
Select Insert >>Rows. To insert a new column, place the cursor in a cell directly to the right of
where you would like the column. Select Insert >>Columns.
Cell Formatting:
You may notice that, by default, Excel will leave as many decimal points as possible within the
cell's width restraints., as you increase the cell's width, the number of decimal points increases.
Select "Cells" from the "Format" menu. A new window will appear with a wide variety
For example, if we wanted to set the percentages fixed to only two decimal points, you can
make this selection under the "Number "category within the "Number"tab. You can also set the
formatting for things such as the date, time, currently, etc.
