To print comments in Excel 2013, open Page Layout, click the small arrow in the Page Setup group, go to the Sheet tab, and set Comments to At end of sheet (a list after your data) or As displayed on sheet (the boxes as they appear on screen). Then print. Office 2013 reached end of support on April 11, 2023. In current Excel, old-style comments are called Notes, and threaded comments print at the end of the sheet.
Quick Answer
Page Layout > Page Setup arrow > Sheet > Comments: At end of sheet > OK > Print.
Steps to Print Comments
- Click the Page Layout tab.
- Click the arrow at the bottom right of Page Setup.
- Open the Sheet tab.
- In Comments, choose At end of sheet or As displayed on sheet.
- Click Print Preview to check, then print.
Which Option to Use
| Option | Result |
|---|---|
| (None) | No comments printed (default) |
| At end of sheet | A page listing each cell reference and its comment |
| As displayed on sheet | Only comments you’ve set to show, in their boxes |
Show Comments Before Printing
For As displayed on sheet, click Review > Show All Comments first and move any boxes that cover data.
Troubleshooting
- Comments don’t print: With As displayed on sheet, hidden comments are skipped. Show them or use At end of sheet.
- Adding comments: See adding a comment in Excel 2013.
- Printing part of a sheet: See printing part of a spreadsheet.
- In Word? See printing comments in Word.
Frequently Asked Questions
Can I print comments without the data?
Use At end of sheet and print only the last page.
Does the setting apply to every sheet?
No. Set it for each worksheet.
What about threaded comments?
In newer Excel, threaded comments print at the end of the sheet; notes follow the options above.
Summary
- Open Page Setup from the Page Layout tab.
- Go to the Sheet tab.
- Choose At end of sheet or As displayed on sheet.
- Preview and print.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.