Prevent Excel from changing large "numbers" (actually text values) to scientific notation.

There should be an application setting OR paste recovery option OR cell format to retain leading zeroes when entering values in cells (either manually or through another means like CSV import).

(2015-11-05 Dan [MS] Updated idea title and description to broaden this issue from maintaining leading zeros on CSV data import to maintaining them on any cell entry.)

Undo stacks are currently global between all workbooks that are open at a given time, so pressing undo on one workbook might undo a change in a different workbook. As someone who frequently has multiple workbooks open at a time, it would be much more helpful to be able to step through the edits made on each individual workbook.

When using Ctrl to select multiple cells, we can't unselect a cell when it was misclicked. Instead, we have to click these cells all over again. Please allow us to unselect cells!

I would love to see IP Addresses added as a format option and functions added for validation of the IP addresses..

For instance InSubnet(Network as IP,Netmask as Integer,address as IP) to determine if an IP is within a Subnet;

Being able to do addition/subtraction on the field would be awesome as well!

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.

When you create a data model and measures in PowerPivot with PRO versions, users can modify and edit both.

Users and customers that have no idea on how the model has been build can make a lot of damage and dysfunction.

As well as VBA has it would be very interesting that Power Pivot has the option to be able to protect data model and measures with a password.

If I have a worksheet called January and I Ctrl+Drag that sheet to make a copy, Excel should automatically call it February. Use the same logic as the Fill Handle (support months, weekdays, and any custom list).

Via the Paste Special we can operate on a range of values. However, to do, for instance, a multiplication, we first need to use a cell for it. As an option I would like to see that we can instead add a number to the Paste Special dialog as the attached screen shot shows.

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.

Given the great danger of not realising that calculation mode is set to Manual, it would be very beneficial if a "Manual Calculation Mode" indicator (in bright fire-engine red!) was displayed (and visibility maintained until calc mode is switched back to non-manual) in a prominent location - such as in the Title Bar to the left of the Minimize button.

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.

Use Genral format when inserting a new column instead of inheriting the format of the previous one. Or ask the user.

a 'Swap' function (as a right-click) could allow data in specific cells or ranges to be swapped. Without it, users need to find or create an interim sheet / cell, which is a pain. I'd like this to work like the existing Paste-transpose function.

You can copy and paste special by linking or transposing, but you can't do both. Please fix

Currently Excel is the only Office application that doesn't have the ribbon-button to change selected text to uppercase or lowercase.
The only way to do it is to use the function =UPPER() and then copy/paste the resulted value into the original cell.
It would be good to have a button to change the selected text to uppercase or lowercase.