Printing Comments

[Coltsfan]

Does anyone know of a quick way to print comments in a cell beside
going to Page Setup? I was hoping to convert them to it's own cell bu
didn't know if that was possible

 

[Michael]

Coltsfan, couldn't you record a macro going to page setup > sheet > comments
as displayed on sheet, and assign it to a button on a tool bar?

 

[David McRitchie]

You can print cell notes with your printed sheet by choosing cell notes
option on File, Setup, Sheets

You can use a User Defined Function to get the comment value
to be shown in another cell.
http://www.mvps.org/dmcritchie/excel/ccomment.htm#mycomment