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
223 comments
-
Jakub
commented
No point to paste formating - say you are making an adress list from data listed all over the internet. You copy and paste email adresses, phone numbers and websites. Your table looks like **** and you have to format it afterwards.
-
subbs
commented
Needed a lot
-
Anonymous
commented
Agreed fully on this suggestion. Please at least add an option to paste unformatted text by default. As an avid shortcut key user, this would help to speed up some of the work I do by half.
-
Futski
commented
@Esteban, I agree with you 100%. Pasting a table from a web page should default to values only because the the mess it makes trying to include the formatting.
-
Esteban Castro
commented
It becomes a mistake when pasting from a web table, it takes a million years and the result is a mess. The intended paste is text only but there's no global setting for assuming text only for external paste. Thanks.
-
ZC88
commented
Agree to set the Default @Sheet level. At least for protected sheets.
Don't understand why this needed feature takes so long to be implemented. -
Ross
commented
I've got to emphasize Futski's comment - spreadsheet level override needed !!!!
"In todays world of "shared" spreadsheets, I think the setting for default paste type needs to be set not only at the user level, but also at the spreadsheet level. I have seen countless spreadsheets messed up by careless copy/pasting of data.
Having this option available is of no use on a shared spreadsheet if 90% of the users never change the option from the default of including formats. Therefore, if the option were available at the spreadsheet level, the author could change the setting to over-ride the users default, thus preserving a carefully formatted spreadsheet." -
RM
commented
I just gotta give Jan's comment a big round of applause. Microsoft - get it done!
-
Jan Burgess
commented
Happy 5th birthday Default Excel Paste Request.
FFS - 5 years of asking for a default paste option. Co-authoring, secure external sharing, teams, all sorts of collaboration. Microsoft - what the heck are you doing?
Man (and woman) decades of work have been lost due to this stupid default. Carefully formatted spreadsheets wrecked, formatting over-ridden, defined names moved to another cell, formulas and macros not working. Hours and hours and hours of troubleshooting - because somebody cut and pasted or copied and pasted without knowing that Microsoft WON'T FIX A STUPID DEFAULT !!!
Please - I'm begging you. I don't think I can take another 5 years :(
-
Anonymous
commented
seriously just fix it its an easy fix
-
Anonymous
commented
As someone who works in spreadsheets all day and is heavily involved in data entry, this would save me about a second per entry at least. That means if i enter just 1000 items (this is within a few hours only), i'm saving over 16 minutes. Please get this change made!!!!!!!!!!!
-
Futski
commented
In todays world of "shared" spreadsheets, I think the setting for default paste type needs to be set not only at the user level, but also at the spreadsheet level. I have seen countless spreadsheets messed up by careless copy/pasting of data.
Having this option available is of no use on a shared spreadsheet if 90% of the users never change the option from the default of including formats. Therefore, if the option were available at the spreadsheet level, the author could change the setting to over-ride the users default, thus preserving a carefully formatted spreadsheet. -
hi
commented
let us set the default paste format we need!!! losing lots of time!!!
-
Josh
commented
This is one of the top requests. Why hasn't there been a response? Microsoft 💔😢
-
[Deleted User]
commented
Please add this feature. Thanks.
-
Biplab Ghosh
commented
Please add the option, default source formatting is just annoying.
-
Arne Munther commented
Sound like the way to go.
-
yeet
commented
yare yare daze
-
james blair
commented
yes please guys. This will hardly get a mention in reports on update features but your core users will really cheer.
-
[Deleted User]
commented
please do it! it saves time greatly!