Microsoft KB Archive/110075

= Copying Tracer Arrows Gives Inconsistent Results =

Article ID: 110075

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0c

-



This article was previously published under Q110075



This article also applies to:
 * Microsoft Excel for Windows 5.0|5.0



SYMPTOMS
In Microsoft Excel, when you use the Copy Picture command to copy cells on a worksheet, and you select the Picture option, the tracer arrows are not copied. However, when you use the Copy Picture command to copy cells on a worksheet, and you select the Bitmap option, tracer arrows are copied.



WORKAROUND
If you want the tracer arrows to appear when you copy and paste cells on a worksheet, do the following:


 * 1) Select the range containing the tracer arrows.
 * 2) Press and hold down the SHIFT key, and choose Copy Picture from the Edit menu.
 * 3) Under Appearance, select the As Shown On Screen option, and under Format, select the Bitmap option. Choose OK.
 * 4) Select the cell you want to paste the picture to, and choose Paste from the Edit menu.

If you do not want the tracer arrows to appear when you copy and paste cells on a worksheet, do the following:


 * 1) Select the range containing the tracer arrows.
 * 2) Press and hold down the SHIFT key, and choose Copy Picture from the Edit menu.
 * 3) Under Appearance, select the As Shown On Screen option, and under Format, select the Picture option. Choose OK.
 * 4) Select the cell you want to paste the picture to, and choose Paste from the Edit menu.



MORE INFORMATION
You can use the Auditing command on the Tools menu to trace precedents, dependents, and errors related to any cell on your worksheet. The Tracer commands cause Microsoft Excel to draw arrows from the active cell to its precedents, its dependents, or to the possible source of an error value in the active cell. Tracer arrows aren't saved when you close the workbook. Tracer arrows are special "objects" that you can edit or manipulate in limited ways.

