Excel-2003 Tutorial 6 - Smart Computer Tutorial
Steps:-
1. Design the matter.
2. Apply some Attributes on the selected cell such as color, comment, text style , size etc.
3. Select the cell.
4. Click on “Edit menu.
5. Select “Clear->all” option.
Clear->Format:- This option is used to Clear the applied format on the selected cell or range of cells.
Steps:-
1. Design the matter.
(ads)
2. Apply the formatting such as text, color, size font etc.
3. Select the cell or range of cells.
4. Click on “Edit menu”.
5. Select “Clear->Format” option.
Clear->content:- This option is used to clear only the content of the select cell or range of cells but formatting will as it is.
Steps:-
1. Design the matter.
2. Apply the Attributes on the cell or range of cells such as “font, font style, font color, comment” etc.
3. Select the cell or range of cells.
4. Click on “Edit” menu.
5. Select “Clear->Contents” option.
Note- now if you type any content in the cell it will shows like previous format.
Clear->Comment:- This option is used to clear only the applied comment of the selected cell.
Steps :-
1. Design the matter.
2. Apply the comment in the cell by using insert menu.
3. Select the cell which comment you want to clear.
4. Click on “Edit” menu.
5. Select “Clear->Comments” option.
Delete:- This option is used to delete the selected cell with the selected following radio button.
(ads)
a. Shift cell up:- it will delete the cell and shift the down cell up.
b. Shif cell left:- it will delete the cell shift the right cell left.
c. Entire row:- It will delete the entire row of the selected cell.
d. Entire column:- It will delete the entire column of the selected cell.
Steps-
1. Select the cell.
2. Click on “Edit menu”.
3. Select “Delete” option.
4. Select any radio button.
5. Click on “ok” button.
Edit menu
Delete sheet:- This option is used to delete the active sheet.
Steps:-
1. Select any sheet from sheet tab that is at the below of the window such as sheet 1.
2. Click on “Edit” menu.
3. Select “Delete sheet” option.
Note :- now if you see , sheet one is deleted only sheet 2 and sheet 3 will be available on the sheet tab.
2nd Way:-
1. “Opposite” click on the sheet name .
2. Select “Delete” option.
Note:- you can not delete all sheet you must have at least one sheet visible.
Move or Copy Sheet:- This option is used to move the active sheet before any other sheet or to the end of all sheet.
Process to move the active sheet before any sheet.
(ads)
1. Click on any sheet name which you want to move.
2. Select “Edit->move or copy sheet” option.
3. Select the sheet name .
4. Click on “ok” button.
2nd way:-
1. Right click on the sheet name which you want to move.
2. Select Move or copy option.
3. Click on any sheet name.
4. Click on “ok”.
Process to move the active sheet to the end of the sheet.
1. Click on any sheet name which you want to move.
2. Select “Edit->move or copy sheet” option.
3. Select move to end option .
4. Click on “ok” button.
2nd way:-
1. Right click on the sheet name which you want to move.
2. select Move or copy option.
3. Select move to end option.
4. Click on “ok”.
Process to Copy the active sheet .
Steps:-
1. Click on any sheet name which you want to copy.
2. Click on “Edit” menu.
3. Select “move or copy sheet” option.
4. Select any sheet.
5. Check the check box of “Create a copy”.
6. Click on “ok” button.
2nd way:-
1. Opposite Click on “sheet name”.
2. Click on “move or copy” option.
3. Select any sheet.
4. Check the check box of “Create a copy”.
5. Click on “ok” button.
