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.

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

    We’ll send you updates on this idea

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

    99 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 →
  3. Add a Split dynamic array function

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

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

    We’ll send you updates on this idea

    30 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. A Better Spell Checking in Excel

    🇺🇸 A good spell checker is important in any software. In Microsoft Word, it's a classic. In the modern web browsers, the dictionaries are there to help us write better as we type.

    Excel should have the same ability to highlight our errors, as shown in the image:


    🇧🇷 Um bom verificador ortográfico é importante em qualquer software. No Microsoft Word, é um clássico. Nos navegadores da web modernos, os dicionários estão lá para nos ajudar a escrever melhor à medida que digitamos.

    O Excel deveria ter a mesma capacidade de destacar nossos erros, como mostrado na imagem:

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

    We’ll send you updates on this idea

    1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  5. Use new dynamic arrays in data validation

    The use helper columns in tables now often is unnecessary if using the the new dynamic arrays. But if I want to use the output of one of the new functions as the source for a data validation list, I need to put the function in a cell and reference to that cell as the source for the data validation list. I would like to be able to put the dynamic array function directly into the source field of the data validation dialog.
    Example: I have a table with a column of countries. I want to add a cell with…

    33 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 →
  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.

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

    We’ll send you updates on this idea

    38 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. There are Duplicate Shortcuts For Converting a List into Table, Let's use one them for another functionality

    A Table has a lot more functionality than a List. Although there are 6 different ways of converting a List into a Table, Excel users find it easy to do that with a shortcut. Surprisingly there are 2 shortcuts performing the same exact task:
    CTRL + T (T stands for Table) or CTRL + L (L stands for List)
    Why should we reserve 2 shortcuts for the same action? let's keep only the relatively new one CTRL + T (users are familiar with this one)
    While Assign the older shortcut CTRL + L to copying to the left (L stands…

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    14 comments  ·  Product Setup and Activation  ·  Flag idea as inappropriate…  ·  Admin →
  10. Make Excel obey the "scroll inactive windows" setting in Windows 10 (resubmitted Aug 2020)

    Make Excel obey the "scroll inactive windows" setting in Windows 10. Currently Excel will scroll when it is an inactive window, but it will not allow other windows to scroll when it is the active window. This makes transcribing data from a source that needs to be scrolled difficult.

    This idea was apparently fixed in 2018 (link below) but perhaps something broke it, as it is present at this time, evidenced also by the long comment thread in the "completed" item.

    Please fix this again.

    Link to item marked as "completed":
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/16030891-make-excel-obey-the-scroll-inactive-windows-sett

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

    We’ll send you updates on this idea

    4 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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…

    33 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 →
  12. 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…

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

    We’ll send you updates on this idea

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

    112 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 →
  14. There is No direct command for clearing the Data Validation on the Ribbon

    Everyone is using Data Validation in Excel for simple or complex projects. However if you decide to clear your data validation rules there is No direct command on the ribbon to do that: So you have to go to the Data Tab >> Open the data Validation dialog box >> Click on Clear All >> Close the dialog Box.
    My suggestion is to integrate this functionality with the Data Validation button in the ribbon (as explained in the attached Graphic) which will enable the user with a click to either clear Data Validation from a selected range or from the…

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

    We’ll send you updates on this idea

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

    88 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 →
  16. 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

    36 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 →
  17. "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!

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

    We’ll send you updates on this idea

    9 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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.

    29 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 →
  19. 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.

    23 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 →
  20. True Dark Mode

    Actually make the dark mode for Excel change the working document's background colour black/dark without needing to format.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 375 376
  • Don't see your idea?

Feedback and Knowledge Base