Feedback by UserVoice

# Excel for Windows (Desktop Application)

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

• Hot ideas
• Top ideas
• New ideas
• My feedback
1. ## New Formula editing experience

With the arrival of LAMBDA and LET we now need a new formula bar experience. Please vote and put your suggestions in the comments on what features you’d like the formula bar to have

Signed in as (Sign out)

We’ll send you updates on this idea

2. ## See LAMBDA inputs and text in formula edit box

When selecting a cell with a LAMBDA function and then using the fx icon to display the Functions Arguments dialog it would be wonderful to see the function's input name(s) and description (from Name Manager's Comment box).

Signed in as (Sign out)

We’ll send you updates on this idea

3. ## A New Function to Make Scalar Functions More Powerful in an Array World

When Dynamic Arrays (DA) were introduced, it opened a plethora of possibilities and a lot of formula nerds and automation ninjas were empowered to begin a new wave of creativity while building more powerful worksheets with fewer formulas. As we explore the potential, we are discovering that there is a new limitation that begs for a solution. This is a proposal for a new function, SEGMENT, that can expand the flexibility of scalar functions that accept arrays as parameters so they can operate more robustly in an array world.

Consider the following problem as an example.

We have a two-dimension…

Signed in as (Sign out)

We’ll send you updates on this idea

4. ## Use new dynamic arrays in data validation

The use helper columns in tables now often is unnecessary if using the the new dynamic arrays. But if I want to use the output of one of the new functions as the source for a data validation list, I need to put the function in a cell and reference to that cell as the source for the data validation list. I would like to be able to put the dynamic array function directly into the source field of the data validation dialog.
Example: I have a table with a column of countries. I want to add a cell with…

Signed in as (Sign out)

We’ll send you updates on this idea

5. ## Add a Split dynamic array function

Add a dynamic array function to split apart a delimited range. See attached file for an example.

Signed in as (Sign out)

We’ll send you updates on this idea

6. ## Allow INDIRECT to work with dynamic names

Now that we have dynamic arrays, we can set up dynamic range names to define those dynamic ranges.

However, because INDIRECT doesn't work with dynamic names, we're limited in the ways we can use those dynamic names.

Please fix the INDIRECT function so that it works with dynamic names.

Signed in as (Sign out)

We’ll send you updates on this idea

7. ## would like to make a cell "flash" on given condition

would like to make a cell "flash" on given condition

Signed in as (Sign out)

We’ll send you updates on this idea

8. ## StockHistory function to include dividend history

Signed in as (Sign out)

We’ll send you updates on this idea

9. ## Timespan calculus

Currently, in cells formatted as time ([\$-x-systime]h:mm:ss AM/PM), if I sum 16:00 and 12:00, I get 04:00. I would like to have the possibility of getting 28:00.

Maybe this could be achieved through a new TimeSpan cell format that would show the absolute number of years, months, days, hours, minutes, seconds, etc. without a calendar, according to the selected format.

So, 28:00 could, also, be shown as "1 day and 4 hours", or "1d4h", depending on the format selected by the user.

Those TimeSpan cells would operate with other cell formats nicely. It would be possible to add a time…

Signed in as (Sign out)

We’ll send you updates on this idea

10. ## Lambda optional parameters

Using the new lambda function, can we have the ability to put parameter names in square brackets to turn them into optional parameters for the user?
LAMBDA(parameter1, parameter2, [parameter3])
This would be extremely useful for reusable functions. For example, I've created a function that combines arrays, but I don't want to have limit that function to passing only a specific number of arrays or forcing the user to enter commas for the remaining criteria. Similar to index, or sumifs or other function that has optional parameters please!
Also, if you're feeling generous, I'd love the option of hidden parameters too,…

Signed in as (Sign out)

We’ll send you updates on this idea

11. ## SUMCOLS and SUMROWS functions for Dynamic Arrays

Create new functions that SUM each column in a dynamic array (SUMCOLS(Ref#)) to produce a row of totals, and SUM each row to produce a column of totals (SUMROWS(Ref#))

Also COUNTCOLS, COUNTROWS, AVERAGECOLS, AVERAGEROWS, but these are less important than SUMCOLS & SUMROWS.

Signed in as (Sign out)

We’ll send you updates on this idea

# Background

Quite often you need to transform a list of horizontal and vertical ranges into 1 single column of stacked values.

1. In A1:A3 put 1, 2, 3 respectively.
2. In B4:B6 put Hello, World, Microsoft respectively.
3. In order to get a single column of those 2 range you need to use these crazy formulas like described here, for example: https://www.extendoffice.com/documents/excel/2775-excel-convert-matrix-to-single-column.html

4. If you put any of those formulas from videos in C1 cell result should like that:
C1 = 1
C2 = 2
C3 = 3
C4 = Hello
C5 = World
C6 = Microsoft.

# Problem

The problem is that…

Signed in as (Sign out)

We’ll send you updates on this idea

13. ## Can we please get IntelliSense for LAMBDA functions?

Add the ability to define arguement prompts when using a LAMBDA function

Signed in as (Sign out)

We’ll send you updates on this idea

14. ## Stockhistory function to return the correct historical price - adjusted for splits AND Dividends

Currently the stockhistory function returns a historical price that is only adjusted for splits. Using this to calculate historical returns for any instrument that pays any sort of dividend or capital gain will yield incorrect results.

Signed in as (Sign out)

We’ll send you updates on this idea

15. ## SUBSTITUTES function supporting arrays of "find" and "replace" parameters

From time to time, users need to remove multiple characters from a string. For example, you might want to remove all punctuation, or all accented characters.

Right now, you have to do that with a lengthy nested formula using the SUBSTITUTE function. Such formulas are hard to read and challenging for a novice to debug. Or you could write a VBA user-defined function that performs each of the substitutions for you.

The better approach would be a SUBSTITUTES function that works like SUBSTITUTE but accepts an array (or range of cells) for the Find parameter, and possibly also for the…

Signed in as (Sign out)

We’ll send you updates on this idea

16. ## Excel Aggregate Place Value.

Hello team,
I would like to suggest an idea in excel. since I am using Microsoft Office for a long time, my work was going well unless I discovered a problem. it is actually not a problem but I think a feature can be added.
Suppose, when I calculate a value from multiple cells and get the result in the decimal form we can use place value to round off the value and see the value, but it would be great efficient if somehow exact value (after round off) could be generated by the system itself.
Example:
497*45% = 223.65,…

Signed in as (Sign out)

We’ll send you updates on this idea

17. ## Allow me to run multiple instances of Excel again (as in 2010)

The intent here is to allow me to disable auto-calculation on one (1) spreadsheet, without disabling it on all open spreadsheets. I should then be able to manually trigger calculation on one (1) spreadsheet without triggering calculation on all open spreadsheets.

Signed in as (Sign out)

We’ll send you updates on this idea

18. ## Correção na documentação da função SOMA

Correção na documentação da função SOMA.

Correção da documentação na função SOMA, como neste exemplo anexo informa que se deve informar de 1 a 255 "números" mas que na verdade são argumentos, podendo dentro delas constar números, célula, intervalo de células, funções ou fórmulas e não somente números, para um usuário que está começando e lê isto pode, e já
foi presenciado, inserir de forma manual números nos argumentos por não ter o conhecimento e não estar especificado de forma correta a diversas formas que pode ser aplicada.
Como sugestão alterar o "núm1;núm2"... para arg1;arg2... e de 1 a 255…

Signed in as (Sign out)

We’ll send you updates on this idea

19. ## Allow UNIQUE() to operate on a rectangular range, returning all unique values

The new Dynamic Array function UNIQUE is awesome. It can return all of the unique items in a column or in a row. But it would be nice if the second argument could accept a 3 to indicate cell-by-cell.
For example, see the screenshot below.

Signed in as (Sign out)

We’ll send you updates on this idea

20. ## Change external file links with the INDIRECT() function without having the file open – Welcome to Excel’s Suggestion Box!

Pouvoir utiliser la fonction somme.si sans être obliger d'ouvrir le fichier source