Share via

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

Anonymous
2024-04-07T10:00:59+00:00

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?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

35 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2024-08-16T16:27:04+00:00

    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!!

    6 people found this answer helpful.
    0 comments
  4. Anonymous
    2024-08-18T08:28:15+00:00

    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

    6 people found this answer helpful.
    0 comments
  5. Andreas Killer 144K Reputation points Volunteer Moderator
    2024-08-18T09:47:02+00:00

    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.

    0 comments