Topics

Feb 4, 2011

Copy comments to other cells in Excel 2007

You add a comment in a particular cell and want the same comment to appear in multiple cells. You can copy the contents of the cell that has the comment and during the paste time you have to choose the option of pasting the comments. Performing the following steps to paste comments:
1. Click a cell that has the comment and press Ctrl + C or from the Home tab, click Copy from the Clipboard group.
2. Click the cell that needs the comment to be pasted and then press Ctrl + Alt + V or from the Home tab, click the arrow mark that is present in Paste and click Paste Special...
3. From the Paste Special dialog box that opens, click Comments.
4. Click OK.
Ctrl + Alt + V (Ctrl Alt V) is the keyboard shortcut to open the Paste Special dialog box.

0 comments:

Post a Comment