Ctrl+Shift+C and Ctrl+Shift+V to copy/paste formats not working in Excel

Question

I have been using the Ctrl+Shift+C and Ctrl+Shift+V to copy/paste formats in Excel for years but they have stopped working. The computer beeps when I try them. There is no Customize Keyboard option in Excel either. Were these options removed?

Answer 1

Hi Tim,

Please note that other people on this thread have the same recollection and experience as me. This is not a "New Request" - it's a bug fix request. Can we please get it expedited? It is extremely annoying.

Thanks,

Michael

Answer 2

I've used the Ctrl+Shift+C/V to copy and paste formats for many years. Why change it? Please change it back. At least in WORD, you can customize your shortcuts to restore the same shortcut functionality. But Excel does not let you customize shortcuts.

As a previous reply mentioned, this is horrible. The old shortcuts still work in outlook, onenote, and powerpoint (I believe), are customizable in Word, and don't work at all in Excel.

Microsoft, come on. Different shortcuts for different programs within Office to do the same thing.

Please fix this!!

Answer 3

Michael,

unfortunately there is no way to force this from our side, you have to use the feedback function of the application.
How do I give feedback on Microsoft Office? - Office Support

Then you have to wait and hope that Microsoft changes it.

In the interim, IMHO there is a way to assign some VBA code to macros, and using VBA we can paste the formats only.
I haven't tested it with different versions of Excel yet, but IMHO there's a good chance it will work.

Download this file:
https://www.dropbox.com/scl/fi/7ng0xad0wtagoh84r4qdz/MacrosOnHotkeys.xlam?rlkey=k46orfe4g4ci5ia329sa8xo6j&dl=1

Unblock the downloaded file.
Unblock File in Windows 10 | Tutorials

Copy the file into a trusted folder, e.g. your documents folder and open it. Macros must obviously be enabled. No need to install, simply open the file.

This simple AddIn assigns 2 macros:

CTRL+SHIFT+C calls "CopyFormats" which performs a copy (same as CTRL+C)

CTRL+SHIFT+V calls "PasteFormats" which performs paste formats

Does it work on your side?

Andreas.