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 No comments

35 answers

Sort by: Most helpful
  1. Anonymous
    2024-05-17T07:54:53+00:00

    So this is really, REALLY annoying:

    • Powerpoint: ctrl+shift+c/ +v respectively, still work for copy/ paste formats.
    • Word: ctrl+shift+c/ +v respectively, no longer work. However, replace the shift with the alt key, and it works: ctrl+alt+c/ +v is now working for copy/ paste formats in Word.
    • Outlook: ctrl+shift+c/ +v respectively, still work for copy/ paste formats.

    Which odd-thinking individual or programmer team found it useful to change what were consistent shortcuts between applications, to different shortcuts - within the same office package??! I mean, really???

    As to the community here, I am still always baffled that so-called Microsoft Agents/ Moderators here, don't seem to be equipped with the full product knowledge, to be able to answer these questions. Anyhow.

    So the above is a fact, the key sequence has simply been changed in Word, the functionality has not been removed.

    For those who responded with the hint to the format painter - thanks but that is off-topic. Who uses a mouse...

    These people here seem to have found a solution to customizing shortcuts:

    How do I change the keyboard shortcut for paste formatting (format - Microsoft Community

    Copied from there for ease of reference:

    • user asks:

    Since my MS Word has recently been updated, the keyboard shortcuts for copying and pasting formatting have changed to Alt+Ctrl+C and Alt+Ctrl+V, respectively. However, I have become conditioned to using Ctrl+Shift+C and Ctrl+Shift+V. But now, when I do the latter key combination, it pastes from the clipboard as plain text (without formatting). When I try using the new key combination to paste the formatting (Alt+Ctrl+V), a popup mentions creating a clip or something, while my webcam shows up on the lower-left corner of the screen. When I went to change the keyboard shortcut for the paste formatting (File>Options>Customize Ribbon>"Keyboard Shortcuts:" Customize button>Blog Post Tab), the only one I could find on the list was "CopyFormat" and nothing called "PasteFormat." The "Commands" are listed in alphabetical order, and the list goes from "nonpublic" straight to "Research", which between those two should be the "CopyFormat" command.

    • answer given:

    The problem is the selection of the Blog Post Tab category, which for some reason has an incomplete list of commands associated with it. Instead, choose the All Commands category (near the bottom of the Categories list), and you'll find PasteFormat where you expect it.

    THAT is a good answer.

    After 25 years with Office, I had not know that you can actually customize all keyboard shortcuts.

    Should have learnt that back in my training days.

    Good day to all here!

    30+ people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2024-05-15T20:38:05+00:00

    Hi there. Since the very old days of Office and Windows itself, ctrl+c / ctrl+v was to "copy/ paste everything" whilst ctrl+shift+c/ ctrl+shift+v was to "copy/ paste formats". As Michael says, the former create a clipboard entry whilst the latter are stored separately and each can be applied multiple times (i.e. you can copy-paste an entire content to then later paste formats you had copied earlier). This was from back in the days when Office and Windows were actually best controlled through keyboards and you could "type" key sequences to follow through the menues. Then Microsoft went to move more towards mouse control and complicated multi-key commands, then it moved back to what we have today which is again more of a keystroke sequence type of control. The "old" shortcuts had been maintained throughout and, indeed, until very recently -it can only be a few days, on my version of Office- these have worked. So somebody must now have gone in and took them out of the code. That action must somewhere be documented within the updates. Can we please undo that??

    30+ people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2024-04-08T08:38:15+00:00

    Thanks for the reply. I also can't find any reference to it in the docs, but unless I am going completely senile, this keyboard combination existed till recently. It certainly still exists and works as expected in Word and PowerPoint. So whether it was an undocumented feature, or a figment of my imagination, can we have it as a feature request?

    Ctrl+C and Ctrl+V don't help here as the idea is to copy ONLY the format and not the cell contents.

    These keyboard shortcuts to copy-paste ONLY formatting are better than the formatting brush because they "remember" the copied format and you can apply it again and again on different cells and ranges, even if you did other work on the spreadsheet.

    10+ people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2024-05-16T15:34:43+00:00

    Thanks Max. I'm glad there is someone else out there who had the same experience. I was beginning to think I had imagined it... So MSFT - any chance of getting this fixed?

    10+ people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2024-05-24T20:08:22+00:00

    Brutal change to the software.. I've been using this shortcut for a decade. Microsoft - please change it back and hire support staff who know your product

    10+ people found this answer helpful.
    0 comments No comments