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?

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 excel print the comments of a sheet

 

You can find similar Excel Questions and Answer hereunder

1) How can I ensure that user enters only certain acceptable values in an input cell?

2) How can I fill a series of data automatically?

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

4) How can I copy and rename a WorkSheet using VBA?

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

6) Calling a macro from another workbook 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 find the count of records that meet multiple conditions in my raw data table?

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

10) how do you enter multiple line in a cell in Excel

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

12) Find and count instances of a character in a string in Excel

13) How do I use Find to determine last occurrence of a string in a WorkSheet range using VBA?

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

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