comments
JohnRogers wrote:
when I print the comments in cells, the the location and
the comment is printed. The location prints as (Cell: S56)
Is thee a way to use some other designation for that cell -
the name of the cell, for instance, the name of a column,
etc.
I asked that question earlier. Doesn't seem to be any way to change the
way Excel formats comments. It reads them from the sheet left to right,
top to bottom. No sorting. And prints as:
Cell: [Cell location]
Comment: [Comment]
You can extract the comments from the sheet, then format and print as
you wish. Details would depend on what you wanted to do.
|