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

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.

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.

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.

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

Afficher et imprimer noms de fichier, d'onglet, date, nombre et numéro de page tels qu'édités sur versions Windows/Mac dans les hauts et bas de page

Just allow us to bring up a window and select the row number to start deleting all the way to the bottom. When you copy to columns, 1.04 million rows get created. And it literally takes HOURS at the fastest scrolling (25% view) to get rid of these. Look in the searches lots and lots of people complain about this.

Right now the only way of appending or prepending something to cell contents is to use a concat function which can be a hassle depending on the contents.

Alternatively adding full regex functionality to the search/find and replace function would be even better!

Hi there!
It would be a great help for my work if "Ctrl+A" shortcut was working in the excel formula bar.
Thank you

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.

AUTOSAVE
there should be an option to PERMANENTLY TURN OFF AUTOSAVE. BAD for my busn and many others. s/b optional.
appreciate MS coming up with new ideas and safeties, but SOME of us, ME INCLUDED, wanna make our OWN decisions of what changes to a file we wanna save, and what we don't. MS is changing my file auto, and a huge pain for me. many times i don't have time to fix at the moment, and I'M STUCK with changes i don't want.

When editing with the Find and Replace, show a list of all cell contents (in the find window) that will change, along with the portion of the cell that is modified. The modified portion should be highlighted in yellow to indicate that it will change. The Preview can be shown as the user enters the replace text.

When opening the name manager, add a Filter option to show "Selected Cells". This filter would then show only the names associated with any selected cells.

When I mistakenly enter a new range name in the Range Name drop down, I cannot edit this range name until going into the Name Manager. Provide ability to overwrite the existing range name, in the same maner as when entering a new range name.

I wish that there's an field to input how many rows or columns I want to insert right in Insert popover. I tired of inputting one by one row =))) Thank you!

Make the project references dialog box big enough (or scroll) so we can see the full path and file name of the reference. The current dialog box isn't big enough to see the full reference to the path and file name of the file referenced.

provide a function so that it automatically locks the prevoiusly entered cells