How can I enable “Ctrl + Shift + V” command into Excel?

Question

I'm pretty new to Excel and notice it doesn't have "Ctrl + Shift + V" as a default shortcut. Is there a way to assign this specific action to this shortcut? I previously tried using Microsoft Visual Basic but it keeps giving me an error, can you guys help me out?

Answer 1

Hi,

Thank you for posting in Microsoft Community.

We appreciate you for showing interest in using Microsoft products specifically with Excel. Before we proceed, we would like to ask some questions to better understand the situation. Let's work on this together.

To better understand the situation, we would like to ask some questions, such as:

• What Microsoft 365 Version and Edition are you using? - About Office: What version of Office am I using? - Microsoft Support
• What specific command are you trying to get with the CTRL + SHIFT + V? is it the Paste command or what? please specify

While waiting for your response, kindly check this support article about Keyboard shortcuts in Excel - Microsoft Support.

Sincerely,

Leonardo_Y

Answer 2

Well I'm using Microsoft 365 MSO (Version 2304 Build 16.0.16327.20200) 64-bit.

Also I already figured out of how assigned specific command.

All I have to do is type Alt+F+T >> Customize Ribbons >> check Developer under Customize the Ribbons box >> click OK >> Go to Developer >> click Visual Basic >> Go to insert >> then module >> then type:

Sub PasteValue()

If (Application.CutCopyMode = 1) Then

    Selection.PasteSpecial Paste:=xlPasteValues 

Else 

    ActiveSheet.PasteSpecial Format:="Unicode Text" 

End If 

End Sub

>> Close Visual Basic >> type Alt+F8 >> select PasteValue >> go to options >> then insert Ctrl+Shift+V >> and click OK

There you have it.

Answer 3

Hi,

We appreciate the time and effort you spent in finding the resolution for this concern and posting here in the community.

This will be used as reference to other community member who is having and will have this issue in the future.

For future concerns, do not hesitate to submit/create a new thread in the community

Sincerely,

Leonardo_Y

Answer 4

Is there a way to do this so that it carries over for all excel files you open or create?

Answer 5

Hi,

You indicated that you are using 365 in windows so:

As of 2022 Ctrl+Shift+V is a default assigned shortcut key it is "paste plain text"

As of 2007 Ctrl+Alt+V became the shortcut key for Paste Special