Edit Menu -Easy Excel

Sheet tab

1.    Insert = this option insert a new sheet into the workbook. It will insert new sheet left side of the current sheet.

2.    Delete = this option delete the current sheet. If sheet contains data then it will display a massage that data may exist on the sheet.

3.    Rename =  this option is used to rename the current  sheet

4.    Move or copy sheet = To Transfer (Move or Copy) your current worksheet in same workbook or outside the other open workbook. This option is used to move or copy the current sheet within a workbook or outside the workbook.

5.    Select all sheets = this option is used to select all the sheets of a workbook. It works as carbon copy. To select all the sheets in workbook at a time. This will work like a carbon copy if you enter data in any cell while selections, then all selected sheets same cell address will be filled with the data, at the same cell address position. If previous data is written on any sheet then that data will be over written by the new data and previous data will be lost.

6.    Tab color = this option is used to change the color of the sheets tabs. 

Edit menu

Fill = this option fill the same selected cell data to down left right and up cells. which is selected.

Across Worksheets

                                                                                                                                                                                                                                                                                                                             Copies the contents of the range of cells selected on the active worksheet to the same range of cells on all the other selected sheets in a group. This command is available only if multiple sheets are selected.

Fill – series

1.    Liner = add to the numbers

2.    Growth = multiply to the numbers

3.    Date = increment the days/months/ and year.

4.    Auto fill = automatically fill to the data

5.    Step value = how much value you want to increment

6.    Stop value = last maximum value, no matter if extra cells are selected.

Fill – justified = To fill sentence of cell into row wise.

Delete sheet = This option delete the current sheet. It will display a massage if sheet contain data value.

Paste special è this command help us to paste the data in various form . it paste the data in :

1.           formula

2.           value

3.           all è paste all the options

4.           comments

5.           formats

6.           validation

7.           column width

it also help in performing operation with the cell  like add , subtract.

For adding the value with the formula select the formula cell and copy it . type  any value in another cell then click at paste special option and select add . it will the add the value of cell with the the cell in formula . we can also create the link with any cell by clicking at paste link  option.