Print the comments of a sheet in Excel

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?

excel print the comments of a sheet

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.

excel print the comments of a sheet


You can find similar Excel Questions and Answer hereunder

1) How to change the color of gridlines in a worksheet in Excel

2) Every time I make an update to my Worksheet, I would like to add a timestamp to my Last Updated field. In Excel, how can I do that in Worksheet?

3) Vba clear the contents of an entire sheet in Excel

4) I have a big Table spanning across pages when printed - how do I get Excel to print titles in all pages?

5) How to add a link in a sheet to another sheet

6) How to center excel sheet horizontally and verticaly on page in Excel

7) How can I hide a sheet completely from users (the sheet should not even appear in Unhide dialog box)?

8) How can I prevent edits on my worksheet by protecting it with a Password ?

9) How can I set non-contiguous print area using VBA?

10) How can I hide all comments in my WorkSheet using VBA?


Here the previous and next chapter