Moving comments in excel

I'm sure this must be laughably easy to do, but I'm darned if I can work it out, even having googled it!

I have some comments which relate to certain cells, but now I want that same comment to refer to a different cell.  Other than deleting the comment and creating a new comment in the right place, how can I move it?

 

Thanks in advance! (I'm using 2007 btw)

Comments
ACDWebb's picture

Copy

ACDWebb | | Permalink

and Paste Special ... Comments

Moving comments in Excel

kross | | Permalink

Hi

 

I find the easiest way is to COPY and then PASTE from one cell to another. This will however mean that the data contents and any formula will  also have been copied across so you will need to verify that is correct and edit in the new cell as appropriate.

Paste Special

paulwakefield1 | | Permalink

Just to add to ACDWebb's suggestion, Paste Special is one of those unsung "really useful things" in Excel. It can be accessed from the right click menu or from "Edit-Paste Special" in Excel 2003 or by using the drop down arrow below the Paste icon in Excel 2007 or 2010; the latter giving you some ready made options as well as the traditional selection box.

There are occasions when you want to copy something but not the whole range warts and all. e.g. a formula without the formatting or, as here, comments only. It can also be used to quickly change the sign of numbers. If you are not familiar with it, it is well worth exploring.

comment

Kericho | | Permalink

copy   past special    then tick comment

ACDWebb's picture

Hence

ACDWebb | | Permalink

kross wrote:

Hi

 

I find the easiest way is to COPY and then PASTE from one cell to another. This will however mean that the data contents and any formula will  also have been copied across so you will need to verify that is correct and edit in the new cell as appropriate.

Copy

PasteSpecial

Comments

Add comment
Log in or register to post comments
Group: ExcelZone
A gathering place for the Excel community to explore new ideas and techniques and a forum to debate product features and best practices.