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. A formula for fiscal year started from month

    A formula to calculate Fiscal year based upon starting month. The result can be Fiscal month serial number and year in the format YYYY-YY(+/-)1. For Example. Fiscal year starting from April the formula FiscalYear(13-6-2020,4) should return "3/2020-21" or something like this.

    2 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 →
  2. Date picker button for excel in offfice 365 for Windows 10 64 bit

    I am so surprised that there is no Date picker function available in Excel 365. I see that this function existed and has been removed. this makes no sense to me what so ever. This is what has been pushing me away from Microsoft. This is why I have stopped using One note ( due to feature removals) and seek other options as you just cant rely on such thing.

    I feel less protective of Windows/ MS at home and hence Apple and Google devices have started replacing MS specially by Kids. Surface pro 4 was highly disappointing. So now…

    2 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. [Excel Currency Conversion Function] add Tezos XTZ (Cryptocurrency)

    Please add support for Tezos in this function.
    Tezos is very popular and provides formal verification for Smart-Contracts, on-chain-Governance and it is the first Blockchain which is amendable (without the need of so called "Hardforks"). Ticker symbol is $XTZ.

    50 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. Be able to add a "Full Name" field with a specific button.

    Being able to highlight the first and last name column and click "Add Full Name"

    1 vote
    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 →
  5. Anchor period during formula entry.

    Upon upgrading to Excel version l 365 16.0.11328, I lost the ability to anchor formula ranges with the period key instead of the colon. Prior to this version, hitting the period would insert a colon so that I could complete a cell range. Could this functionality be added back to the "Transition Navigation Keys" option?

    Having started with Lotus 123 back in the 1980's, I still use "Transition Navigation Keys." Using the period during formula entry has become second nature and is embedded in my muscle memory. Please kindly consider this for your more "seasoned" Excel users.

    15 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 →
  6. Excel Sum Function is truncating trailing zero's while pasting Sum from one cell to another

    Steps to reproduce the bug:


    1. Create Sum of 2 or more cells with numeric values - Ex. A4 = Sum(Sheet1!A2+Sheet2!A3)

    2. Copy the formula and paste it to other cells, so that it can take values from respective cells and create summation. Ex. Pasting Sum in B4, C4, D4...B12, C12, B15 etc.

    3. While pasting, its working correctly for B4(i.e. Sheet1!B2+Sheet2!B3), also for B15(i.e. Sheet1!B13+Sheet2!B14) where there the cell numbers are not ending with 0s.

    4. Its not working correctly for B12(it should be Sheet1!B10+Sheet2!B11) instead it is pasted as Sheet1!B1+Sheet2!B11. This is wrong. This is happening especially when we sum across sheets
    1 vote
    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. COLUMNA() returns the letter(s) where as COLUMN() returns a number

    column() is great, as usually we want the column NUMBER

    BUT when you want the column LETTER(s), something like

    COLUMNA()

    could return it.

    I know you can use
    =SUBSTITUTE(ADDRESS(1,COLUMN(A1),4),"1","")
    but it's pretty long-winded...

    to clarify
    =COLUMN(AB1) returns 28
    =COLUMNA(AB1) returns AB

    10 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 →
  8. Deprecate VLOOKUP & HLOOKUP (make them Compatibility functions)

    VLOOKUP and HLOOKUP use a lengthy, unintuitive syntax and have been superseded by XLOOKUP. They should be used only when a spreadsheet might be used on a version of Excel that does not support XLOOKUP. To help promote the best practice of using XLOOKUP, please deprecate VLOOKUP and HLOOKUP by making them Compatibility functions.

    In cases where VLOOKUP and HLOOKUP cannot be converted to an equivalent XLOOKUP expression (e.g. dynamic 3rd argument), they can still be converted to an equivalent expression using INDEX and XMATCH, so users are not missing out on any functionality from not using VLOOKUP and HLOOKUP.

    1 vote
    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. translation funtion

    It would be a great time saver if there was a translation function that worked like a reference function. Especially if you work internationally and have to enter 2 languages in e.g. a list to make it easier to understand, this function would be very practical, because you would have to enter it once and then you could transfer it to the other cells.
    For example: column A is German and column B should contain the corresponding English translations. Instead of having to translate everything manually, a function would be simpler here, which would transfer the following information: If A1…

    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 →
  10. You need a single command or function that gives just the name of the file.

    You need a single command or function that gives just the name of the file.

    1 vote
    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 →
  11. Fix =Z1 when Z1 = "" should return "" not 0, No work around w/ Dynamic Arrays

    There has been a longstanding issue as follows. When referencing a cell (e.g. formula in cell A1 is "=Z1") and Z1 is blank/"" then the value returned in A1 is 0 (not blank/"" as expected). The work around for this has always been to change the formula to =Z1&"".

    The problem is now with Dynamic arrays this is not possible. Create a table with 3 columns, first 2 columns are a text values and 3rd column is a date or numeric. The write a dynamic array function =FILTER(Table1,Column2<>"Y"). The spilled array will return a 0 in column 1 or 2…

    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 →
  12. Make copying Formulas simpler when there is only one reference change

    So when carrying a formula such as=(PPMT(B1/B3,A7,B2B3,B4) and the line below needs to be(PPMT(B1/B3,A8,B2B3,B4) it would be nice if Excel could pick up on the fact that the only change in the formula is A7 to A8 to A9 and so on without changing any of the other cells column and row identifiers as they are constants and don't need to change. This has been a huge time consuming issue for me and I have attempted to find ways around having to copy the formula and then manually change the one cell number as it wants to carry…

    1 vote
    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. Reverse FIND and SEARCH functions to search from the right

    Add functionality using the start_num as negative to search from the end of the string.

    FIND("123","123123",-1) would return 4
    FIND("M","Miriam McGovern",-1) would return 8

    This would help in parsing filenames that include paths, for example.

    7 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. Create a function that sets a cell.

    Create a function that sets a cell. It should look like this: SETCELL(cell,value)

    1 vote
    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 →
  15. F9 on =MIN(ROW()=ROW()) leads to wrong result

    I'm using Excel 365. I enter =MIN(ROW()=ROW()) in a cell, mark the content of the cell and press F9 to caluculate the formula. The result is 0 even it should be 1. Interestingly, the cell itself calculates correctly meaning entering the formula and hitting Enter leads to the correct result.

    2 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 →
  16. Please add a function to ignore the part of formula that directs to a blank cell!

    If a user has option of 20 preferences and he chooses to select only 2 , there should be a function to ignore the other preference cells which have formulas but are blank! this will shorten the formula for the output that is based on preference selection.
    Maybe a cell could have an option to be deemed "ignore" if It doesnt have value input in it, even if it has a formula.

    1 vote
    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 →
  17. IN SUMIF AND SUMIFS THERE IS NO WAY TO ESTABLISH AN OR CRITERIA

    You can meet an AND type of criteria in sumif and sumifs functions, but you can't establish an OR type of match. For example, if you want to sum the sales from John and Paul in the same sumif, you can't do it, you have to sum two sumifs to get this done. There should be a way to put an "OR" definition within the sum criteria of the function like something like this: sumif("a1:a100","john,paul","b1:b100") separating the "OR" criteria with comas inside the criteria or you could explicitly put the OR sentence like this: sumif("a1:a100","john OR paul","b1:b100"). In the case…

    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 →
  18. Modificación para función LET(...)

    Buen Día.
    Sobre la función LET().
    ¡Por favor les suplico que añadan un primer argumento NombreDeLaFormula!
    LET(NombreDeLaFormula;Variable;Valor;...;Formula)
    De esta forma sería posible hacer referencia a ella en otras fórmulas por su nombre y además da una pista imprescindible para poder entender mejor de que va dicha fórmula sin tener que asignar un nombre a la referencia.
    Con ello quedaría "casi" perfecta.
    =LET(VolumenParalelepipedo;x;VarAncho;y;VarLargo;z;VarAlto;x * y * z)
    =LET(x;VarAncho;y;VarLargo;z;VarAlto;VolumenParalelepipedo;x * y * z)

    1 vote
    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 →
  19. Google Sheets QUERY() equivalent?

    I would welcome a straightforward, SQL-like function to build complex queries, similar to Google Sheets QUERY(). For me, building complex filters with multiple criteria in Excel is frustratingly difficult. This is especially true when attempting to emulate SQL's WHERE, IN, LIKE, GROUP BY, and HAVING.

    For the record, I'm referring to built-in filtering (querying) of data within Excel tables, not passing SQL statements to connected SQL data server/connection.

    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 →
  20. randarray in tables

    RANDARRAY does not work in Excel tables. It results into #SPILL!
    Would be nice if RANDARRAY did work int tables.

    1 vote
    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