provide an option to set Excel's default paste behavior
When you do an ordinary paste like Ctrl+V, Excel pastes the cell values, formatting, validation, everything. However, many users usually paste only values when working, and the extra handling to paste special is not productive.
Word and OneNote have a setting that allow the user to choose the default paste type, and that should also be available in Excel.
I know there are add-ins to workaround that and also the shortcut AppKey+V to paste values, but I think that should be a native Excel setting.
Felipe Costa Gualberto
shared this idea
202 comments
-
Anonymous
commented
The decision to not include the option to change paste behavior has added a huge amount of problems and delays. There are VERY FEW scenarios where I want to paste the formatting, formulas, etc and many situations where I just want to copy values.
-
Anonymous
commented
Yes, please Microsoft allow us the option to choose! Why would I even want to bring in all the formatting when simply trying to copy and paste a large amount of clipboard data. Either let us change defaults or have paste values only available as right hand mouse selection on cells
-
Anonymous
commented
YES PLEASE. My users are too dumb to right click > paste as plain text/use destination formatting. It's so frustrating having people constantly change my documents' formatting and the "protect" features don't help at all.
-
shan
commented
I think we can expect more than simply an option to select the default behaviour. Why the **** is Excel literally the only application wherein when I press Ctrl-alt-v, that I cannot simply choose from one of the top 3 pasting options? Those being to merge formatting, retain formatting or paste as plain text only?? It is so frustrating.
Nevermind the fact that a cell in excel will never be an actual blank if at any time in the history of ever that cell was populated. This is ridiculous. Excel is ridiculous. MS is abhorrent.
-
Ryan
commented
So Excel for Mac has more flexibility than Excel on the operating system that Microsoft develops? Odd.
-
If you're using Excel for Mac, you can create a customized key combination for many actions in Excel. Go to the Tools menu, choose Customize Keyboard, then find the command you want to use. Select the category "commands not in the ribbon" and then search for "values" and you'll see the commands of interest. Then put your focus in the "Press new keyboard shortcut" field and press the key combination you'd like to use.
Here's more info - https://support.microsoft.com/en-us/office/create-a-custom-keyboard-shortcut-for-office-for-mac-6bbeb90e-96d9-4e03-b199-fc026ebdc321
-
Anonymous
commented
Please MS bring this back the way it was on Excel 2007. We should be allowed to choose our default, after all we are paying you for the product it is not free
-
Euan Renton
commented
I would like to have this option
-
D Scheideman
commented
At this point I think MS is just trolling us, I cannot think of any other motivation for this to continue for so many years. And, like has been said before, why is the default to keep source formatting? Whom was that particular decision meant to serve? Honestly! I would like to know the answer. This is baffling. I mean "Paste and Match Destination Formatting" is already in the command list. They don't even have to add anything in, just let us choose the default. This cannot be challenging to correct. The lack of this simple flag costs me HOURS of time every month.
-
Anonymous
commented
Why cant you implement this as it already available in other products in your Office line? I probably have to access the menu to manually change the paste option more than a hundred times a day. Quite annoying.
-
Anonymous
commented
It'll be nice to have an easier option like a check box next to all the paste clipboard options to make them as the default. This would be especially helpful in saving time when creating links rather than have to click the clipboard and choose the make links option.
-
Carl
commented
I have also suffered many times from fragmented and duplicated conditional formatting rules as described in this article.
Please add the feature as suggested.
-
Cédric Robert
commented
How is this not considered a bug. There is an option block users to use formatting options in the ribbon (With "Protect Sheet" and "Allow Users to Edit Ranges"). But anyone can use the default copy-paste to by-pass these restrictions.
-
R
commented
Unbelievable this doesn't exist, when it did a decade ago.
-
Jan Burgess
commented
Four and a half years and how many versions and we're still pleading for the return of a basic option ???
Come on MS - how about you guys actually talk to each other and standardize your system. You boast of integration and best practices and then you leave stuff like this hanging.
And please, don't tell me macros are a workaround. Yes - I can do this in my own development area, but you can't just go changing file extensions and having to set up trusted locations just to set a basic default option. It's absurd.
This is just like the inability to set the default location for templates in outlook. You'd swear MS thinks we're all home users playing around on a single system with no need to share or standardize and no change management control to get through.
/rant off
-
Branden
commented
Agreed. I have a spreadsheet formatted when populating with data I used CRTL V and it changes formatting. The default should be to paste values.
-
Anonymous
commented
I want a universal hotkey that pastes text/content only. Like Ctr-V but paste without formatting.
-
Jason
commented
This needs to be corrected apparently >5 years ago I can't believe how deep their heads are up their ***** about this one.
-
Emma
commented
Every six months or so I check in to see if anything has been done about this. Seems insane that you have not acted yet.Very obvious option to have in a spreadsheet.
-
Ionut
commented
It makes a really mess the actually setting. Most of the people doesn't realize the reason. Please change the default paste behavior for conditional formatting to merge !
