Forum Tutorials Macros. Join over 20, People! Excel Tips in Your Email. Excel Courses. Shopping Cart. Excel Tips and Tutorials. Premium Excel Course Now Available! Instant Access! View Course. Print Comments in Excel. Add to Favorites Favorited. Author: don. How to print the comments in a worksheet when you print from Excel. In the window that opens, go to the Sheet tab and look for the Comments drop down menu on the right.
From that menu, select either At end of sheet , if you want your comments to be printed separate from the spreadsheet and at the very end, or As displayed on sheet if you want them to be printed on the actual worksheet. Once you've made your selection, hit OK. If you chose the option At end of sheet , you are done.
If you chose the option As displayed on sheet , look to step 4. When printing Excel comments as displayed, you can either show all the comments, or just show one or more comments that you want to print. To show a specific comment, select a cell that contains a comment. Instead of printing the Excel comments as displayed, you can print them at the end of the worksheet. If you want to see how the comments will look when printed, click Print Preview. This Excel Quick Tips video shows how to display all the worksheet comments, and then print the worksheet with the comments displayed.
Your email address will not be published. See the next section on printing only notes in Excel for Microsoft for Mac. To move and resize any overlapping notes, right-click and select Edit Note , and the border of the note box will display sizing handles. You can resize a note box by dragging any of its sizing handles, or move it by selecting any of its borders, then drag it where you want. Note: In Excel for Microsoft for Mac, you can't print just notes at the end of a sheet.
However, you can print both threaded comments and notes at the end of a sheet. See the previous section on printing threaded comments and notes in Excel for Microsoft for Mac. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Insert comments and notes in Excel. Select the Sheet tab. Print threaded comments and notes in Excel for Microsoft Select the worksheet that contains the threaded comments and notes that you want to print.
In the Comments box, click At end of sheet. You can print notes the way they appear on the sheet. On the File menu, click Page Setup. Click Print. Print threaded comments and notes in Excel for Office for Mac.
Need more help? Expand your skills. Get new features first. Was this information helpful?
0コメント