many a time you may require to add a row of data or a coloumn of data which you forgot to enter earlier .excel proveides you the facility to insert rows or columns onto the sxisting worksheet very easily .it is that inserting a row of data will shift the rest of the rows down and cause the ladt row of the worksheet ,the rest of the columns shift right ,if there is any data in the last row or column of the worksheet that will be lost .
Click on the row header or column header. Press Ctrl-Spacebar to select a column. Press Shift-Spacebar to select a row. If you have cells in more than one column or row selected when you do either of these it will select all of the columns or rows that have selected cells. If you go to the first cell in a completely blank row and press Ctrl-Shift right arrow, it will select the entire row. If you go to the first cell in a completely blank column and press Ctrl-Shift down arrow, it will select the entire column. If there is some data in any cells in the row/column or if you are not in the first cell when you do it, these commands will select part of the row/column only, depending on where data is.
The top row of a table is called the header row. It typically contains column labels or headings that describe the data in each column below it.
It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.
Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.
A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.
For single cells, just click on the cell. For a column, click on the column header or press Ctrl and the spacebar. For a row click on the row header or press Shift and the Spacebar. For a range, click on the first cell and hold the left mouse button and drag across, or press shift and use the cursor keys to drag across. For the entire sheet, click on the box above row header 1 and left of column header A, or press the Ctrl and Spacebar followed by pressing the Shift and Spacebar.
A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.
header row
A cell is a box created by the meeting of a column and a row. The cell addresses are taken from the letters of their columns and numbers of their rows. So the cell in Column D and Row 5 is cell D5. The status bar appears near the bottom of the screen and gives various information about the spreadsheet at that time.A cell is a box created by the meeting of a column and a row. The cell addresses are taken from the letters of their columns and numbers of their rows. So the cell in Column D and Row 5 is cell D5. The status bar appears near the bottom of the screen and gives various information about the spreadsheet at that time.A cell is a box created by the meeting of a column and a row. The cell addresses are taken from the letters of their columns and numbers of their rows. So the cell in Column D and Row 5 is cell D5. The status bar appears near the bottom of the screen and gives various information about the spreadsheet at that time.A cell is a box created by the meeting of a column and a row. The cell addresses are taken from the letters of their columns and numbers of their rows. So the cell in Column D and Row 5 is cell D5. The status bar appears near the bottom of the screen and gives various information about the spreadsheet at that time.A cell is a box created by the meeting of a column and a row. The cell addresses are taken from the letters of their columns and numbers of their rows. So the cell in Column D and Row 5 is cell D5. The status bar appears near the bottom of the screen and gives various information about the spreadsheet at that time.A cell is a box created by the meeting of a column and a row. The cell addresses are taken from the letters of their columns and numbers of their rows. So the cell in Column D and Row 5 is cell D5. The status bar appears near the bottom of the screen and gives various information about the spreadsheet at that time.A cell is a box created by the meeting of a column and a row. The cell addresses are taken from the letters of their columns and numbers of their rows. So the cell in Column D and Row 5 is cell D5. The status bar appears near the bottom of the screen and gives various information about the spreadsheet at that time.A cell is a box created by the meeting of a column and a row. The cell addresses are taken from the letters of their columns and numbers of their rows. So the cell in Column D and Row 5 is cell D5. The status bar appears near the bottom of the screen and gives various information about the spreadsheet at that time.A cell is a box created by the meeting of a column and a row. The cell addresses are taken from the letters of their columns and numbers of their rows. So the cell in Column D and Row 5 is cell D5. The status bar appears near the bottom of the screen and gives various information about the spreadsheet at that time.A cell is a box created by the meeting of a column and a row. The cell addresses are taken from the letters of their columns and numbers of their rows. So the cell in Column D and Row 5 is cell D5. The status bar appears near the bottom of the screen and gives various information about the spreadsheet at that time.A cell is a box created by the meeting of a column and a row. The cell addresses are taken from the letters of their columns and numbers of their rows. So the cell in Column D and Row 5 is cell D5. The status bar appears near the bottom of the screen and gives various information about the spreadsheet at that time.
In Excel, as well as most other spreadsheet applications, a row is a grouping of cells that run from the left to right of a page and a column is a grouping of cells that run from the top to the bottom of a page. Rows run horizontally in an Excel worksheet. They are identified by a number in the row header. There are 65,536 rows in each Excel worksheet. The intersection point between a row and a column is a cell, which is the basic storage unit for data in a spreadsheet.
Clicking on the header of the row or column will select it. So for example, to select row 3, click on the 3 at the start of it or to select column R, click on the R at the top of it. Pressing Ctrl and the spacebar will select the current column. Shift and spacebar will select the current row.