Need a advanced paste option that will paste the name of the cell, if one has been defined.

Reinstate Drag/Autofill menu

This is the menu that pops up after you drag to autofill and allows you to pick "Copy Cells; Fill Series; Fill Formatting Only; etc."

See Microsoft documentation on how one *would* use it, if it still existed: https://www.ablebits.com/office-addins-blog/2014/05/30/howto-use-autofill-excel/

This menu has been replaced with a generic formatting menu that is completely redundant with the main ribbon.

The autofill menu is a core part of my workflows, as I am frequently drag-filling multiple times and frequently switching between modes.

Picture shows what replaced the autofill menu, which you can find in the linked document above.

Set default to Copy - paste visible only, opt into paste hidden
The Default setting should be able to be set for visible only with paste special being for hidden.

Really annoying when working with filtered lists and pasting on everything hidden and not knowing / forgetting.

There's an awesome Calendar Template in Excel called "summer activities calendar 2019". I would like to edit and use it all year round to save on paper and ink but it does not seem to be editable. It would be great if there were several calendar templates with 4 months on one page that can be used for any month or year. Thank you very much for your time and consideration.

I just need to recover my overwritten saved file of ms-excel to a few hours before ( like time machine) but i did not find solution with the company and its developers. very disheartened! (please review my chat session no. 1468742155)
And I suggest the same to the company and its developers to provide the solid best solution for the issue. Thanks

In the Name Manager Dialog Box, enable the ability for user to enter text to filter on. Then show only the lines that contain the text entered by the user.

Presently, delete row command simply deletes it. It does not check if that row is totally blank or contains one or more non-empty cells. We should get a warning if a row contains one or more non-empty cells and we give a delete row command. With this feature available, we will save us from accidentally deleting a row, which may contain important data.

Above applies to columns as well.

The AutoCorrect function only works on page one and two of the spreadsheet on OneDrive. It would be great to have the option to turn this on and off for all pages of the spreadsheet by going through to File > Options.

When cutting/pasting a selection, the cursor should default to the top-left cell in the selection after paste on the source

Like Word and OneNote and web browsers, I should be able to click and hold the left mouse button, then scroll the mouse wheel to scroll the view and extend the selection. Currently while holding down the left mouse button, the scroll wheel does nothing, so to perform a large range selection I have to slowly and awkwardly drag the mouse near the bottom edge of the window.

on the Excel Find and Replace dialogue:
add a button to the left of the Options button to invert/reverse/swap the values in the Find and Replace fields, and another to clear both the Find and Replace values and plant the cursor in the Find field.

When adding a hyperlink in Excel, it currently applies to the whole cell. However, it would be great if Excel would allow having multiple hyperlinks within a single text cell.

For instance, if I have a cell with a text showing "This item can be found HERE and THERE", it would be great that I can add a hyperlink only to the word "HERE" and a different one to the word "THERE".

Enable ability to display font changes when viewing formula (or text) in the formula bar.

Up to Excel 2003, the keyboard shortcut Ctrl+Sh+0 would unhide a column or columns. Since the shortcut isn't being used for anything else, please restore the functionality

Paste Special - number format only

The only past special options on number format are associated with either a formula or value. Oftern I need to standard formats across a number of cells and this functionality would allow this without using Paste formats which pastes all cells format styles - font, border, colour fill, etc

Being able to unhide all or multiple sheets at once, rather than single sheet.
When the selection of hidden sheets appear have the ability to pick different sheets by using Ctrl and mouse
Maybe also have an unhide all option

Other programs allow paste without formatting using ctrl+shift+v. Though this can be done through the right click menu it would be great to see this function built in.