Hi Muddan

Thanks for replying so quickly. However, your suggestion doesn't work.

What I want to be able to do is to format , shall we say, cell A1 and put a
comments box in it. I know how to do this.

What I don't know how to do is, that I then want to copy that formatting to
all the cells below A1 ie a2,a3,a4 etc so that I end up with each cell with a
comments box attached ready for when I put a comment into each box. If I do
this manually for each cel it will be time consuming as you can imagine. I
want to be able to do it in one go with some form of copying but bit doesn't
seem to work.

Regards

"muddan madhu" wrote:

is this you were lookin for ?

copy the cell | go to edit | paste special | comments | ok | esc



On Oct 23, 3:30 pm, chesjak wrote:
Whilst using Excel 2003 pro

When I attache a coments box in a cell, I want to be able to place a
comments box in each cell of the same column. I have done this before but
can't remember how to to it now. The obvious answer I though was to click on
the cell with the comments box and then copy to each cell down the column..
This doesn't work.

Any help would be appreciated