How to print comments in excel

Answer

To print comments in Excel, use the Page Setup dialog to control the print layout for comment display. Excel prints comments in two formats: at the end of the sheet or as displayed on the sheet.

Print Comments on Windows

1. Open the worksheet containing comments.

2. Go to Page Layout on the Ribbon.

3. Select the small launcher arrow in the Page Setup group.

4. Choose the Sheet tab.

5. Go to the Comments dropdown.

6. Choose At end of sheet or As displayed on sheet.

7. Select OK.

8. Go to File > Print and select Print.

Print Comments on Mac

1. Open the worksheet containing comments.

2. Go to Layout from the top menu.

3. Select Page Setup.

4. Open the Sheet tab.

5. Go to the Comments dropdown.

6. Choose At end of sheet or As displayed on sheet.

7. Select OK.

8. Go to File > Print and select Print.

What Does “As Displayed on Sheet” Mean?

“As displayed on the sheet” prints comments exactly where they appear in the worksheet. A visible comment prints next to the cell it refers to.

What Does “At End of Sheet” Mean?

“At the end of the sheet” prints comments on a separate page following the worksheet. Excel lists each comment with its cell reference.

Which Option Produces a Cleaner Print Layout?

“At the end of the sheet” produces a cleaner layout. A worksheet with many comments prints with less clutter because comments stay off the main grid.

Tips for Improving Comment Visibility

1. Increase the size of comment boxes before printing to improve readability.

2. Use clear formatting inside the comment for consistent text spacing.

3. Display all comments by selecting Review > Show All Comments on Windows or Review > Notes > Show All Notes on Mac.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report