can i attach the same comment to different cells

I have a series of spreadsheets that are used by others. Given the amount of
data i use the comments box to provide explanations. In at least two of the
workbooks theses comments are repeated and rather than inserting them time
and again i want to be able to insert the comment once and attach it to
different cells.

Hi

PasteSpecial>Comments


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



"shanec1987" <[email protected]> wrote in message
news:[email protected]...
>I have a series of spreadsheets that are used by others. Given the amount
>of
> data i use the comments box to provide explanations. In at least two of
> the
> workbooks theses comments are repeated and rather than inserting them time
> and again i want to be able to insert the comment once and attach it to
> different cells.

You don't have to enter the same comment more than once.

Enter the comment, then copy the cell, then paste>special>comment
to any cell the want the comment to appear.
--
Gary''s Student


"shanec1987" wrote:

> I have a series of spreadsheets that are used by others. Given the amount of
> data i use the comments box to provide explanations. In at least two of the
> workbooks theses comments are repeated and rather than inserting them time
> and again i want to be able to insert the comment once and attach it to
> different cells.