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. Vlookup returns 0 when looked up cell is blank

    could you provide that if the cell to be returned in a vlookup or hlookup formula is blank, then the value of the formula also resolves as blank - or have this as a choice, e.g. Vlookup(c1,A1:b5,2,false,"") where "" = the value to be returned if the looked up cell is empty. The default could remain 0 if this is omitted from the formula.

    7 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 →
  2. Add Google Docs Like Unique Function

    A formula to provide the unique values in a given range - takes one argument, the range to filter.

    6 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 →
  3. Sum non-contiguous data based on cell format (ie fill, font color)

    Please enable SUMIF function to sum non-contiguous data in a range based on cell format (ie fill, font color)

    11 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 →
  4. Be able to use functions (eg. Concatenate) in chart titles.

    Be able to use functions (eg. Concatenate) in chart titles.

    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 →
  5. 6 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 →
  6. Add optional parameter to TRIM function to support LTRIM and RTRIM

    The TRIM function removes leading, trailing, and internal spaces. It would be so helpful if it had an optional second parameter that allowed the following options:
    -1: remove leading spaces
    0: remove leading, trailing, and internal spaces (default)
    1: remove trailing spaces
    2: remove internal spaces

    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 →
  7. formulae for column letter to number & vice versa

    I know there are existing options, but they are long-winded. Surely adding 2 very simple and memorable formula like the below would help plenty of people:

    =COLNUMBER("D") would return 4

    and

    =COLLETTER(4) would return D

    8 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 →
  8. Presentation of Nested Formulae

    Debugging complex nested formulae and functions within a single cell can be difficult and requires a careful check to be kept on the level of parentheses. As an additional formula auditing tool, instead of presenting a formula in a single line it would be much clearer to present each level of nesting (parentheses) on a lower row. Like this the top level function is presented in the top row, the first level of nesting at the same position along the row the but dropped down a row, etc. so that the formula steps down a row (and up again) as…

    9 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 →
  9. A function to return the target address (URL) of a HYPERLINK cell

    Currently we have to create a user-defined function to get the URL address from a cell containing a hyperlink.

    e.g. rangeObj.Hyperlinks(1).Address

    Perhaps adding to the existing CELL() function?
    =CELL("hyperlink","A1")

    When copy/pasting data from websites to Excel the hyperlinks are retained but can't be extracted. (If Power Query Web tables could bring the hyperlinks in too, that would be helpful. Perhaps as expandable column with the displayed text.)

    22 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 →
  10. New *IFs function to accept any aggregating function

    The *Ifs functions are very popular among excel users, it seems like every new version of excel adds a few more of these functions,and I see a bunch of requests on here to add even more. perhaps the best approach may be to combine them into a Ifs function to rule them all.

    it would be similar to existing IFS functions, but the first parameter would let you define what to do with the matching data.

    e.g. =Sumifs(A:A,B:B,E1,C:C,F1) could become =NewFunction("Sum",A:A,B:B,E1,C:C,F1)

    =Averageifs(A:A,B:B,E1,C:C,F1) could become =NewFunction("Average",A:A,B:B,E1,C:C,F1)

    this would allow the creation of new IFS functionality like StddevIfs, VarPIfs, MedianIfs, ModeIfs, ProductIfs…

    14 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 →
  11. Excel Currency conversion

    Currency conversion online just like google spreadsheets function =GoogleFinance("CURRENCY:USDEUR")

    5 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 →
  12. being able to select a large number of formulas and lock every =ColumnRow to =$Column$Row with the push a button would save time.

    Being able to change a large number of selected formulas from relative to the formulas being locked on the column and row each formula references; with the push of one button would save a great deal of repetitive find and replace time.

    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 →
  13. Make INDIRECT works with closed workbook

    Make INDIRECT works with closed workbooks!

    9 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. Function to convert UNIX timestamps to Excel dates

    It would be really useful to have a function that could convert UNIX timestamps (number of seconds since 1/1/1970 00:00:00) to an Excel time/date. UNIX timestamps are very widely used in the world of computer science and embedded systems, and being able to process them easily in Excel would be a big win.

    The function should handle non-integer values, to allow us to use it with e.g. JavaScript timestamps (which are the number of milliseconds since 1/1/1970).

    5 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 →
  15. Sort Function

    We need a SORT Function - Like So
    =Sort(Range/Array,SortCol,Order)
    This should be able to handle both 1d/2d Ranges / Arrays and return an array of Sorted values of the same dimension
    It should be based on a very fast sort algorithm

    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 →
  16. Add functionality to vlookup the last column in the array so we dont have to count columns

    When we use the vlookup function, the column number to return must be known, but more often than not, we return the rightmost column. So it would be nice if we could just type "LAST" in the function instead of a number which returns the last column.

    vlookup(A1,Array,LAST,0)

    Applies to hlookup too.

    5 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 →
  17. SUMPRODUCTIF AND SUMPRODUCTIFS

    Allow and extension of the SUMIF/SUMIFS and SUMPRODUCT function to be SUMPRODUCTIF or SUMPRODUCTIFS where excel will perform the sumproduct function on the rows that meet the criteria.

    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 →
  18. Trace Precedents, Trace Dependents, and Remove Arrows should be integrated into the Undo stack, not clear it

    For example, use the formula =A1 in B1. If you use Trace Precedents on B1 or Trace Dependents on A1, you will lose your Undo history. If you make further edits and then use Remove Arrows, you will also lose your Undo history. My suggestion is that these actions should be Undo-able. That is, they should be integrated into the Undo stack rather than clear it.

    28 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 →
  19. image function similar to google spreadsheet

    Need an image function similar to google spreadsheet which displayed a linked image without actually embedding the image into the spreadshee

    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 →
  20. office 365 vs office 2016 professional plus

    can the new features that are available in office 365 professional plus be added to office 2016 professional plus? features like https://blogs.office.com/2016/02/23/6-new-excel-functions-that-simplify-your-formula-editing-experience/

    8 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