Microsoft Office Tutorials and References
In Depth Information
Excel Copy and Paste options
Many applications (including the Microsoft Office apps) also have an
Edit
Paste Special command. This command displays a dialog box
providing some options that determine how the information is pasted. This topic,
as it relates to sharing information between applications, is explained later
in this chapter.
Excel Copy and Paste options
If you’re working with Excel, you’ll want to keep these additional copy and paste
options in mind:
After you copy a cell or range, you can move the cell pointer to a
different cell and press Enter. This pastes the copied range as well as clears the
Clipboard.
You can use the Edit
Paste Special command to specify additional options
for the pasted information. For example, you can use this command to
convert formulas to values, or to copy the formatting from one chart to
another chart.
Copy
command. To access this command, you must press Shift when you click
the Edit menu. This command, which copies the selection as a picture ,
displays the Copy Picture dialog box, which presents some options.
You can use the Edit
Copy Picture command rather than the Edit
You can use the Edit
Paste
command. To access this command, you must press Shift when you click
the Edit menu. This command pastes a picture of the original selection.
Paste Picture command rather than the Edit
When copying a cell or range, you can use the Edit
Paste Picture Link
command rather than the Edit
Paste command. To access this command,
you must press Shift when you click the Edit menu. This command pastes
a linked picture of the original range (if you modify the copied range, the
link picture reflects those changes).
The Copy Picture dialog box
In some cases, you may want to copy a chart as a picture: Activate the chart, press
Shift, and choose Edit
Copy Picture. The Copy Picture dialog box pops up with
some potentially confusing choices (see Figure 10-1), described next.
Appearance: This option (supposedly) affects the appearance of the chart.
But it’s not at all clear what this option really does. The online help is
no help.
Search JabSto ::




Custom Search