Cell Paste Special
In edit menu this option provides the facility to paste all, formula, formats or values, which have been copied or cut. It also gives the facility to paste as transpose i.e. row and column data interchange to be pasted in column and row instead of row and column.
Merge Cells
Cells in Excel can be merged so that they span on more than one row and column. Steps to merge cells are given below
- Select the cells we want to merge
- To merge cells in a row and center the cell contents, click Merge and Center on the Formatting toolbar
To merge any selection of cells within a row or column, click Cells on the Format menu, click the Alignment tab, and then select the Merge cells check box
Inserting cells
Insert blank cells
- Select a range of existing cells where we want to insert the new blank cells. Select the same number of cells, as we want to insert
- On the Insert menu, click Cells
- Click Shift cells right or Shift cells down
Insert rows
- To insert a single row, click a cell in the row immediately below where we want the new row. For example, to insert a new row above Row 5, click a cell in Row 5
- To insert multiple rows, select rows immediately below where we want the new rows. Select the same number of rows, as we want to insert
- On the Insert menu, click Rows
Insert columns
- To insert a single column, click a cell in the column immediately to the right of where we want to insert the new column. For example, to insert a new column to the left of Column B, click a cell in Column B
- To insert multiple columns, select columns immediately to the right of where we want to insert the new columns. Select the same number of columns, as we want to insert
- On the Insert menu, click Columns
Insert moved or copied cells between existing cells
- Select the cells that contain the data we want to move or copy.
- To move the selection, click Cut. To copy the selection, click Copy.
- Select the upper-left cell where we want to place the cut or copied cells.
- On the Insert menu, click Cut Cells or Copied Cells.
- Click the direction we want to shift the surrounding cells.
Delete cells, rows, or columns
Following steps have to be taken
- Select the cells, rows, or columns you want to delete
- On the Edit menu, click Delete
- Surrounding cells shift to fill the space
Clearing cells
This process requires following steps
- Select the cells, rows, or columns we want to clear
- On the Edit menu, point to Clear, and then click All, Contents, Formats, or CommentsFurther, if we click a cell and then press DELETE or BACKSPACE, Microsoft Excel removes the cell contents but does not remove any comments or cell formats. If we clear a cell, Microsoft Excel removes the contents, formats, comments, or all three from a cell. The value of a cleared cell is 0 (zero), and a formula that refers to that cell will receive a value of 0.
Find, Replace and go to
Unlike MS-Word, Ms-EXCEL has different dialog boxes for go to and a combined for find and replace.
Operation | Keyboard shortcut | Edit menu option |
Find | Control key then, F key | Find |
Replace | Control key then, H key | Replace |
Go To | Control key then, G key | Go To |