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.876 votes
This is a great suggestion, and we want to keep the interest going. Thanks to everyone who has already voted and commented on the suggestion to have an option for the default paste behavior in Excel.
Sorry that we’ve been slow to comment and update the status on this one.
Steve K [Excel]
Search for "make excel stop converting numbers to dates" and you will see the user demand for this feature. Please for the love of all that is holy let this be at least an advanced user setting.600 votes
Thanks for all your support of this request. We are taking a close look at this along with the related requests about maintaining leading zeros when entering values in cells, and to stop changing values to scientific notation.
We know these are important issues, so thanks for all the comments and votes.
Steve [Microsoft Excel]
Data Validation needs an auto complete in the List Option
It also needs to support Table Structured references directly in the List option without having to wrap it in a Name287 votes
Hi all – thanks for your support for this suggestion.
Improving data validation drop down lists by adding autocomplete is a great idea, as well as supporting structured table references in the data validation Source range.
Steve – Microsoft Excel
If you copy a worksheet from one workbook to another, Excel currently also automatically copies ALL Defined Names (even if there is no range in the source workbook to which these refer!). It will also copy without warning names with a different scope to an existing name in the target workbook (i.e. If an existing name has Workbook scope, a copied Sheet scoped name will be copied without an warning of the duplication!). This can result in a huge number of redundant or conflicting Names in the target workbook.55 votes
Thanks for the suggestion Col. We’ll prioritize taking a look at this according to how many votes it gets, so please keep voting for the things you like most!
John [MS XL]
- Don't see your idea?