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. Change external file links with the INDIRECT() function without having the file open

    Currently the INDIRECT formula is limited in that we cannot use it to link to other files that are not currently open. If I have multiple files that are named the same except for a unique identifier (AA forecast model, BB forecast model, CC forecast model...) I should be able to use INDIRECT to change the file links.

    Example of what should exist:

    Assumption is the Cell A1 = "AA"

    ="L:\Drivename.drive"&INDIRECT(A1)&"forecast model.xlsm"

    27 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 →
  2. Use F4 key to lock reference in a table

    When you create formula with the named range of a table, you can't easily block the reference of your column.

    For instance, if you used the fill-handle to copy to the right, the reference of your column will change :( The only way to avoid that is to write [[column1]:[column1]] for all your reference (very annoying)

    So my suggestion to block the reference of a named range is to use the F4 key.
    Your formula is =SUM(table1[column1]) and after pressing F4 it becomes =SUM(table1[[column1]:[column1]])

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

    We’ll send you updates on this idea

    17 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

    Best,
    John [MS XL]

  3. Need a "DELETE" function to work in a formula to automatically delete rows when a certain value exists in a cell

    I have seen, over the years, NON-automatic methods for this.

    I am asking if MS will please develop a new FUNCTION called 'DELETE ROW' that can and will AUTOMATICALLY delete a certain range of rows, if another cell contains a particular value or character.

    Everything I have seen that seems to suggest this functionality won't do it.

    And myself and about 98% of MS Excel Users no nothing about VBA (if that's the internal complex programmer's language). I am looking for an honest to goodness automatic Delete Row FUNCTION that will delete rows specified in a formula by itself, if…

    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 →
  4. Auto resizing of formula bar

    Give us an easily accessible option to have the formula bar resize automatically if a formula spans across multiple rows in the formula bar so the whole formula will be visible.

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

    We’ll send you updates on this idea

    18 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

    Cheers,
    John [MS XL]

  5. Support inline variables in formulas (similar to PowerPivot)

    As shown here:

    http://www.powerpivotblog.nl/dax-now-has-variable-support/

    In PowerPivot you can write inline variables like so:

    Future value variable =
    
    var Ratescalc = Productx(Rates,1+[Rates])
    var Revenue = [Sum of SalesAmount]
    return if (Revenue, Revenue * Ratescalc )

    The same ability in Excel would make the writing of an entire class of formulas much easier, such as the specific one mentioned here:

    http://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9785709-add-an-ifcond-function

    =IF([Formula]>5,5,[Formula])

    22 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 →
  6. Add a funciton to search in a string from the end (INSTRREV)

    Please add a formula that works like INSTRREV in VBA.

    (2016-03-08 Dan [MS] - updated title to include INSTRREV, when merging in duplicate idea)

    9 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 →
  7. Show intermediate values in formulas for troubleshooting.

    Show intermediate values in formulas. Add the ability to highlight a portion of a formula to see a tooltip showing the value... for example a value of 7 in A3 and a formula elsewhere with if(A3+4/2,"yes","no") highlighting the "A3+4/2" would show a tooltip of 9. Obviously a simple example, but it would help avoid disassembling complex formulas to troubleshoot.

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

    We’ll send you updates on this idea

    11 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Make all text-related functions work in textboxes

    Spellchecking, find and replace, and autocorrect all appear to be disabled in textboxes. Please make them work for all textboxes, including those inside other objects.

    Also, the line spacing function under the "Paragraph" drop-down command for textboxes should work in ordinary cells.

    4 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 →
  9. Root Mean Square Error (RMSE)

    Please add RMSE formula to statistical function library.

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

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Add an IFCOND() function

    similar to IFERROR, add a function that only evaluates second argument if first argument not met, like

    =IFCOND([Formula],">5",5)

    instead of

    =IF([Formula]>5,5,[Formula])

    This would make a lot of formulas much shorter and also improve execution time, as it would only have to evaluate [Function] once instead of twice if the condition is not met.

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

    We’ll send you updates on this idea

    13 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Integrate units into cells for display and mathematical operations

    Allow numbers to be displayed with text (without using the concatenate), while also being able still use the numbers/text for equations. Then units can be displayed (e.g.20 mm) and referenced to be operated on via another cell (e.g. 20mm*2+5 = 205mm)

    ---------------Keep reading if want more Details/explanation---------------
    Minimum way to implement would be to provide function to ignore all text for calculations (de-concatenate?) but then add it back in at the end (re-concatenate)...all in one function. This would be the quick and dirty method to get the low hanging fruit.

    Super slick way to implement would be to go a…

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

    We’ll send you updates on this idea

    10 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Prominent Manual Calculation Mode warning

    Given the great danger of not realising that calculation mode is set to Manual, it would be very beneficial if a "Manual Calculation Mode" indicator (in bright fire-engine red!) was displayed (and visibility maintained until calc mode is switched back to non-manual) in a prominent location - such as in the Title Bar to the left of the Minimize button.

    38 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 →
  13. Date/time stamp with auto update

    A means by which entering/changing data in a range would update a date/time stamp. It could be a simple function like TimeStamp(range). This would be hugely beneficial when for example working with a group of coworkers on a data table in a shared spreadsheet, allowing the team to immediately see what has been updated without forcing team members to manually enter a date/time for each edit.

    7 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 →
  14. worksheet function for returning a field inside a delimited lists

    I’d like to have a function available that returns a specified field within a delimited list. I would pass the list, a delimiter and a field number as arguments to the function and it should return the value in that field.

    For instance with the pipe separated list ”TEST1|TEST2|TEST3|TEST4| TEST5|||||||TEST|” in A1.
    I’d like to use something like GetFieldInDelimitedList(A1;"|";5) and have it return “TEST5”.

    Any equivalent formula will requires quite a lot of nested functions e.g.:
    =MID(A1,FIND("([])",SUBSTITUTE(A1,"|","([])",4))+1,FIND("([])",SUBSTITUTE(A1,"|","([])",5))-(FIND("([])",SUBSTITUTE(A1,"|","([])",4))+1))

    13 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 →
  15. Please a button to show all external file references

    Sometimes it is really hard to find out why Excel whinges about external file references. Would be nice to have a button to show where exactly each reference occurs.

    28 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 →
  16. string function which returns the number of occurences of a sub-string

    I regularly have comma separated lists, and would like to know how many values there are in the string. Currently do that in VBA, but it would be nice if there was a function for that. E.g.:
    A1 = "abc, def, pqr, xyz"
    B1 = PARAMS(A1,[optionally]",") optionally so that you can do ; or others as well

    5 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 →
  17. Numbers to text function

    We need a native Excel function, that read a number in a cell and then convert it in text.

    10 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 →
  18. To create a new function to Convert figures into letters

    A new function in order to convert a figure for ex. 2 into two, and more difficult as 1.350, 1.698.367 etc.

    2 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 →
  19. Extend VLOOKUP() and HLOOKUP()

    Extend the lookup functions so they can lookup left/up as well as right/down. That will save us having to build and maintain unintuitive formulae combining INDEX() and MATCH().

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

    We’ll send you updates on this idea

    17 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for taking the time to post a suggestion Malcolm! We’ll be taking a look at lookup functions. There’s a number of votes on the site for them – I’m not going to merge all of them though because different posts are asking for slightly different things. Please keep voting for the ones you want to see most!

    Cheers,
    John [MS XL]

  20. Create a function ISDATE(Data)

    Please, create a function ISDATE() to test if the contain of a cell is a date or not. This function exist in VBA but not in the Excel function. That's weird

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

    We’ll send you updates on this idea

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

Feedback and Knowledge Base