paste special key combo

R

Robert

Seriously, in law school and my job I've needed to pastespecial-unformatted a
billions times with no ability to use a hot key combo to avoid the pop up
window. I've tried macros, looking for advise online how to fix this...but
I've not come up with anything easy. I also always assign alt-S to the
Section symbol but I'm not sure if as many people would find it helpful
making that a default.

Also, could a preference feature be added to excel that automatically shows
the cells that are used in a formula w/o having to click in the data entry
space. In general, I have to go between clicking in the cells and in the
data entry area too much for my liking.

All the rest is just mildly annoying but the paste unformated thing is akin
to a crime. Please add a shortcut key combo to the next version or at least
have a way to set up a macro or something that does it with a keystroke
instead of always opening a dialog box.
 
G

Gary Smith

Following is the text of a macro that will perform the Paste Unformatted
action. I originally created it by recording the action and then editing
out some irrelevancies. You can assign this macro to the key combination
of your choosing. I like Ctrl-Shft-V.


----- begin macro text -----
Sub PasteUnformatted()
'
' Paste Unformatted Text
' Macro recorded 12/04/2001 by Gary Smith (Word 2000)
'
Selection.PasteSpecial Link:=False, DataType:=wdPasteText
End Sub
----- end macro text -----


Robert said:
Seriously, in law school and my job I've needed to pastespecial-unformatted a
billions times with no ability to use a hot key combo to avoid the pop up
window. I've tried macros, looking for advise online how to fix this...but
I've not come up with anything easy. I also always assign alt-S to the
Section symbol but I'm not sure if as many people would find it helpful
making that a default.
Click to expand...
 
Top