Can Comments be printed in a spreadsheet?

Is it possible to have a spreadsheet print associated comments along with the
cells they are associated with?

In xl2003 menus:
File|Page setup|Sheet tab

You'll find a couple of options for printing comments.

Woody wrote:

Is it possible to have a spreadsheet print associated comments along with the
cells they are associated with?

--

Dave Peterson

Hi Woody
Yes you can.
Goto File Page setup select Tab "Sheet" you will see "Comments, you can
select 3 choice.
HTH
John
"Woody" wrote in message
...
Is it possible to have a spreadsheet print associated comments along with the
cells they are associated with?

Thanks John

I am using 2007. I have a test file with a list of names. I have three
rows (names). For the third name I have a comment. When I select "at end of
sheet" and print the SS, the comments come out OK except that, for example
the printout says, Cell A3, which has no meaning to the viewer of the report.
They do not know that Cell A3 contains comments for John Doe.

If I select "As Displayed on Sheet", nothing printout out but the three
names. No Comments. Is there something more I am missing?

xl2007 has a setting to show comments.

It's equivalent to tools|Options|view tab|Objects|Comment and indicator (in
xl2003 menus) (and it's buried under that Office button|Excel options, I bet).

If you show those comments, then you'll see them in your printout.

You may want to use Debra Dalgleish's code to copy the comments to a Word
document. You can add as much info as you want (or as much as you're able).

http://contextures.com/xlcomments03.html#CopyToWord

Woody wrote:

Thanks John

I am using 2007. I have a test file with a list of names. I have three
rows (names). For the third name I have a comment. When I select "at end of
sheet" and print the SS, the comments come out OK except that, for example
the printout says, Cell A3, which has no meaning to the viewer of the report.
They do not know that Cell A3 contains comments for John Doe.

If I select "As Displayed on Sheet", nothing printout out but the three
names. No Comments. Is there something more I am missing?

--

Dave Peterson

Hi,

If you choose the As Displayed on Sheet option then you must display the
comment in the spreadsheet to get them to display.

Press Alt+1, choose Advanced tab, Display area, Comments and indicators

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Woody" wrote:

Thanks John

I am using 2007. I have a test file with a list of names. I have three
rows (names). For the third name I have a comment. When I select "at end of
sheet" and print the SS, the comments come out OK except that, for example
the printout says, Cell A3, which has no meaning to the viewer of the report.
They do not know that Cell A3 contains comments for John Doe.

If I select "As Displayed on Sheet", nothing printout out but the three
names. No Comments. Is there something more I am missing?

Hi Woody
Sorry I'm not familiar enough with XL07.
In XL03 you need to have the comment box visible to be able to print them.
Goto ToolsOptions ViewSelect "Comment & Indicator"
You need to find those settings in XL07
HTH
John
"Woody" wrote in message
...
Thanks John

I am using 2007. I have a test file with a list of names. I have three
rows (names). For the third name I have a comment. When I select "at end of
sheet" and print the SS, the comments come out OK except that, for example
the printout says, Cell A3, which has no meaning to the viewer of the report.
They do not know that Cell A3 contains comments for John Doe.

If I select "As Displayed on Sheet", nothing printout out but the three
names. No Comments. Is there something more I am missing?

If you want to copy a list of Comments and their addresses to a new sheet
for printing use this macro from Debra Dalgleish.

Sub ListComms()
Dim Cell As Range
Dim Sh As Worksheet
Dim csh As Worksheet
Set csh = ActiveWorkbook.Worksheets.Add
csh.Name = "Comments"
For Each Sh In ActiveWorkbook.Worksheets
If Sh.Name csh.Name Then
For Each Cell In Sh.UsedRange
If Not Cell.Comment Is Nothing Then
With csh.Range("a65536").End(xlUp).Offset(1, 0)
.Value = Sh.Name & " " & Cell.Address
.Offset(0, 1).Value = Cell.Comment.text
End With
End If
Next Cell
End If
Next Sh
End Sub


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 10:12:01 -0700, Woody
wrote:

Is it possible to have a spreadsheet print associated comments along with the
cells they are associated with?

Perhaps using the name in the cell (John Doe) as a header to the comment
would provide more useful information? It would not remove the cell
reference, but it would link back to the person's name. Example:

Cell: C4
Comment: John Doe: (in bold?)
Did not return my
call last month.

I tried to trick Excel by naming cell C4 as "JohnDoe", but Microsoft is
smarter than I am!

Eric

"Woody" wrote:

Thanks John

I am using 2007. I have a test file with a list of names. I have three
rows (names). For the third name I have a comment. When I select "at end of
sheet" and print the SS, the comments come out OK except that, for example
the printout says, Cell A3, which has no meaning to the viewer of the report.
They do not know that Cell A3 contains comments for John Doe.

If I select "As Displayed on Sheet", nothing printout out but the three
names. No Comments. Is there something more I am missing?