Page 106 - Excel Timesaving Techniques for Dummies

20_574272 ch17.qxd 10/1/04 10:41 PM Page 91
4. Choose Edit➪Paste Special to open the Paste Cutting and Pasting Formats Only 91
Special dialog box.

Be sure you don’t choose Edit➪Paste instead
of Edit➪Paste Special. Otherwise, Excel will
plunk down not only the formatting but the
contents of the cells as well. And if you’re past-
ing into a cell range with entries, these entries
will be replaced. If you mess up, press Ctrl+Z
until you put everything right in the range.

5. Click the Formats option button in the Paste
area of the Paste Special dialog box (shown in
Figure 17-6) and then click OK button.

Excel closes the Paste Special dialog box and imme-
diately applies all the formatting applied to the origi- • Figure 17-6: Using the Formats option in the Paste Special
dialog box to paste only the formatting on
nal cell or cell range and copied to the Clipboard
the Clipboard.
to the cell range that’s currently selected in the
worksheet.