Feedback by UserVoice

Excel for Windows (Desktop Application)

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.

To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Create NETWORKHOURS as a new function

    I would like to see a function that calculates hours worked over a period of Excel Dates that incorporates working hours and non-working hours as well as holidays and weekends parameters. This function could use similar logic to the NETWORDAYS.INTL function's use or holidays and weekends parameters.

    26 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. #REF aid

    When Excel changes an element of a {cell,name,chart,DV,CF,..} formula to #REF and stores it, it obscures what it was. This makes it between difficult and impossible to rectify. Please make this friendly. Like being able to click on the #REF! to see what it was, or something like a string #REF!&"\This is what it was"
    Regards
    Brian

    8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. 156 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    40 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Array Formula - allow us to type the curly braces instead of CSE (and make them persistent when i edit formula!)

    currently we have to use Ctrl-Shift-Enter. What an odd concept. Please make array formulas easy to enter just like any other formula. Either let us type in the curly braces, or add something like ARRAYFORMULA(......). At least, PLEASE make the array formula persistent. Currently if I (or any other user) even looks at the formula, they can easily break it just by pressing enter.

    8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Support for SQL statements

    There are lots of times that I've had to create really complex formulae or macros just to replicate the equivalent of simple SQL statements (e.g. select * from range where xxx=yyy).
    Would it be possible to include SQL statements as a new type of formula?

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Extended IF formula

    I'd like to see the IF formula extended to 3 arguments: true, false, error.
    So we don't need to use iferror, if(iserror(, etc. and input a formula twice.
    The default result for the third argument 'error' should be "", but should be adjustable ad libitum.
    This new If argument prevents the construction of any error-handling in other formulae.

    17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow Tables to be referenced by name from another workbook

    Currently you can reference an Excel table by name from an external workbook and the reference works while the workbook with the table is open. As soon as the table is closed, however, the formula returns an error on recalculation.

    Allow tables to be referenced from external workbooks, similar to how named ranges are. Unfortunately setting a named range equal to a table as a workaround doesn't work.

    11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. vlookup for 2nd, 3rd, etc occurrance

    How about something like =VLOOKUP(lookupvalue,tablearray,colindexnum,range_lookup,occurrance) like =VLOOKUP(123,A1:B100,2,FALSE,3) where the 3 means to return the 3rd occurrance of the lookup value. Of course, #N/A if there isn't one.

    10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. vlookup should treat the lookup value as it APPEARS

    If you VLOOKUP (or HLOOKUP) 123 (or a range containing 123) into a range which clearly has 123 in it, but the latter is formatted as text, it doesn't find it. If it LOOKS right, it should find it!

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. ARRAYFORMULA

    In addition to Ctrl+Shift+Enter (and remembering to do this after modifying an array formula) provide another way like the Google Sheets ARRAYFORMULA. This has advantages like seeing that it is an array without looking for curly brackets, and not having to CSE.
    In fact you should definitely review all the functions of Google Sheets that are not available in MS Excel as candidates for inclusion. https://support.google.com/docs/table/25273?hl=en&rd=2
    Regards
    Brian

    17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Sequence function Numeric Run

    Instead of futzing around with things like ROW(INDIRECT("1:"&Len(A1))) and Column and Transpose in order to construct certain array formulas which need runs like 1,2,3,4,...., provide a Seq array function.
    Seq(from,to[,step][,Horiz/Vert]). Also make it imply an array function like does sumproduct.
    REgards
    BRian

    8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Extract groups of numbers or characters from Text

    A frequently occurring problem is how to extract groups of digits or characters from text.
    We need a new function something like this:

    - Extract groups of characters from a text-string
    
    - Allow the user to define what constitutes a group of characters
    - Extract the Nth group from the start, or the Nth group working backwards from the end
    - Option to specify the maximum number of characters to extract from the front or the back of the group
    - Option to give the start and/or end position within the string for the search for groups.

    GROUPS(Text, GroupNumber, MaxChars,…

    13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. VLOOKUP with exact match and sorted data

    VLOOKUP formulas where you want an exact match are often accused of being slow, especially when the lookup table has a large number of rows and columns. And if you have a lot of VLOOKUP formulas, changing a value in the lookup table can result in an annoying delay while all the VLOOKUP formulas using that table recalculate.

    In many cases, the user would be willing to sort the lookup table by the first column--provided that led to a significant improvement in recalc time because of a binary search. The problem is that setting the fourth VLOOKUP parameter to TRUE…

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Allow date literals in functions

    Many functions like VLOOKUP, SUMPRODUCT, and IF allow dates as inputs, but you need to know the tricks for doing so. The result is a never-ending series of questions in help forums from newbies who just don't understand why their formula isn't working.

    If you enter 1/15/2015 in a formula, it is treated as the small number resulting from two successive divisions instead of a date. If you enter Jan 15, 2015 in a formula, it results in an error--and if you encapsulate it in double quotes "Jan 15, 2015" if is treated as a text literal. My current workaround…

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Shift+Click to select $A$1 and Click to select A1

    When writing the formula:

    =$A$1+A2

    Traditionally we (can) click cell A1, type +, click cell A2, then go back and edit A1 to include the $ signs.

    It would be super helpful if holding Shift while clicking automatically filled in the $A$1 when selecting cells.

    19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Protect me from #REF! ambushes

    Every so often I delete cells and unbeknownst to me create a bunch of #REF! errors in another part of my worksheet. I may not realize until much later when I can no longer undo back to fix the error. Excel could spare me this. If my deletion is about to create #REF!s it should bring up an alert like "Other cells depend on the cells you are about to delete. Would you like Excel to adjust their formulas to avoid #REF! errors? [Yes][No][Cancel]. [No] would do what it does today. [Cancel] would abort the operation. [Yes] would smartly substitute…

    124 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add real multiline editing with auto-indentation to the formula editor

    Formulas today are increasingly complex especially since the character limit has been increased. It's common to see many nested functions that are difficult to read unless pasted into Notepad and separated by line breaks with logical indentation. Why not have the formula editor incorporate multiline display with automatic indentation like other code editors?

    31 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Add an IN() function to check for existence of a value

    Right now, I often use formulas like this:

    =IF(COUNTIF("A", myRange)>0, ..., ...)
    

    It's be handy to be able to just use:

    =IF(IN("A", myRange), ..., ...)
    

    This could also help with formulas where a number of different criteria are allowed:

    =SUMIFS(B:B, A:A, "2016") + SUMIFS(B:B, A:A, "2013") + SUMIFS(B:B, A:A, "2010")
    

    becomes

    =SUMIFS(B:B, A:A, IN(A2, "2016", "2013", "2010"))
    

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  20. GUI IF builder

    Creating a GUI/ menu to build IF statements. It would have fields to enter your reference, condition type (e.g., =, <>), test value, value if true, value if false and ability to nest IF when true/ false.

    Ideally you could select a cell with an IF statement and open the GUI and it will break apart all the nested IFs for you. Could be very helpful for people who aren't strong Excel users or for people troubleshooting complex nested IFs.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base