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.

    530 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 →
  2. Let add setting to switch gridlines on/off

    Now we can do that for current worksheet only. These days it's quite desirable to have an option to keep greedlines off on permanent basis for each new workbook. That could be done using template or by changing/adding registry key https://www.quora.com/What-are-some-ways-of-removing-gridlines-in-Excel-2007.
    That will be much more suitable if we have such option in Advanced section of Options.

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

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  3. sheet tabs

    currently the amount of characters allowed per tab is 31 maximium. THIS IS NOT ENOUGH. please make an option to extend the amount to at least 100. If you do this you are good. If you don't you are bad. It is that simple.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  4. Page Setup - Header/Footer - combined feature requests

    This idea combines a host of ideas which all call for similar functionality. The individual postings score minimal votes but together they add to 75 votes. I raise this to combine the feature requests, so that it gets prominence as I would dearly like to see this addressed.

    Features for the Header / Footer:
    1. include variables based on a cell reference
    2. more than one Picture and Shapes
    3. Print and save dates
    4. Number of pages of the sheet and of the workbook
    5. Add file properties (quick parts in Word)
    6. Option for the header/footer on the…

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

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  5. Formatting duplicate values through a slash / Форматирование повторяющихся значений через слэш

    Eng.
    Everything is visible in the screenshot.
    The text format of the cells is used so that there are no conversions of numbers to date, while formatting duplicate values is worth filling in red. According to the “opinion” of MS Excel, the numbers 1/1 and 1/20 are the same, 1/2 and 2/20 are the same, etc., the relationship is direct.
    This error exists only with the numbers of the series 1 / X and X / 20, [1 <X <12], X is an integer.
    If my record is not clear to someone, then this is how pairs of "repeating" values…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow conditional formatting for spilled array formulas

    I use an array formula (e.g. RANDARRAY) to insert some numbers. The size of this array may vary, as the array formula is based on cells with values, which may vary.
    In the spilled array I want to highlight some values using conditional formatting. It would be useful, if the conditional formatting could be based on the size of the array, so that the area the conditional formatting applies to shrinks and grows with the size of the array.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  7. Make the Conditional Formatting Rules Manager window adjustable

    Can the window on the Conditional Formatting Rules Manager be able to be adjusted so I can see more of my rules?

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. Entering Dates after 2030

    I'm entering dates going out to 2032, and when I enter dates like 10/1/32, Excel is changing the date to 1932. Excel should be defaulting to 2032 like it does for dates in the 2020's.

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

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. Phone number formatting

    There should be a drop-down choice in formats the provide a formatting especially for phone numbers that can cope with +61 without trying to treat it as an equation and leaves the leading zero as is. Also you can click and dial from there if you have a phone function on you PC like cisco jabber.

    formatting should assume your number is in the same country as your timezone. It should offer some choice of format i.e. +61 456 654 456 vs 0456 654 456.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  10. Double-clicking the border of an empty column should reset it to default width

    As it sounds: If the column is empty, the automatic sizing when you double-click should make it the default width instead of doing nothing.

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

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. Dynamic Arrays, Spill range format

    When a Spill range changes (eg due to the source data changing) it would be nice if any Formatting that is applied to the Spill Formula Cell is also applied to the entire Spill Range.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. Create a cell format for CUSIPs

    Given the ubiquitous use of Excel among Finance professionals, it is a pain to type in CUSIPs (9 digit unique identifiers of securities), as if the security has an "E" as the 2nd or 3rd last character (which is more often than you think), it automatically converts to scientific notation. If Excel could add a special "CUSIP" format where this didn't happen, that'd be a game changer for an entire industry

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  15. Create a transparent text colour

    So you can maintain formulas in cells you maybe don't want shown (onto power point for example) without having to colour the background and text the same colour.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. Needed to fix copy paste the tables from excel to outlook

    Copying from excel to Outlook (or any other app) should keep the content and format, borders, alignment of the cells. It takes so much time to adjust everything after pasting data into an Outlook e-mail, for example...

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. have an 'A' number formatting option as adding machines do, so don't have to enter '.' all the time.

    know excel was to be scientific, but bet it is used in 'financial' spreadsheets more than inventors could have envisioned.
    'A' on adding machine, means 12 equals 12.00 saves 3 keys

                                                    12.1               12.10  saves 1 key
    
    1210 12.10 saves 1 key
    12.10 12.10 saves 0 keys

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  18. Make Scientific values a background feature or at least, add the option to disable it. Please.

    Large Numbers are used in for documentation and inventory when using excel. The scientific notation feature causes confusion and frustration. Can you put an option to disable the scientific notation feature in the Options menu, for those who use excel for inventory and documentation.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  19. Make URLs automatically turn into clickable hyperlinks

    We often export from Power BI into Excel, and the URLs are not automatically clickable hyperlinks. Please make this data automatically hyperlinks.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. Can you please give the users freedom to change icon colors while using conditional formatting. This is cruel to not give format icon set op

    Can you please give the users freedom to change icon colors while using conditional formatting. This is cruel to not give format icon set option

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 40 41
  • Don't see your idea?

Feedback and Knowledge Base