Microsoft has added a new feature to help users co-author files. Whether you are for or against this feature is not my point here: it needs Excel's AutoSave switched on to work. That's fine. But it shouldn't be the default. It is accepted that Office is trying to make various apps consistent, but Excel is used differently. What makes it the most popular software in the world is the ability to experiment without consequences.

Made a mistake? No fear, close without saving and re-open. Accidentally delete a sheet? Don't worry, close without saving and re-open. Replaced all formulae with =RAND()? Etc etc.

For those working in the Cloud, yes you can restore earlier versions - when it works. But many don't. And some can't (no internet, company policies, etc.).

What does the new setting mean? Make a mistake? You're stuffed. Fed up of re-doing files? Tough. Where is my earlier version of Excel? I will go back to it and to heck with Office 365. Yes, AutoSave as default is going to hurt people. Including Microsoft's strategies to adopt O365.

Please vote for this. All I want is a master switch where the default setting for AutoSave is off, so if things go wrong, you only have yourselves to blame. It's not asking too much, is it..?

Don't come here and vote when you have realised it's a good idea, do it now so you don't pay the consequences. Please... For all our sakes!!

We have our logo as well as a title up in the header on many of our Excel spreadsheets and we'd like more control with editing the headers/footers. Why can't we add more than one picture? Why can't we had shapes? Why can't we have more than 250 characters?
We also want the header to be visible no matter what view we're in, Normal, Page Break or Page Layout, so we know it's always there, without having to open the Header and Footer tab or going to Print Preview. These features need to work for both the Windows and Mac version since our employees use both and need to be able to open a file on either to work on it.
We also want to make sure that no matter the column number or width of a sheet the header size doesn't change, keeping our logo uniform in size no matter what page they're looking at.

I don't think we're asking a lot, this would be huge for us!

Hi all,

I've already posted this in the microsoft support forum, but they told me it might be better to post it here... so here I am... link (https://social.technet.microsoft.com/Forums/en-US/c73eaae8-1bfe-4d1d-8d62-8b5583bbf73d/suggestion-add-an-option-to-turn-off-new-excel-features-keep-the-copy-version-1705?forum=Office2016setupdeploy)

A few weeks back I've noticed my Excel start functioning weird when the moving ant lines WON'T DISAPPEAR no matter what I do.

After a few hours of research, I've realised it was not a bug, but it was a new feature of Excel, "Keep the Copy".

To be honest, it seems like quite a useful feature, but not when you have to work with Excel on a regular basis and have to keep seeing the ant lines while you work, which is very frustrating when the lines just keep going on and on for HOURS.

I know there is a way around, which is to open the clipboard and clear it EVERY TIME I've done pasting something, which is really annoying. THERE SHOULD BE AN OPTION TO TURN OFF THIS NEW FUNCTION.

Copying multiple cells means I have to clear the clipboard multiple times as well unless I want to see those moving ant lines 24/7... WHICH I CLEARLY DON'T.

For Now, I've 'rolled back' office version to 1704 and will likely not be updating until this is fixed (i.e. added option to turn this off)

I'm sure many people with Office 365 Subscription would probably have at least noticed this issue and many of my colleagues are quite frustrated by it as well. So it would be really great if we could add an option to turn it off (I don't really see why not anyway.)

TL;DR New "Keep the Copy" seems useful but very annoying so please add an option to turn it off.

Thanks for hearing me out.

Filtering:

When filter button is pressed on any column, the drop down menu should -

1. Show number of recurrences of each unique value displayed in the drop down list, in brackets on the right side of each unique value, in grey font. This will be very helpful in knowing, by just dropping down filter menu, how many records are there for each of unique values shown in the filter drop down list. Currently we have to filter each value and run a countif formula in a help column or look at the bottom line that shows how many records are filtered.

2. Show two buttons (maybe at top side of drop down menu), one down arrow button for selecting next value for filtering, and other up arrow button for selecting previous value for filtering in the list. This is very helpful when we are reviewing data by filtering one by one values in a column. Currently we have to scroll down to the value which is filtered, uncheck that and check the next value. Very tiring at times.

This may be an obscure complaint but it annoys the **** out of me almost every time I use the find window!

When I use Ctrl-F to find something, often I'm doing it multiple times in quick succession for different items I am copying from elsewhere.

My expected routine should be:
Ctrl-C (copy text)
Ctrl-F (open find window)
Ctrl-A (select all text in the find text box)
Ctrl-V (replace text in find text box with copied data)
Enter

The above would be a lovely left-handed keyboard operation that allows me to keep my right hand on the mouse.

But Ctrl-A doesn't work in the find window, so instead I have to press Shift-Home instead, using my right hand on the Home key. Really frustrating when you have many to do and you need to go back to the mouse to locate whatever you are copying!

Let's say a cell has "550" entered into it. It is formatted as General or some number format. In short, not as Text.

I later want to add "690" to that amount. I hit F2, type "+690" and hit Enter. I now have "550+690". Sadly.

There is no hintin the above to anyone in the world that I wanted "550+690". Clearly I wanted those values added, not treated as Text.

What I propose it that Excel move past Quattro Pro envy (it's been 20 years guys) and recognize the very obvious desire there. When I hit Enter in that example, Excel should add the numbers. It can easily place a "=" at the start of it all to maintain its standard. And I would have the desired "1240" in the cell.

It's even more obvious when I have the single number entry and add 3-4-5 more values ("550+690+235.34+543.90" for example).

It would even work nicely with dates. One has "4/1/17" showing — and entered physically like that, then Excel made the obvious assumption and treated it like a date changing the actual data stored from the preceding text to a rather different numerical value) — and hit F2, type "+20", hit Enter and it could see the obvious and display "4/21/17".

It could even extend to treating apparent cell references as exactly that and giving the result of the formula: cell has the same "690" to start, and one hits F2, then types "+A1" and hits Enter. There is nothing in that to hint you expect anything other than the result of adding 690 and A1's contents.

But... I'd settle for a numerically formatted cell assuming I wanted to add anything I added using arithmetical operators...

Hi,
In Power Query it is already possible to select 2 columns and merge their contain in a single column.
In the same way, when you perform transformation on a specific column (replace error, replace null, clean few things, ...) it is common to have your transformation column more or less equals to the source column.
So instead of doing 3 steps: erase the source column, move the transformation column to the previous position of the source column and rename the transformation column with the name of the source column), I would like to select the source column first and after the transformation column and then apply a specific button to do the previous 3 steps in one step.
This will save a lot of time