Copy comments box



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



muddan madhu

is this you were lookin for ?

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


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.




Gord Dibben

Muddan was on the money.

Insert a blank Comment Box in A1.

Select A1 and Copy.

Select A2:A27 and Edit>Paste Special>Comments>OK>Esc.

Gord Dibben MS Excel MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question