print the comments of a sheet in Excel
Q127. I have entered lot of comments in my WorkSheet - how do I have them show up when printed?
For example, in the Simple Interest Calculator below, I have given instructions for user inputs / description of each field. In Excel, how can I have these instructions entered as comments show up in my printed report?
To do it in Excel, here is the answer:
a) Click on "Print Titles" under "Page Layout". In the "Page Setup" dialog box that comes up, against field "Comments:" select "At end of Sheet" or "As displayed on Sheet" as required.
Comments would be printed at end of Sheet or at the location where it is available in Excel Sheet depending on opttion chosen.