you could put a macro like this in your personal macro workbook and assign it
to a hotkey or to a button on your toolbar. Then copy whatever cell(s) you
need, select the destination, and run this macro (using hotkey or button on
toolbar).

Sub PasteSP()
With Selection
.PasteSpecial xlPasteValues
.PasteSpecial xlPasteComments
.PasteSpecial xlPasteFormats
End With
Application.CutCopyMode = False
End Sub

"maplesugarsnow" wrote:

I would like to have the ability to do a paste special that includes values,
formats, and comments but excludes formulas. Either the option to do that or
the ability to select mutli paste specials at once would be a great time
saver versus having to do it three times. Thanks.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions