Feedback by UserVoice

Excel for Windows (Desktop Application)

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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. Marking values presented more that once in filter window

    While working with purchase specifications, the same positions in differens rows often appear with different quantities in each row which should be summed up for sending a request. It would be very convenient to have values corresponding with more then one rows marked by font, color, etc. in filter window…

    15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  2. Allow files to load from browser.

    Before the upgrade to Office 365 (I think) we had Office 2010. I was able to go to the file search window and select the file I wanted to open. A simple double click opened the file in Excel, Word, Power Point, or whatever.

    Now, the same action opens the application, but there is no file. I have to use the "File" menu within the program and search a second time to find the file and open it the long way.

    Please correct this error and do an update.

    Thanks,
    Kam

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  3. Allow left and right vertical axes to sync their gridlines

    Suppose we have a left and a right vertical axis. One axis could have, say, five labels and tick marks, and the other could have seven. But there's no way to synchronize those items so that their gridlines can overlap.

    To implement this, you could offer a check box that would synchronize the two axes, or you could allow us to specify the number of tick marks on each axis so we could synchronize them ourselves. Better yet, you could offer both options.

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  4. multiple case statements in switch function

    The new switch function is great. It would be even better if multiple case statements could be grouped together. Maybe SWITCH(expression,{value1,value2,value3,...},result1,{value4,value5,...},result2,...) or maybe SWITCH(expression,SWITCHOR(val1,val2,...),result1,...).

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add conditional TEXTJOIN

    There is a popular user defined function publishe on the web called CONCATENATEIF (http://stackoverflow.com/questions/22639868/vba-user-defined-function-for-concatenate-if-by-rows)
    It extends TEXTJOIN to include a conditional.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Excel doesn’t register .xltx as a file type it is able to open

    Excel 2016 no longer registers .xltx as a file type it is able to open. This is clearly an error.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Top 10 filter + extra selection of your choice

    It is not possible to compare some item in a group with the top x of the that group in the same pivot table. It is useful to give some context to that that item when we produce reports. e.g. top 10 economies by GDP + the GDP of Cameroon.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  8. Capability to resize Title bar, Tab names (of masked Ribbon) and Quick Access Toolbar

    Hello,

    Moving from Excel 2013 to 2016 lead to loose 1+ raw (same zooming) because Title bar, Tabs of masked Ribbon and Quick access bar are higher. This is a problem at least for these reasons :
    - Sheets sized to fit a sceen (2013) ... don't fit any longer
    - Screens height became smaller with 16/9 (cinema format) pushing us to scroll and scroll...Various bars (Title, Quick Access, Menu..) are now taking more space see hard copy leading us to scroll even more !

    It would be great to be able to resize (height, text and icons) these bars…

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  9. Generalize MINIF and MAXIF to be SMALLIF and LARGEIF

    The new conditional MIN and MAX formulae are great. Conditionalizing SMALL and LARGE would take this to the next level. A conditional version of SMALL based on the ordinary tool-set is very cumbersome.

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. [VBA] Shape color is not visible with Excel 2016, but is with Excel 2013

    I've made a code for studying function SIN and COS. It's like an analog clock that shows only second hand(Line shape).
    It works as expected with Excel 2013. But with Excel 2016, second hand(colored red) cannot be seen, only marks(both ends of Line) can be seen.
    I've reproduced this, in Windows 7, 8.1, and 10.
    --- my code ---
    ' --- for "Sleep" スリープ関数(API)の宣言
    Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

    ' ---[10] Analog Clock (display second hand) (アナログ時計・秒針を表示:サイン、コサインの練習)
    Public Sub prcShowAnalogClock()

    Call prc_Clear_Clock    ' -- delete Oval and Line already exist: 既存の円と直線を削除
    
    Application.ScreenUpdating = True
    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  11. Function Syntax

    I am applying formulas in excel by viewing the syntax which always
    For example : Sumif(range,criteria,[sum range])

    Everytime you press "," it highlighting in Bold which criteria you are mentioning.
    Now recently what I have found that if any sheet name contains any "," in it and you are applying the formula(example : sumif) from it, then it will not showing all syntax.

    Not sure if this is correct forum. but just found this issue and what to share if we can remove this bug.

    Regards,
    Rajender

    Regards,
    Rajender

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  12. Fix the "Auto-Save Has Been Suspended for this Session" bug

    Seemingly randomly, Excel will decide to pop up this error message. Once it happens, I know I'm screwed because any attempt to save the workbook will fail. The only way to prevent from losing changes is to copy them to a new workbook, save that workbook and then restart excel and copy changes back into the origin workbook.

    This happens with huge spreadsheets and small ones, and I've even seen it pop up when I was not interacting with Excel at all. I.e. I was in a different application at the time, so I don't have a solid repro. That…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Worksheet function like VBA.VAL()

    VBA VAL("10 items") gives 10
    Excel fn =VALUE("10 items") gives #VALUE!
    Of course I can use a UDF but I'd like a native function that returned the value of the first numeric characters of a string. Even better if it can get values inside text ("Total 10 items") but I can see problems with separated digits and dots and commas so a simple behaviour like VAL() will do, thank you.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  15. For technical users of Excel, we absolutely need more symbols in the charts. Double new symbols: simply flag all existing symbols.

    Simply adding "flags" to all existing symbols, with optional color and fill options (for the symbol), can create double the number of symbols currently available. This is needed for highly technical charts. Also, if the symbol choices were made at the time the data were selected, much time could be saved from adjusting the chart later. "Flags" are simply a 45-degree-line tick mark on the upper right side of the symbol.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the additional details. We’ll consider this in our future planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  16. Simultaneous file saving output.

    Usually I save one excel file into an htm and pdf format. and I have to repeat the process of saving. How about there could be an option where a user can save a file simultaneously to different outputs. In my case. If I could save my file as an html and pdf at the same time, that would be truly helpful in my work. Totally saves a lot of time.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  17. Structured reference for "all cells" rather than 1:1048576

    Sometimes in formulas but especially in conditional formatting, we want to refer to all cells of a sheet. The current notation of 1:1048576 has a few problems.


    1. It is not obvious that it means "all cells"
      Most people do not have the number of rows in a spreadsheet memorized.


    2. It is not futureproof
      Should Excel ever support more rows in the future, the notation 1:1048576 will lead to ambiguity. Did the user want conditional formatting on all cells or only those rows, which just so happened to be all cells at the time?


    3. It does not behave like other ranges…

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Show count of items represented by each checkbox in the Filter dropdown menu

    When we filter we can see all the items that are present in the selected column. What would be helpful is to have next to each item the count of times it's present in that column. E.g. it column "Animal name" contains 1x"dog", 1x"cat", 5x"horse"..., if I filter, I'll be able to see the names of these animals only, what I'd like to have also is the number of times (count) they're present in the column.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  19. Find and replace text

    When i am find the text after replace, font styles are affected(changed) in the cell contents.
    Please any idea?
    Thanks.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. DISTINCTCOUNT, DISTINCTCOUNTIFS, PERCENTILEIFS

    My understanding is the Excel team is working on DISTINCTCOUNT already.

    Following the blog item:
    https://blogs.office.com/2016/02/23/6-new-excel-functions-that-simplify-your-formula-editing-experience/

    We need to extended the "IFS" to PERCENTILES and DISTINCTCOUNT to work on the same way that SUMIFS,COUNTIFS, MAXIFS, MINIFS, etc

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base