3-11: Print Excel Cell Comments at the End of, or Within a Worksheet
This lesson will show you how to print one or more Excel Cell Comments (Excel Cell Notes) at the end of, or within a worksheet. *IMPORTANT* If you are an Excel 365 user, Microsoft have now renamed the comment feature to "Notes" The feature is otherwise unchanged but when you hear "Comment" in the video, pretend I have said "Note".
The lesson will also teach you how to use Excel's Dialog Launcher buttons. Dialog Launchers are the gateway to Excel's more advanced features that are not available directly from the Ribbon.
As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson.
⌚ Timestamps
0:00 Sample file download instructions, download link, and discussion of sample file.
0:12 Description of the problem that this lesson will solve.
0:30 Dialog Launcher explained.
0:50 Launch the Page Setup dialog using the Dialog Launcher button.
1:15 Use the Page Setup dialog to set the "Print Comments at end of sheet" option.
1:31 Preview the printout to confirm that the comments are printing out as required.
2:13 Use the Print Preview Zoom In feature to see the printout more clearly.
2:40 Select a single comment to show all of the time within the body of the worksheet.
3:07 Move the comment into a suitable position within the worksheet body.
3:20 Use the dialog launcher to access Page Setup advanced options.
3:40 Use the Page Setup dialog to set comments to print as "displayed on sheet".
4:00 Preview the printout to confirm that the comments are printing out as required.
4:16 Tidy up the workbook and save.
4:44 Link to next lesson, course session playlist and to download sample file set.