Copy comments box

C

chesjak

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
 
M

muddan madhu

is this you were lookin for ?

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

chesjak

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
 
G

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

Top