Copying and moving the data
For copying the data the following is the command:
Click Edit
Then select copy
command
For pasting the document
Click Edit
Then paste command.
For cutting the document the same is the rule but the difference is that you will have to select the cut command from the Edit menu.
N.B. Before pasting the document, you will have to select the area i.e. insertion point to be placed there.
Keystrokes:
For copy : Ctrl+C
For paste: Ctrl+V
For cut: Ctrl+X
Find and Replace
command
For pasting the document
Click Edit
Then paste command.
For cutting the document the same is the rule but the difference is that you will have to select the cut command from the Edit menu.
N.B. Before pasting the document, you will have to select the area i.e. insertion point to be placed there.
Keystrokes:
For copy : Ctrl+C
For paste: Ctrl+V
For cut: Ctrl+X
Find and Replace
You can find any document by selecting Find command from the Edit menu and you can replace it from the same menu. This command is helpful for updating the document you prepared. A list of texts may be replaced by using this command.
Shortcut keys:
Ctrl+F for finding the document and for replacing the document you can press by using the keystroke Ctrl+H
Fill command:
You can fill a list of items by selecting the cell from the edit menu. You can fill the text to the right, left, down, AutoFill and according to series in different forms like linear and growth types. This command is helpful for updating the document.
Keystrokes:
For fill the document you can select the keystrokes: Ctrl +D
Clear the documents
If you feel difficult to delete the text, if the text area is
formatted by Pivot table or any graphic objects like object linking and embedding ( OLE) or any complicate arises; you can delete the formatted text by using Clear command. In clear command, you will find contents, format and all.
Contents: specifies the text as selected
Format: Removes all formatted text, graphics/charts and number.
All: removes all the contents in the text area
You can find any document by selecting Find command from the Edit menu and you can replace it from the same menu. This command is helpful for updating the document you prepared. A list of texts may be replaced by using this command.
Shortcut keys:
Ctrl+F for finding the document and for replacing the document you can press by using the keystroke Ctrl+H
Fill command:
You can fill a list of items by selecting the cell from the edit menu. You can fill the text to the right, left, down, AutoFill and according to series in different forms like linear and growth types. This command is helpful for updating the document.
Keystrokes:
For fill the document you can select the keystrokes: Ctrl +D
Clear the documents
If you feel difficult to delete the text, if the text area is formatted by Pivot table or any graphic objects like object linking and embedding ( OLE) or any complicate arises; you can delete the formatted text by using Clear command. In clear command, you will find contents, format and all.
Contents: specifies the text as selected
Format: Removes all formatted text, graphics/charts and number.
All: removes all the contents in the text area
In Microsoft Excel, Copying and moving data are vitally important. In order to increase the quality of the document, such techniques is significant. In order to display the outlook of the document, such command is useful.