Excel can i print comments

The comments can be printed only at the end of the spreadsheet. You cannot print comments without notes. So, if you want to print only comments, remove all notes before printing comments. Click the worksheet that contains the comments that you want to print.

In the Page Setup dialog box, on the Sheet tab, in the Comments and notes dropdown list, select At end of sheet :.

See also this tip in French: Comment imprimer des commentaires dans Excel. If you encountered a bug or want to suggest a feature in Microsoft Office, we recommend you contact Microsoft Support. After entry I summarize it on other place. Summarized data is linked with the entry. I have to manually copy the data in summary sheet and then pasting it as values so as to freeze. I wanted to automate this action using macro. Please guide me………appreciates your hep.

I meant a sample file where you need help. I got you right but i am not able to attach. Only image file is allowed. Hope this may clear my concern. Select the worksheet that contains the notes that you want to print, then do one of the following:. To move or resize any overlapping notes, click the border of the note box so that its sizing handles appear.

You can resize the note by dragging any of its sizing handles, or move it by selecting any part of its border, then drag it where you want. In the Comments box, click As displayed on sheet legacy. Note: In Excel for Microsoft , you can't print just notes at the end of the sheet. However, you can print both threaded comments and notes at the end of the sheet. See the previous section on printing threaded comments and notes in Excel for Microsoft Click Print , or Print Preview to see a preview of the notes.

To move or resize any overlapping comments, right-click and select Edit Comment , and the border of the comment box will display sizing handles. You can resize a comment 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 threaded comments as they're displayed on a sheet.

But you can print notes as they're displayed on a sheet. 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. Excel comments work perfectly if you need to add a note to remind somebody about the changes you made. This feature also streamlines work if you want to provide additional information without modifying your worksheet data.

If cell notes is a vital part of your Excel documents then printing comments along with other data may be one of your day-to-day tasks. This can make handouts more informative and add helpful information to the daily reports for your boss. It's possible to print comments at the end of your Excel worksheet or display them all and copy to paper exactly as they appear in your table, next to the cells they relate to.

If notes in your Excel table are informative and their contents are clear even isolated from the commented cell, you can easily get them to paper at the end of the page. It's also better to print cell notes below the rest of the data if they overlap important details when displayed.