Do you need an easy way to transport large files, or are you looking for a simple backup solution? Portable hard drives can solve both of these problems, and they are becoming very affordable. Click here to check out a good 1 TB option.
How to Print Comments in Excel
Part of the issue that arises when you try to print Excel comments is that they appear on the screen, but that there doesn’t seem to be an option anywhere for you to select it as an option to print along with the spreadsheet data. You may have considered taking a screenshot and printing that way, but that is typically a less-than-desirable option. Fortunately the ability to print Excel comments exists within the program, and you can follow the steps below to learn how. Note that you can skip step 2 and step 3 below if you want to print your comments at the end of the sheet. These two steps are only necessary if you want to print the comments as they appear on the sheet. Step 1: Open the spreadsheet containing the comments that you want to print. Step 2: Click the Review tab at the top of the window.
Step 3: Click the Show All Comments option.
Step 4: Click the Page Layout tab at the top of the window.
Step 5: Click the small Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.
Step 6: Click the Sheet tab at the top of the pop-up window.
Step 7: Click the drop-down menu to the right of Comments, then click either the As displayed on sheet option to print them in their spot on the actual spreadsheet, or select the At end of sheet option to print them on a separate page at the end of the printed spreadsheet.
You can then click the Print Preview button to see how your printed document will look. If you need to fit a spreadsheet on one page when you’re printing, this article can help you out. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
