Microsoft KB Archive/181322

= XL98: Unexpected Results Printing Comments as Displayed =

Article ID: 181322

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q181322



SYMPTOMS
When you print a worksheet in Microsoft Excel 98 Macintosh Edition that has comments, the comments may not be printed as you expect.



CAUSE
This behavior may occur if the following conditions are true:
 * The comments are placed on or near a page break. -and-


 * You select As Displayed On Sheet in the Comments box in the Page Setup dialog box (click Page Setup on the File menu).



MORE INFORMATION
Comments in Microsoft Excel 98 are drawing objects like rectangles and text boxes. When you select As Displayed On Sheet, comments are printed where they are placed, regardless of the location of the cell that contains the comment. You may see similar behavior with other drawing objects that are on or near a page break. In Microsoft Excel 98, objects are not confined to column widths; so page break boundaries may be different for objects compared to boundaries for text.

NOTE: The printed results may vary slightly depending on the printer driver you are using.

Example
To see an example of this behavior, follow these steps:

 Type the following information into a worksheet:

A1: 100 B1: 100 C1: 100 D1: 100

A2: 200 B2: 200 C2: 200 D2: 200

A3: 300 B3: 300 C3: 300 D3: 300

A4: 400 B4: 400 C4: 400 D4: 400

A5: 500 B5: 500 C5: 500 D5: 500

A6: 600 B6: 600 C6: 600 D6: 600

A7: 700 B7: 700 C7: 700 D7: 700

A8: 800 B8: 800 C8: 800 D8: 800

A9: 900 B9: 900 C9: 900 D9: 900

 Select cell E1. On the Insert menu, click Page Break. Hold down the CONTROL key and select cell D1. On the shortcut menu, click Insert Comment. Type This is a test . Hold down the CONTROL key and select cell D1. Click Show Comment. Hold down the CONTROL key and click cell D4. Click Insert Comment on the shortcut menu. Type This is a test . Hold down the CONTROL key and select cell D4. Click Show Comment.</li> Click the comment to select it. Drag it to cell D6 and position it so that half the comment is over column D and half the comment is over column E.</li> Hold down the CONTROL key and click cell B4. Click Insert Comment on the shortcut menu. Type This is a test .</li> Hold down the CONTROL key and click cell B4. Click Show Comment on the shortcut menu.</li> Click the comment to select it. Drag it to cell D10 and position it so that one fourth of the comment is over column D and the rest of the comment is over column E.</li> On the File menu, click Page Setup. Click the Sheet tab.</li> In the Print section, locate the Comments box. Select As Displayed On Sheet, and then click OK.</li> On the File menu, click Print Preview. Note where the comments are printed on each page.</li></ol>

Notice that some comments are printed on page one even though they may cross the page break on the screen. Other comments are partially printed on page two.

Additional query words: XL98

Keywords: kbprint kbprb KB181322

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.