Editting and Edit menu in Microsoft Excel 2003

File Edit View Insert Format Tools Data Window
- Introduction - - Parts of Microsoft Excel Window - - Functions used in Microsoft Excel - - Custom List - - Goal Seek - - Error Checking - - Groupping/Ungroupping cells - - Forms - - Data Validation - - Filters - - Sorting - - Freeze Panes -
Discussed Earlier (Word)

Undo - to cancel last action
Redo - to cancel last undo
Cut - to cut the cell contents , to move to the other location
Copy - to copy the cell contents
Paste - paste the copied cell contents
Clear - to clear the cell contents
Find - to find the information
Replace - to change the cell information with another
Goto - to goto to the specific location

Additional in MS Excel

How to move and copy the sheet?
You can move and copy the sheets from one opened workbook another.
-Edit - Move or Copy
-Select the name of the Workbook in which you want to move or copy for ‘to book’ list box.
-If you want to only move then just click on the OK. But if you want to make copy of that book then click on the ‘ Create Copy’ check box.

What is Fill command?
This command is used to copy the contents of the cell in remaining blank cells.
-Select the cells with the blank cells.
-Edit - Fill
-Select any of the options right left up down.

What is delete option?
This option is used to delete the cells, rows and columns.
-Click in the cell.
-Edit - Delete
-A delete box will be displayed with following options-
Shift Cell up – to shift the below cell up to take its position.
Shift Cell left – to shift the left cell to take its position.
Entire row – to delete the whole row.
Entire Column – to delete the whole column.
What is delete sheet?
This option is used to delete the sheet.
-Edit - delete Sheet
Related Posts Plugin for WordPress, Blogger...