If my data has leading zeros, then I want leading zeros!.... How is that so hard to understand!?!... Make truncating leading zeros an optional setting, not the default.

Idea of insertion/ removal of Watermark in the excel sheet like in word is likely for some creative work

When we are entering maybe 50 independent marks of a student in a row, could we have that row light up while we are working on it..so that we do not accidently stray away from that row?

I have a long list of formulas, and want to nest every formula within another if statement. Using find and replace to replace the beginning and end of every formula (the parts that don't differ between each one), this should be very easy. However, excel won't let me change a single one because, when I try to replace the text, "the formula is missing an opening or closing parenthesis."

I can appreciate having error checking for formulas, but there should be SOME way to either bypass this error checking or turn it off! This is frustrating me to no end.

The note shows up too small. I would like a much larger default note size. I see no way to set a default size.

Along the same lines, I would like to be able to resize the note with the keyboard. Resizing with the mouse is tricky and time consuming.

Somewhat related, I would like the option of not having the user's name at the start of the note. I do no share the workbook and putting my name at the start of each note takes up space or requires delection.

Do not clear Excel's clipboard with every interim action during copy/paste operation. For example: 1) If I copy a cell's value and go to a table or pivot-table, clear a filter and then try to paste a value into the filter, the clipboard is empty. 2) If I copy a value from a cell and try to paste it when editing a query, the clipboard is empty. This costs me time and peace of mind up to a hundred times a day.

Please provide the functionality of insert in Translate Option in Review Tab. The similar functionality is already there in MS word but not in MS Excel.

I dislike the automatic scrolling to the bottom of the sheet when I double click a cell.

Doing various actions in excel - for example, using the bar on top to paste a formula - will often increase the size of the sheet to way beyond what was intended. There should be a button that would shrink the sheet to the largest area with values (or formulas that refer to values) - or alternatively, specify an area to be preserved with the rest eliminated entirely, so that the space on disk is reasonable.

What people do in practice is to copy the sheet area to a new sheet. This is a bit of a kludge.

The Evaluate Formula feature is great but could benefit by being able to go backwards in the calculation as well as going forward. Many times I've had to start over multiple times just to fully capture what is happening during a complex formula that could have been MUCH easier if I could step back one or more calculations instead of stepping all the way through or starting over.

There is no current easy/quick way or symbol to push or no entry in the :Help symbol whereby one can enter a new line or column on the chart you are working with

I want to type the Invoice in Excel sheet. It's not allowing to type. what to do???

Stop ******* with something that works you ******* idiots

By adding Word's "Change Case" options to Excel it would improve Excel's editing abilities and increase customer productivity adding value to the Excel product

We have paste by values shortcut in online spread sheets. We can have that in Desktop Environment also.

So that we can paste the cells by only its values. Using CTRL+SHIFT+V

Provide a way to color the cursor/ cursor box - so that when editing a row (or even the column) .... could be clearly identified.

MS customers have been asking this for years ... why this was not considered? It appears to be a simple option to offered to customers ... it helps with Excel use !!!!!!!

From the current excel, we can't copy more than one sheet. Currently we have to do one by one or VB script to do that. Please add copy sheet option with the user input numbers & sheet format option (which formatted sheet should we want to copy and create multiple times).
And Add sheet option, please include the same.