Hi We need to open a new instance of Excel by deflaut each time we open an excel file. The following solution are not suitable.

you can start a new Excel instance (process) by doing the following:
run “Excel /x” (without quotes)
or the DisableMergeInstance regkey because it works only when you open excel first and then open the file. It does not works double clicking on an excel file. Don't give one of those solution (https://excelgorilla.com/excel/general/open-multiple-instances-excel/) as we need it to be by default as Excel 2010 behavior.

It's taken me 10 years to realise this but I've never "unchecked" My Table has headers, it's ALWAYS the other way round, forgetting to remember to tick it because Excel hasn't recognised the header row.

Let's default the tick to always on ?

Insert Data From Picture has been rolled out for Excel Mobile.

https://support.office.com/en-us/article/insert-data-from-picture-3c1bb58d-2c59-4bc0-b04a-a671a6868fd7

Please make this available for Excel Desktop. (Or is already available? If so how to access it?)

I selected multiple sheets and I tried to replace the "=" character with "eq=" in all the selected worksheets at one time. Since the 8/2019 version 1902 update, this find replace didn't work. Only some of the "=" characters were replaced.

Provide an option in dark mode in which the cell color defaults to black ( ie "no fill" results in a black background) and the text color defaults to white or light gray

Currently in Excel Online, when I format the colour of text in a single cell it changes the colour of all text in that cell. I would like the ability to change the colour of highlighted text only so I can have multiple colours of text in one cell.

After looking on multiple forums, I can see this has been an issue for many users for a number of years.

In the Power Query editor window the formula bar is defaulted as off. This is the first thing I tell people to turn on as it’s key to avoiding unintended errors and future proofing your code.

As Gil Raviv says in his book, “ Enabling the formula bar is fundamental to avoid the pitfalls”

I create Conditional Formatting on whole columns. I should be able to insert, delete, blank within my range without Conditional Formatting breaking up into formatted sections which eventually causes some rows not to format correctly. I am constantly correcting the Conditional Formatting which is very time-consuming! It is such a handy tool but very frustrating tool to work with.

Visual Basic for Applications is still version 7.1 from 2012. It's high time that power user portion of the application received updates to the interface, IntelliSense, and features. That portion of the program needs to be aligned with the current features now available within the Microsoft Suite. It also needs a facelift to the Userforms palette. I suggest starting with Excel, where VBA is most widely used, then PowerPoint, Word, Outlook.

Don't go destroying developer's programs, just add interoperability, functions, and facelift.

Some mainstream Microsoft products already support side scrolling inputs from mouse inputs that are capable of doing so with a notable exception of Excel. Ironically, I feel Excel would benefited the most of this feature. I understand that a user can side scroll with the Scroll Lock enabled but if the user already has their hand on the mouse to scroll vertically then it would make sense to allow horizontal scrolling.

Again, this capability is natively there for may popular applications with the notable exception of Excel.

Thank you for your consideration.

Jon

Proposal for a built-in function for: Count distinct/unique values in a range

There might be a dedicated function for counting distinct values in a specific range.
Currently the following function is a solution:
=SUMPRODUCT(1/COUNTIF([RANGE],[RANGE]))

However beginner-level users would like probably a predefined parametric function, sg like this:
=COUNT.DISTINCT([RANGE])

Thank you.

A formula to convert text to a formula; which is essentially the exact opposite of the FORMULATEXT function, or in a way, what the INDIRECT function does with cell references but with formulas.

Please support Unicode font in VBA.

Thank you!

Please allow to enter Hex color codes when choosing colors for cell fills, borders, fonts, charts, etc...
RGB and HSV are triple the work!

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.

When I want to edit a PowerPivot measure, I generally want to edit a measure I'm *already* using.

I don't want to scroll through a whole bunch of tables in the fields list trying to find it. I just want to right-click on that Measure right from the PivotTable Fields Values Pane where I can already see it, and do it right from there.

Give us the possibility to change the background color, of the active cell, to any color suites the user.