As it said in the title - by clicking on that area (on screenshot) those values will be copied to your clipboard and you will be able to paste them in different cell.

When I have already done some work and i delete a sheet in my workbook i am not able to undo and retrieve it back.
Need a feature that can enable this

🇺🇸 A good spell checker is important in any software. In Microsoft Word, it's a classic. In the modern web browsers, the dictionaries are there to help us write better as we type.

Excel should have the same ability to highlight our errors, as shown in the image:

🇧🇷 Um bom verificador ortográfico é importante em qualquer software. No Microsoft Word, é um clássico. Nos navegadores da web modernos, os dicionários estão lá para nos ajudar a escrever melhor à medida que digitamos.

O Excel deveria ter a mesma capacidade de destacar nossos erros, como mostrado na imagem:

every time I try and add a subcategory - for example - auto insurance I get

Category changes not saved
There was an issue saving your changes. Please try again.

I've tried entering it under the category Auto and Bills; neither will allow me to add the subcategory. This is not just for this example. this happens EVERY TIME I TRY AND ADD ONE. ITS ANNOYING AND NEEDS TO BE FIXED

An accepted issue for many years, the 'Refers to:' box in the 'New Name' dialog is troublesome when you wish to edit or move within this box using the arrow keys. This is because the cell references change instead.

Given LAMBDA is going to use this interface, and the formulae may be long (pointed out by fellow MVP Oz du Soleil), isn't it time this were fixed?

This issue catches us all out from time to time and I struggle to see the benefit of using the arrow keys to change the cell references here.

It's so dumb, no need for description .. but well after 25 or more versions of excel ...
So you filter a column, and you find the line with the data you want, you select the cell/row you want, and go in the menu and remove the filter .... TADA excel unselects the line you wanted and goes back to row 1 !
really sad :(

For some reason if you copy a cell (ctrl+c) and then do something else in the workbook (for example enter text in another cell), Excel clears the pasteboard and you can't paste (ctrl+v) the text any longer. Excel needs to be able to maintain the pasteboard so that copy / paste can function normally.

Currently, the "Enable fill handle and cell drag-and-drop" feature and the double-click on cell border feature are tethered together.
I would like to disable one feature, but keep the other feature enabled.

I would like to have to "Fill handle and cell drop-and-drop" feature enabled, but disable the double-click on cell border feature, as this often causes me to unintentionally jump across the spreadsheet which can be quite frustrating.

reinstall the "change case" button to convert lower case to upper case, upper case to lower case, etc.

If I have two workbooks open but a single workbook focused, don't share the change history between the workbooks. I don't want to undo the workbook I don't have focused. Why would this ever be an expected behavior when change history is usually tied to the desktop window and not to some shared process in the background?

Sorry Microsoft, but you really blew it in the 2016 update. Separate Excel windows used to be separate Excel windows. Now they share the same buffers for Undo, copy/paste, and highlighting. This is really limiting when working comparatively on two spreadsheets.

Numerous requests to fix the removal of preceding zeroes in cells, and fixing the scientific notation bug, and nothing has been done even though they have claimed to started working on these issues 3 years ago. It's time to clean house and bring in a team that actually wants to do their job.

Sometimes when working on a spreadsheet you need to fill cells with different colors, would just be easier if you have more than one Fill Color icon with different colors that you use instead of changing every time you need a different color.

I have a spreadsheet that I update once a day. When I open the spreadsheet, I usually start typing immediately, since it looks like the cell I want to edit is already selected. However, nothing happens. I have to click the cell in order to start typing. This is definitely a small complaint, but I see why you shouldn't be able to start typing right away.

Fix sysem interrupts when editing in excel

I would like to suggest commercial solution like Zimbra to Exchange Server Converter. This tool import Zimbra TGZ items such as emails, contacts, journals, notes, and etc. This application import Zimbra to Exchange Server and multiple file-formats including PST, EML, MSG, EMLX, vCard, vCal, an etc.

Read more: https://www.kdetools.com/blog/how-to-migrate-zimbra-to-exchange-server.html

There should be a Paste Special option to paste formulas without updating relative references.

In lineage view, where we can see each step as a box, we could visually drag and drop the results from any step of the query as a parameter to another step. This would be inspiring in lineage view. Where we can understand the flow and relations easily.