Excel Guides

Printing Comments in Excel

There are a few different ways that you can print comments in Excel. One way is to use the built-in print function. To do this, simply click on the File tab and then click Print. In the settings, make sure to check the box next to Print comments and notes. You can also choose to print comments in a separate file by clicking on the Options button and selecting the Save As PDF or XPS option. Another way to print comments is to use a third-party software like Adobe Acrobat.

If you want to print comments without printing the entire sheet, you can first select the cells that contain the comments. Then, go to File > Print > Selection. In the settings, make sure to check the box next to Print comments and notes. You can also choose to print comments in a separate file by clicking on the Options button and selecting the Save As PDF or XPS option.

Another way to print only comments is to use a macro. The following macro will print all of the cells that have comments in them:

Sub PrintComments() Dim sh As Worksheet Dim rng As Range For Each sh In ThisWorkbook.Worksheets  For Each rng In sh.UsedRange.Cells   If rng.Comment Is Nothing Then GoTo NextCell   'print each cell with a comment   Debug.Print rng.Address & " - " & rng.Comment.Text  NextCell:  Next rng Next shEnd Sub

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.