keyboard shortcut

G

Grayling

Hi.
It would speed my productivity no end if I could use a
keyboard shortcut for edit/paste special.../text. Does
anyone know how to set this up?

Many thanks
 
D

Don Guillett

If you mean paste VALUES then right click on toolbar>customize>edit>look for
the one with the 12 in a box>drag to toolbar.
 
A

Andy Brown

It would speed my productivity no end if I could use a
keyboard shortcut for edit/paste special.../text.
Click to expand...

If you *mean* Paste Special, you can rightclick a toolbar and select
Customize. On the Commands tab, under the Edit category, find the Paste
Special command and drag it to a toolbar or the menu bar.

Once it's there, you can use ALT+S -- T -- Enter.

If you mean Paste *Values*, Don told you how. But you can also customise it
to show as Image & Text and thus invoke with ALT+P.

HTH,
Andy
 
G

Gord Dibben

Grayling

Record a macro while doing this then give it a shortcut key.

Sub Macro1()
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
False
End Sub

OR ALT + E + S then downarrow then <ENTER>

Gord Dibben Excel MVP
 
G

Guest

Very many thanks for ideas. I should have said that I'm
pasting an html table (I think!) so Paste Special...
offers the options HTML, Unicode text or Text and I
choose the latter. I'm afraid I don't understand Gord's
suggestion about recording macros but will look into it.

Regards
Grayling
 
Top