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

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

Same here. used copy/paste format for years, not just stopped working word but still works elsewhere.

The fact a change like this can happen blows my mind. It's such a pain in the **** when stuff like this happens. Hurtsmy brain, and more importantly productivity. I'd expect this more from Google than Microsoft but either way, WHYYY!!??

Thank you thank you thank you. This has been killing me for months now. Someone suggested using the paintbrush, but that takes too much time to move the mouse up to the menu, find that tool and then move back to what needs format-copy-pasting. The keyboard shortcuts are there for a reason - because they are quicker when you're already on and using the keyboard.

Now I just have to retrain my brain and finger muscle memory to use the ALT instead of SHIFT. This will be hard because I've been using the CTRL-SHIFT-C/CTRL-SHIFT-V for close to 15 years or so. 🙄

Anyhow, still, thank you for the solution.

As an alternative, you can add Paste Formatting to the Quick Access Toolbar. Go to File>Options>Quick Access Toolbar. Select All Commands in the dropdown at the top. Scroll down to Formatting (Paste Formatting). Select it, click Add in the center, and then OK. Anytime you want to paste the formatting, copy the cell or range, click on the location where you want to paste it, and click on this icon in the Quick Access Toolbar to paste only the formatting.

Another quick way is to use the Format Painter. It is especially useful if you want to copy the formatting from a single cell to a range of cells. Select the cell you want to copy the formatting, click on Format Painter in the Clipboard section of the Home ribbon, and click and drag the selection where you want to add the formatting. This can also be added to the Quick Access Toolbar if desired.

Dear Michael Schuldenfrei

Good day! Thank you for posting to Microsoft Community. I am happy to help you

According to my search in the official documentation, I really didn't find the shortcut you mentioned: Keyboard shortcuts in Excel - Microsoft Support

I've also tested it, and if you use Ctrl+C and Ctrl+V directly, it will paste the format by default, so if you want to choose the pasting method, you can try to use Ctrl+Alt+V：

I look forward to your reply. Thanks for your cooperation.

Sincerely,

Tin | Microsoft Community Moderator