Printing comments in Excel 2019 is a simple yet often overlooked feature. By following just a few steps, you can ensure that your printed spreadsheet includes all the necessary annotations and insights provided in the comments. This quick guide will show you how to do that effectively.
Step by Step Tutorial on How to Print Comments in Excel 2019
Before diving into the steps, let’s understand what we’re aiming to achieve. Printing comments in Excel 2019 involves adjusting print settings to include comments either at the end of the sheet or as they appear on the document. Let’s get started.
Step 1: Open the Excel Document
Open the Excel document that contains the comments you wish to print.
Opening the Excel document is the first step to any Excel task. Make sure you’re working on the correct file to avoid any confusion.
Step 2: Click on the ‘File’ Tab
Navigate to the ‘File’ tab on the Excel ribbon at the top of the page.
The ‘File’ tab is where you’ll find most of the document-related commands, including print and export options.
Step 3: Select ‘Print’
Under the ‘File’ tab, click on ‘Print’ or press ‘Ctrl + P’ on your keyboard to open the print settings.
The print settings window is where you can adjust various options to customize how your document will be printed.
Step 4: Click on ‘Page Setup’
In the print settings window, look for the ‘Page Setup’ link at the bottom and click on it.
‘Page Setup’ is where you can fine-tune the printing options and set up how comments should be printed.
Step 5: Go to the ‘Sheet’ Tab
In the ‘Page Setup’ dialog box, navigate to the ‘Sheet’ tab.
The ‘Sheet’ tab within the ‘Page Setup’ holds the settings related to the actual content of your sheet, including comments.
Step 6: Choose How to Print Comments
Under the ‘Comments’ section, choose whether to print comments ‘As displayed on sheet’ or ‘At end of sheet.’
Selecting ‘As displayed on sheet’ will print the comments right next to the cells they’re attached to, while ‘At end of sheet’ will list all comments sequentially at the end of your printed document.
After completing these steps, your Excel comments should be printed as per your selected settings.
Tips for Printing Comments in Excel 2019
- Ensure your comments are properly formatted before printing for better clarity.
- Preview your document before printing to check how the comments will appear on the page.
- If printing comments ‘At end of sheet,’ consider adding page numbers for easy cross-referencing.
- Remember that comments with lengthy text might be truncated when printed ‘As displayed on sheet.’
- Use the ‘Print Titles’ feature in ‘Page Setup’ to repeat headers and make navigation easier when comments are printed at the end of the sheet.
Frequently Asked Questions
Can I print comments in color?
Yes, comments can be printed in color if your printer supports color printing.
What if my comments are hidden in Excel?
Even if comments are hidden, they will still be printed if you follow the above steps to include them.
Can I print comments only without the rest of the sheet?
No, Excel does not support printing comments exclusively. They are printed as part of the sheet.
What should I do if my comments are cut off when printed?
Try adjusting the print settings or the format of the comment to ensure all text is visible upon printing.
Is this process different for Excel 2016 or earlier versions?
The process might slightly differ for earlier versions of Excel, but the ‘Page Setup’ options generally remain the same.
Summary
- Open the Excel Document
- Click on the ‘File’ Tab
- Select ‘Print’
- Click on ‘Page Setup’
- Go to the ‘Sheet’ Tab
- Choose How to Print Comments
Conclusion
Printing comments in Excel 2019 may seem like a no-brainer, but it’s a feature often underutilized. Whether you’re a student compiling feedback, a project manager consolidating team input, or an analyst noting down data insights, being able to print comments can significantly streamline the review and reporting process. It ensures that all the vital information and discussions are captured in the physical copy of your document for easier reference. What’s more, with customizable settings, you can tailor how comments appear on your printed sheets to best suit your needs. So the next time you hit ‘Print,’ take a moment to ensure your comments are included – it might just save you from overlooking those valuable notations.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.