How To Print Comments In Excel: The Complete Professional Guide
Printing comments in Excel requires adjusting specific Page Layout settings because the application hides these annotations by default to prioritize spreadsheet aesthetics. By modifying the Page Setup dialogue box, you can force Excel to render notes either at the end of the worksheet as a sequential list or in their original screen positions to ensure data integrity during review.
Pre-Print Configuration and Document Readiness
Before attempting to send your workbook to a physical printer or PDF generator, you must ensure your data environment is primed for metadata extraction. Excel manages comments as floating objects rather than cell content, meaning they do not naturally align with the grid layout. Preparing your file prevents distorted output or missing annotation text that often results from standard printing commands.
- Required Software Version: Microsoft Excel 2013, 2016, 2019, 2021, or Microsoft 365.
- Hardware Prerequisites: Any standard laser or inkjet printer capable of handling document rendering, or a virtual PDF writer such as Microsoft Print to PDF.
- Knowledge Standards: Basic understanding of Page Layout tabs and Page Setup dialogue parameters.
- Temporal Benchmark: Execution time is typically under 90 seconds per document depending on the volume of comments.
- Output Standards: Ensure that all comments are set to Always Show if you intend to print them in their relative screen positions, as hidden notes will not appear in the final hard copy.
Mastering the Workflow for Printing Excel Comments
Step 1: Making Comments Visible
If your goal is to print comments exactly where they appear on your screen, you must first change their display status from context-sensitive to persistent. Navigate to the Review tab in the main ribbon. Locate the Comments group and select the Show All Comments button. This command forces every annotation object to remain visible on the canvas, which is a mandatory prerequisite for the "As displayed on sheet" printing option.
Pro-Tip: If your sheet contains excessive overlapping comments, use the Show/Hide Comment command on individual items to declutter the workspace before finalizing the print view, as Excel will print the current display state of these objects.
Step 2: Accessing Page Setup
Navigate to the Page Layout tab on the ribbon. In the lower-right corner of the Page Setup group, click the small dialogue box launcher icon—a small arrow pointing downward. This action opens the comprehensive Page Setup window, which provides granular control over print margins, headers, footers, and sheet-specific elements that are not accessible from the standard File-Print menu.
Step 3: Configuring the Sheet Tab Settings
Within the Page Setup dialogue window, select the Sheet tab. You will see a dropdown menu labeled Comments. Clicking this will provide three distinct options: None, At end of sheet, and As displayed on sheet. Select your preferred output format. Selecting At end of sheet creates a secondary page appended to your document that lists the cell reference alongside the corresponding comment text, while As displayed on sheet captures the visual layout of the spreadsheet.
Step 4: Verifying Through Print Preview
Never proceed directly to a physical print job without checking the Print Preview pane. Navigate to File and select Print. Observe the preview window carefully. If you chose the end-of-sheet option, scroll to the final pages to verify the text formatting. If you chose to print as displayed, ensure that comment boxes do not obscure critical cell data, as the print output will replicate the exact visual blockage seen in the preview.
Get Perfect Excel Printouts With These Simple Settings | Flipboard
Comparative Analysis of Comment Printing Methodologies
| Method | Best Use Case | Impact on Document Length | Metadata Visibility |
|---|---|---|---|
| None | Standard data distribution | Minimal impact | No comments visible |
| At end of sheet | Formal audits and compliance | Significant length increase | Highly organized summary |
| As displayed | Visual presentations/Reviews | Dependent on layout | High visual contextualization |
Common Print Failures and Field Remedies
Root Cause: Comments are invisible in the final printout despite selecting As displayed on sheet.
- Actionable Fix: Ensure that the specific comments were not hidden before initiating the Page Setup process. Return to the Review tab, click Show All Comments, and re-verify the settings in the Page Setup dialogue.
Root Cause: The text inside the comment boxes appears clipped or truncated in the print preview.
- Actionable Fix: Excel does not automatically resize comment boxes to fit all text for printing. Manually adjust the sizing handles of the problematic comment boxes in the main editing window until the text is fully contained before returning to the print menu.
Root Cause: Overlapping comments creating a jumbled or illegible printed output.
- Actionable Fix: Use the drag-and-drop handles on the comment boxes to reposition them away from one another. Since the print engine captures the current screen placement, manual decluttering is required for a professional-grade document.
Root Cause: Print job exceeds intended page count due to end-of-sheet comment lists.
- Actionable Fix: If you only require specific comments, consider deleting unnecessary ones or moving them to a separate worksheet to isolate the print range, or manually edit the print area in the Page Layout tab to exclude the comment summary pages.
Frequently Asked Questions
Why do my comments print on a separate page?
This occurs when you select the At end of sheet option in the Page Setup menu. Excel treats these annotations as supplementary metadata and generates a report-style summary of all comments following the main dataset to ensure the readability of your primary spreadsheet grid.
Can I choose to print only a few specific comments?
Excel's native printing function applies to all visible comments on a sheet. To print only specific items, you must hide the others, move the desired comments to a separate testing sheet, or utilize a VBA macro script to extract specific comments into a document format.
How do I prevent comments from overlapping during printing?
You must manually arrange the comment boxes on the spreadsheet screen before executing the print command. Excel honors the specific X and Y coordinates you set for each comment object, so dragging them into a non-overlapping configuration is the only way to ensure they appear clearly on the printed page.
Does changing the print settings for comments affect the workbook permanently?
No, these settings are linked to the Page Setup profile for that specific worksheet. Once you close the workbook or revert the print settings, the standard spreadsheet functionality remains unchanged, though the manually repositioned comment boxes will stay in their new locations until moved again.
Streamline your documentation workflow by applying these professional print protocols to your next financial or data-heavy reporting task. Master your Excel environment today to ensure every stakeholder has access to your critical hidden insights.