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. Remove the lock symbols from the tabs of protected sheets

    Microsoft appears to have added this as a new 'feature' in Version 2006 (Build 13001.20266 Click-to-Run) and it's a disaster. For a workbook with a large number of protected sheets the visibility of sheet tabs is reduced by ~ 30%, thereby greatly reducing user-friendliness and the ability to navigate around the workbook using sheet tabs.

    I've attached a screen grab of a basic model containing protected sheets which has lost visibility of at least 3 sheet tabs as a result of the unnecessary and unwanted lock symbols on almost every sheet.

    This 'feature' needs to be removed or made optional…

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

    We’ll send you updates on this idea

    67 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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.

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

    We’ll send you updates on this idea

    62 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add a Split dynamic array function

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

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

    We’ll send you updates on this idea

    26 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. List sheet names vertically in a scrolling list sidepanel

    The current way of navigating sheets is extremely slow and strenous and should be obsoleted and replaced with a vertically scrollable list sidepanel without the need of 3rd party add-ins.

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

    We’ll send you updates on this idea

    3 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  5. Money in Excel: Multiple Accounts Per Institution

    It's very common for a couple to both have accounts at one institution, but want to track data together. Unfortunately I can't use Money In Excel until this feature lands.

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

    We’ll send you updates on this idea

    18 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Money in Excel team here! Currently, this is the most upvoted request—we hear you! This is something we are actively working on since launching last month. We do not have an exact ETA yet. Just know that we are working on it along with many other features. One thing we can do, is circle back and let this thread know once it’s released. Keep giving us feedback, we appreciate all of it. Be safe!

  6. 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.

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    12 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  8. Correção na documentação da função SOMA

    Correção na documentação da função SOMA.

    Correção da documentação na função SOMA, como neste exemplo anexo informa que se deve informar de 1 a 255 "números" mas que na verdade são argumentos, podendo dentro delas constar números, célula, intervalo de células, funções ou fórmulas e não somente números, para um usuário que está começando e lê isto pode, e já
    foi presenciado, inserir de forma manual números nos argumentos por não ter o conhecimento e não estar especificado de forma correta a diversas formas que pode ser aplicada.
    Como sugestão alterar o "núm1;núm2"... para arg1;arg2... e de 1 a 255…

    30 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. 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…

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

    We’ll send you updates on this idea

    7 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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…

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

    We’ll send you updates on this idea

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

    71 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 →
  12. Release XLOOKUP to the world!

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

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

    We’ll send you updates on this idea

    64 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. "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!

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

    We’ll send you updates on this idea

    8 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  14. Display pivot table headers in the columns headers

    With the tables, if the header is not visible, Excel displays the headers of the table in the columns headers (see the picture attached)

    It will be great to have the same behaviour with the pivot tables

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

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  15. Money in Excel - Import Transactions

    In Money in Excel, it would be nice to have the option to import transactions. I have transactions I would like to include in my spreadsheet, but they aren't able to be imported via Plaid.

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

    We’ll send you updates on this idea

    3 comments  ·  Macros and Add-ins  ·  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?

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

    We’ll send you updates on this idea

    5 comments  ·  Product Setup and Activation  ·  Flag idea as inappropriate…  ·  Admin →
  17. Money in Excel should allow manual entry of transactions.

    Money in Excel should allow manual entry of older transactions so that the whole year's transactions can be contained in 1 sheet. Right now Money can only import about 90 days of transactions and January and February are missing from my transaction log.

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

    We’ll send you updates on this idea

    4 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  18. "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.

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

    We’ll send you updates on this idea

    29 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Stock Data Type - Stock Data for Indian Stock Exchange - NSE

    To update the stock data type with Indian stock stock exchange rates which will helpful..

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

    We’ll send you updates on this idea

    6 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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:…

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

    We’ll send you updates on this idea

    8 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 354 355
  • Don't see your idea?

Feedback and Knowledge Base