Set default pasting option in Excel to "Text"

Question

I would like to be able to paste text into excel without the link coming along. I see I can select paste special, open up a window, way too many steps already for such a simple thing.

This is annoying when I have hundreds of things to paste. I should be able to do this with a keyboard shortcut.

Apparantly Ctrl + Shift + V doesn't work in Excel. I also don't see a way to permanantly set the paste option to text.

I don't wanna have to correct it by clicking on things with my mouse after pasting with the keyboard shortcut every time.

Please tell me there's a place to set the default pasting option to strip out all HTML and styling.

Answer 1

Dear APuhl,

Good day! Thank you for posting your query in our community.

Generally, you can use Alt+H+V+M to paste the link or some values as text.

You can record a macro after using Alt+H+V+M to paste the values and set the shortcut Ctrl+Shift+V to run the macro automatically each time.

The recorded macro in my example is like the following.

Sub Macro2()

'

' Macro2 Macro

'

'

Range("F19").Select 

ActiveSheet.PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:= \_ 

    False, NoHTMLFormatting:=True 

End Sub

Thanks for your effort and time.

Sincerely,

Cliff | Microsoft Community Moderator

Answer 2

I can see that after I paste, I can then hit CTRL, then hit "M"... which is an improvement since I don't have to touch my mouse... but still... I should be able to tell Excel to just use my preferred method as the default.