Inserting and Deleting Cells
Similarly, it is also possible to insert cells in your spreadsheet, instead of an entire row or a column. For example, if you want to add a new student as Roll No. 3, you will have to add a block of cells in the range B5:H5.
To insert new cells,
1. Select the range B5:H5.
2. On the menu bar, select Insert > Cells.
The Insert dialog box will appear.
3. Choose the option “Shift cells down”.
4. Click Ok.
The selected cells will move down and a new block of blank cells will appear in their place.
To delete cells
1. Select the range of cells B5:H5 that you have just inserted.
2. On the menu bar, select Edit > Delete .
The Delete dialog box will appear.
3. Select the option “Shift cells up”.
4. Click Ok.
To move cells
1. Select the cells to be moved.
2. Point to any edge of the cells.
3. Drag the cells to the desired location.
Warning: Moving cells over cells that contain data will erase the data.
To copy cells
Copying adjacent cells
1. Click on the cell to be copied.
2. Point to the lower right-hand corner of the cell. When your mouse pointer is on the little box, the pointer turns into a cross.
3. Click and drag down or over as far as you want the cell copied.
Copying non-adjacent cells:
1. Select the cell or cells to be copied.
2. Click on the Copy tool or pull down the Edit menu and choose Copy
3. Position the cursor in the cell to be copied to.
4. Click on the Paste tool or pull down the Edit menu and choose Paste.
