Microsoft Office Tutorials and References
In Depth Information
Undoing previous actions
The options on the shortcut menu are as follows:
Move Here
Moves the source cells to the selected destination
Copy Here
Copies the source cells to the selected destination
Copy Here As Values Only Copies the visible values from the source cells to the
selected destination cells but does not copy formulas
Copy Here As Formats Only Copies the formats of the source cells to the
destination cells without affecting the contents
Link Here
Creates linking formulas at the destination that refer to the source cells
Create Hyperlink Here
Creates a web-style link to the source cells in the selected
destination
The Shift options Lets you copy or move the source cells to a location that
contains existing data, shifting it out of the way in the selected direction
Undoing previous actions
The word undo was never widely used until people started using computers; now it’s a verb
that we all wish we could apply to more things in life. In Excel, you can click the Undo
button, located on the Quick Access Toolbar, or press Ctrl+Z to recover from mistakes.
The Undo button includes a drop-down list of up to the last 100 actions you performed.
You can then select and simultaneously undo any number of these actions at once. You
display the drop-down list by clicking the small downward-pointing arrow next to the Undo
button, as shown in Figure 8-18.
Figure 8-18 Click the arrow next to the Undo button to select and simultaneously undo up to
the last 100 actions.
Search JabSto ::




Custom Search