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.

How can we improve Excel for Windows (Desktop Application)?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Bring back Edit Comments (Legacy) to the Right-Click Menu

    The new Threaded Comments that appeared in Build 1809 are awesome for 99% of the people. But for the Commenting Gurus - anyone who has ever taken the time to build help systems by resizing, re-coloring, re-shaping and using Show All Comments, we are going to see our comments get destroyed by well-meaning co-workers.

    Yes, all of the legacy icons are available for adding back to the Ribbon, but we the comment gurus can not trust our co-workers and managers to take the time to add these.

    My request: If Excel detects any comment in the workbook that is a…

    126 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      33 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    • Number format thousand separator and no decimals

      Every time (many days a year) I train people in Excel, someone ask why there is no button or shortcut to obtain a number format with "thousand separator and no decimals". At least - in northern Europe - this is the most common used number format. If "button-solution" not possible for Microsoft in order to have common buttons world-wide, at least a shortcut for this has been much appreciated. (Note that the current button for thousand separator and two decimals could not be used, though the alignment in that format are not disired/good and two decimals used).
      Today I teach…

      425 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        97 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
      • Pull Current Stock Prices and Historical Data Into Excel

        Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.

        It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.

        916 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          325 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

          Hi everyone,
          Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.

          One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.

          We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

        • When copying tabs, somtimes we have to cycle through 100s of "Yes" or "No" to the "Name already exists warning" Can we add Yes to All option

          This is a major productivity killer for power users such as finance teams, and current UX does not help exit this state efficiently.

          92 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            15 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
          • Function and formulas recommended

            Mohammed A Elrify
            Mohammed A Elrify Occasional Contributor

            4m ago

            Suggested to Microsoft EXCEL
            By creating the advantage of the proposed Function and formulas recommended
            Such as recommended pivot tables and recommended charts

            For example, the work of options for the user
            For example if he wanted to compile on terms, he would have the formula SUMIFS ready and only a choice
            Also like the search that VLOOKUP uses
            And so on
            I hope the Microsoft community will support and encourage this idea

            66 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              16 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
            • Directions from 0 to 2pi 1)atan(x,y) 2)atan(E,N) and from -pi to +pi 3)atan2(x,y)

              1)atan(x,y)=pi-pi/2*(1+sgn(x))*(1-sgn(y^2))-pi/4*(2+sgn(x))*sgn(y)

              -sign(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y))) when x=x2-x1 ,y=y2-y1

              2)atan(E,N)=pi-pi/2*(1+sgn(N))*(1-sgn(E^2))-pi/4*(2+sgn(N))*sgn(E)

              -sgn(N*E)*atan((abs(N)-abs(E))/(abs(N)+abs(E))) when N=N2-N1 ,E=E2-E1

              3)atan2(x,y)=pi/2*(1-sgn(x))*(1-sgn(y^2))+pi/4*(2-sgn(x))*sgn(y)

              -sgn(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y))) when x=x2-x1 ,y=y2-y1

              The above fuctions give the directions in the 4 quadrans for all the pairs of dx and dy.

              For dx=dy=0 the result is indefinite .

              88 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                15 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
              • Tables should default to "My table has headers" being ticked

                It's taken me 10 years to realise this but I've never "unchecked" My Table has headers, it's ALWAYS the other way round, forgetting to remember to tick it because Excel hasn't recognised the header row.

                Let's default the tick to always on ?

                46 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  6 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                • Please support Unicode font in VBA

                  Please support Unicode font in VBA.

                  Thank you!

                  35 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    4 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                  • Default the Power Query formula bar as on

                    In the Power Query editor window the formula bar is defaulted as off. This is the first thing I tell people to turn on as it’s key to avoiding unintended errors and future proofing your code.

                    As Gil Raviv says in his book, “ Enabling the formula bar is fundamental to avoid the pitfalls”

                    25 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                    • Add a Reporting Ribbon to Excel to consolidate and highlight the amazing capabilities of Power Query and Power Pivot

                      Tables, Power Query, Power Pivot and Pivot Tables are amazing tools that will transform the way people build their reports, but only once they know about them!

                      Let's SHOUT about how good these things are and how well they work together by putting them onto a single new Ribbon called "Reporting" - something like the attached image.

                      143 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        16 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                      • Enable Excel to send a Task to Outlook

                        Some users use Excel for tracking of various tasks or operational reviews. At the end, follow-up minutes and tasks will have to be created. It would be great to have a function like in OneNote to create a Task in Outlook. Information about Due Date and Assignee should be embeddable into the cell with a little popup window.
                        When in Outlook, you should be able to click the task and go back to the Excel document (and specific cell) stored on the SharePoint.

                        22 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          2 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                        • Single Page Zoom

                          When in Page Layout mode, have the option to zoom out on one page. Word has a "One Page" option in the zoom settings. Excel is default to "Multiple Pages" when zooming out and scrolling. Would be nice to see how the document will appear printed out.

                          See attached for what is available in Word.

                          22 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            4 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
                          • Retain text formatting after changing formula references inside shapes/textboxes

                            This has been a bug (in my mind) forever. For some reason, if you have an Excel shape nicely formatted and you go to link it to a cell to make the text dynamic, all the text formatting gets reset. This is really extremely annoying if you are creating a visually stimulating dashboard and want to duplicate a bunch of perfectly formatted shapes. Proceeding to link the shapes to various cells so that they display your data completely resets the formatting.

                            I created a VBA workaround to make it seem like the text format is retained, but this functionality should…

                            13 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              4 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                            • Multiple sheet Unhide option..

                              Unhiding multiple sheets is a painful task, you have to go one by one. There should be an option to unhide multiple sheets at once.

                              Please bring in this feature.

                              Thanks.

                              33 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                2 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems

                                It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often results in Formula.Firewall warnings or other issues.

                                This leads to having to switch Privacy Levels to "Ignore" or having to write a query within a query rather than nice and clean "parameter" queries.

                                It would really simplify things if we could quickly create parameter queries (including a drop down to select parameter type) and that these queries would be immune from the Privacy warnings.

                                255 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  8 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                • Bug: wrong data from OLAP source

                                  Incorrect values of dimension in pivot table sourced on OLAP cube (Microsoft SSAS 11.0.5569.0). The latest version without that bug is 16.0.6001.1068. Obviously we don’t know exact source of this bug, but most of the issues we discovered were on complex pivot tables with many attributes, partially displayed dimension’s hierarchy and without subtotals. Example of this bug occurring is in attached file ExcelBug. There are 2 exactly the same pivot tables (the table on the right hand side is basically copy of the table on the left hand side). After removing “Grand Total” on the table on the right hand…

                                  16 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Add Center Across Selection to the Merge & Center Drop-down

                                    Do you hate Merged Cells? Do you believe Merged Cells are evil? Do you curse every time your selection rectangle goes from one column to five columns just because you touched a merged cell? Do you constantly get workbooks from co-workers who continue to merge cells? Tired of not being able to Sort or Paste because someone merged a cell?

                                    Excel encourages people to use Merge & Center by offering it front-and-center on the Home tab. Thus, few people discover the (superior) Center Across Selection option on the Alignment tab of the Format Cells dialog.

                                    Currently, the Merge & Center…

                                    424 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      71 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                                    • stop automatically removing leading zeros from cells. they should stay be default as they are NEEDED for the sheet.

                                      stop automatically removing leading zeros from cells. they should stay be default as they are NEEDED for the sheet.

                                      13 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Add cell reference to Data Validation Messages (Input Message, Error Alert)

                                        Please add the ability to use cell references or formulas in the Data Validation Messages (Input Message, Error Alert).
                                        This would make possible to use variable contents.

                                        Thanks,
                                        Fernando Fernandes

                                        24 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Make the Evaluate Formula dialog box re-sizable

                                          The evaluate formula box is unusable with large and/or CSE formulas. Please just make it re-sizeable. Thank you.

                                          29 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

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

                                          Feedback and Knowledge Base