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. Pick color in Excel Like at Powerpoint

    In Powerpoint there is a color picker tool to bring custom colors to the pallete.

    Many times we need to do it using PowerPoint to get the RGB combination to be used in Excel.

    Could you replicate this color picker into Excel in the same way it exists in PowerPoint?

    Portuguese:

    Conta-gotas PowerPoint

    No Powerpoint existe uma ferramenta para pegar as cores e retornar para a paleta, o conta-gotas.

    Vocês podem fazer o mesmo no Excel?

    Porque muitas vezes nós precisamos fazer isso usando o PowerPoint para pegar o RGB e colocar no Excel.

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

    We’ll send you updates on this idea

    59 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  2. Option to allow add-ins in restricted workbook (IRM)

    The new Information Rights Management (IRM) is great to protect workbooks from being opened or edited by non authorized users.
    Unfortunately it also deactivates all ad-ins. In principle this makes sense as add-ins can access and modify information within the workbook. However, current restrictions go a bit too far as even as an owner/author of the workbook with FULL CONTROL my add-ins are deactivated. Should I not have full rights to do anything with the workbook? In our company thousands of users across EMEA use a self developed add-in to calculate service costs. Now they cannot use IRM as it…

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

    We’ll send you updates on this idea

    11 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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.

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

    We’ll send you updates on this idea

    33 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Translate XLOOKUP and XMATCH to PROCX and CORRESPX in Portuguese

    That's it: PROCX and CORRESPX in Portuguese versions of Excel to keep the same standard of the other functions.

    🇧🇷🇵🇹🇦🇴🇲🇿🇨🇻

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

    We’ll send you updates on this idea

    28 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Corrigir descrição da opção "Remover Duplicatas" no Microsoft Excel

    Corrigir descrição da opção "Remover Duplicatas" no Microsoft Excel

    No caminho Dados>Ferramentas de Dados temos a opção "Remover Duplicatas".

    "Duplicatas" no Comércio significa: "título de crédito nominativo pelo qual o comprador fica obrigado a pagar, em determinada data, a quantia correspondente à fatura de mercadoria vendida a prazo."

    Ao deixarmos o mouse na opção já aparece "Duplicatas" que está errado por fazer confusão ao comercio, e no texto em seu "balão" aparece como "Duplicadas", onde o seu único significado é "que ou o que se duplicou; que foi copiado por uso de artefato próprio ou manuscrito (diz-se de documento ou…

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

    We’ll send you updates on this idea

    5 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add a Split dynamic array function

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

    90 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 →
  7. 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…

    73 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. Release XLOOKUP to the world!

    Why only release to 15 percent of users?! Let the world have XLOOKUP and XMATCH now()!

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

    We’ll send you updates on this idea

    39 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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.

    42 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 →
  10. Error in the translation of the function description "PROCURAR" (MS Excel Pt-Br)

    On the Brazilian Portuguese version of Microsoft Excel (desktop and online versions), the "PROCURAR" function has a translation error on its description.

    The "PROCURAR" function description text uses the word "LOCALIZAR" instead of the word "PROCURAR", causing an error because "LOCALIZAR" is also another function.

    The description states that "LOCALIZAR" is case sensitive. The "LOCALIZAR" function makes no distinction. The more adequate use on this case would be: "PROCURAR" is case sensitive.

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

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  11. Please create a FILTERJSON (FILTROJSON) worksheet function

    Hi. How about creating a FILTERJSON function? It would make our life easier allowing us to get JSON data with less workarounds.

    Oi. Que tal criarem uma função de planilha FILTROJSON? Tornaria a nossa vida mais fácil nos permitindo obter dados em formato JSON com menos soluções alternativas.

    🇺🇸 English: FILTERXML --> FILTERJSON
    🇨🇿 Czech: FILTERXML --> FILTERJSON
    🇩🇰 Danish: FILTRERXML --> FILTRERJSON
    🇳🇱 Dutch: XML.FILTEREN --> JSON.FILTEREN
    🇫🇮 Finnish: SUODATA.XML --> SUODATA.JSON
    🇫🇷 French: FILTRE.XML --> FILTRE.JSON
    🇩🇪 German: XMLFILTERN --> JSONFILTERN
    🇬🇷 Greek: FILTERXML --> FILTERJSON
    🇭🇺 Hungarian: XMLSZŰRÉS --> JSONSZŰRÉS
    🇮🇹 Italian: FILTRO.XML --> FILTRO.JSON
    🇳🇴 Norwegian:…

    72 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 →
  12. "Excel found a problem with one or more formula references" - Please tell me where!

    One of my least favorite messages that Excel provides is:

    "Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."

    But I can never find the bad references. It's usually buried somewhere very deep, in a chart series formula, or in a name definition, or who knows where else.

    If Excel finds a problem, please Excel, tell us where it is.

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

    We’ll send you updates on this idea

    27 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Provide drop down list of columns where filters are applied with column's alphabetical label in brackets.

    This ties in with recommendations of others where they recommend changing the color of the filter button to easily identify filtered columns. Also consider providing drop down option or pop up option to list column names (with alphabetical label of column, such as (A), (B), etc). This will help to easily identify columns where filters are applied. You don't necessarily want to go to each column, but rather want to catch up with the logic / thought process you were busy with. Maybe some short abbreviated info about the values filtered as well.

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

    We’ll send you updates on this idea

    2 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  14. "Worksheet Sorter" for Excel

    A useful tool in PowerPoint is the "Slide Sorter" which allows you to quickly view, navigate and rearrange many slides. I think adding a "Worksheet Sorter" in Excel's "View" tab would be just as useful, and would make navigating 20+ worksheets much, much easier. If you agree with me please vote!

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

    We’ll send you updates on this idea

    6 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  15. Bring Power Pivot closer to Power BI Desktop Functionality

    Development for Power Pivot for Excel seems to have stopped around 2016. TREATAS got added as a DAX function that works, but it never got added to Intellisense, and that was nearly 3 years ago.

    Today, the two measure editors (still no idea why there are different ones) are a very VERY poor substitute for the fantastic DAX editor in Power BI Desktop. It is a real pain to properly tab and indent in the Excel Measure editor(s).

    In the last year there have been about a dozen new DAX functions and several updated functions per https://docs.microsoft.com/en-us/dax/new-dax-functions but NONE of…

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

    We’ll send you updates on this idea

    4 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  16. CTRL+M to launch Power Query Editor

    Well, we know that
    the language behind Power Query is called M;
    it takes at least three clicks to launch Power Query Editor;
    the shortcut CTRL+M is currently unassigned...
    Why not using CTRL+M to launch Power Query Editor?

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

    We’ll send you updates on this idea

    2 comments  ·  Product Setup and Activation  ·  Flag idea as inappropriate…  ·  Admin →
  17. User usage tracking

    Would be great to have a way to monitor the usage of an Excel File. working in Finance, many of the reports we produce can be used or not used. having a mechanism for a file author to get usage statistics would be super helpful. for example each time the report is being opened it pings the server and let the author know through a report sent weekly or daily (customizable).

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

    We’ll send you updates on this idea

    1 comment  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add Corkscrew function for dynamic arrays

    Corkscrew accounting is fundamental to Financial Modeling. It is where opening balances are carried over from closing balance of prior periods..

    =OpeningBalance(FirstPeriodBalance, PriorBalances)

    Where FirstPeriodBalance is the first period's opening balance and PriorBalances is an array of closing balances for each period.

    The cell containing this function will return FirstPeriodBalance. The SPILL range will contain the n-1 closing balance array value.

    https://corporatefinanceinstitute.com/resources/excel/study/corkscrew-calculation/

    10 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. Auto Protect/Lock Dynamic Table After New Entry

    Microsoft Excel my goal is to make the whole sheet uneditable and editable both at the same time.

    For instance, I'm using Table1 and with every new entry, one row adds up in the table, but the whole table is prone to risk of being mistakenly or deliberately removed/edited. I want to make a new entry (which will add a new row, aa usual) but the whole should remain protected/locked (unchangeable). Have i conveyed my point?

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

    We’ll send you updates on this idea

    3 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  20. In the case of Excel 2019 store app version, please fix the bug that the content of CSV file is displayed as text on the browser when you cl

    In the case of Excel 2019 store app version, if you click the link of the CSV file on the Internet in the browser, the contents of the CSV file will be displayed as text on the browser.
    If you reinstall the previous Excel or desktop version, the CSV file will open normally in Excel, but please fix the bug so that the store application version of Excel 2019 will also open in Excel as well.

    タイトル(日本語):Excel 2019 のストアアプリ版の場合、インターネット上のCSVファイルのリンクをブラウザでクリックするとCSVファイルの内容がブラウザ上にテキストとして表示されてしまう不具合を修正して欲しい。

    本文(日本語):Excel 2019 のストアアプリ版の場合、インターネット上のCSVファイルのリンクをブラウザでクリックするとCSVファイルの内容がブラウザ上にテキストとして表示されてしまいます。
    以前のExcel、もしくは、デスクトップ版を再インストールすればCSVファイルが正常にExcelで開かれますが、Excel 2019 のストアアプリ版でも同様にExcelで開くよう不具合を修正して欲しい。

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

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 306 307
  • Don't see your idea?

Feedback and Knowledge Base