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.
No comments:
Post a Comment