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…

    104 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

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

      48 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

        13 comments  ·  Performance  ·  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 .

        39 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  ·  Formulas and Functions  ·  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…

          362 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

            94 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
          • Create a command line tool for signing Office files with a digital certificate

            Besides Office, Excel files can be created using numerous software tools. More often than not, batches of macro-enabled Excel files are processed with scripts for productivity purposes. However, VBA code signing cannot be part of an automated process, as it is a manual task that requires opening & saving the file in Excel.

            This request is about creating a command line tool for signing Office files with a digital certificate, similar to MS SignTool.

            In addition, the existing macro signing process in Office is not 100% compatible with Open XML specifications. I can clarify this statement in a private discussion…

            63 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

              18 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
            • Improve the "Vary colors by point" option

              The current version of the "Vary colors by point" option is of limited use and indeed contrary to accepted data visualization best practices, since it randomly assigns different colors to bars. The user should have the option to apply conditional color encoding by assigning colors based on some data, creating a color scale (ramp or categorical). As a practical example, a bar chart displaying population by country could use population density to generate a color ramp for bars or variation by category (continents).

              26 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
              • Allow brackets in filename or path

                When a person's display name contains a bracket character (such as a departmental suffix) this bracket is included in the folder name of a OneDrive shared folder. When a recipient of that OneDrive shared folder attempts to modify an Excel spreadsheet and save it back to the shared folder, they will see an error that the file could not be saved due to invalid characters in the filename or path. If Excel could support the bracket character in the filename or path this would no longer be an issue. (An alternative solution would be to allow admins an option to…

                31 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  ·  Collaboration and Sharing  ·  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

                  12 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 →
                  • 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.

                    91 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

                      9 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                    • Intelligent Chart Axis Numberformat Would Eat Decimal Points

                      Charts default the numberformat for the axis to the numberformat of the first series. It would be better design (easier for the reader to understand) if the default minimized the number of decimal places. For example, if the y-values are between 2 and 8, I might show 2 or 3 decimal places in the raw data--but I want the chart axis to show whole numbers. I think of this as the chart axis should eat the decimal places where possible. That would be how a professional designer would build the chart, and it should also be the way the Excel…

                      8 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                      • Excel processor Bug - 99% usage

                        There is a bug with the processor usage, which extends up to 99% in some special situations.
                        Since the latest version of the semi-annual channel, there is a new bug, which is also in the latest version of monthly channel.
                        When you are opening a new excel sheet and copy one or more cells then you can start playing a little "processor-game". On the bottom there is a slide control, when you push it to the verry left (over the table sheets) the processor usage will grow up to 99%, when pushing it back to the right, the usage decreases.…

                        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

                          8 comments  ·  Performance  ·  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.

                          810 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

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

                            Progress! As of this morning, we’ve begun enabling the first iteration of Excel’s new data types for a percentage of Office Insiders, including the ability to pull and refresh live stock quotes (and other financial data) straight in to Excel! We’ll be increasing the percentage of Insiders with access to the feature over the coming days and weeks, so if you don’t see it right away please hang in there!*

                            We acknowledge that right now this is only half of the suggestion (pull current stock prices), but historical data is in our sights and we’re planning to add this and many other improvements to stock and financial data. Your feedback thus far has been immensely valuable in helping us plan and design this work, and we look forward to your continued suggestions for how we can improve to better meet your needs

                            Again, we genuinely appreciate your involvement as we…

                          • COUNTIFS / SUMIFS with OR - COUNTOR, SUMOR

                            Countifs or Sumifs function use all criteria as AND. Instead 2 more formula can be added such that all criteria are treated as OR. Suggested Names of Formula are
                            COUNTOR, SUMOR

                            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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                            • Filter Option - for 6 Months

                              In Filter, there are options for Last Week, Month, Quarter & Year. There could be following 2 options that can help user a lot:
                              1) Last 6 Months
                              2) First 6 Months (Current Year)

                              18 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

                                9 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add number format for thousandth (K$) or millions (M$)

                                Could you please add the number format K for thousandth and M for millions (like 5.8 K instead of 5812)
                                It would be very helpful.
                                Thanks

                                15 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 →
                                • 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.

                                  10 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Better Support for Analysis Services Tabular

                                    It's about time to improve support for SSAS Tabular:
                                    1. Auto-generate DAX
                                    2. Avoid splitting a table into a "measure group" and "dimension". See how PBI Desktop handles metadata.
                                    3. Carry over data types so that users can create reports, such as show me invoices where Due Date is greater than ... Currently, all dimension table fields map to Text.
                                    4. Many customers have expressed interest to connect Excel tables directly to Tabular, bypassing Pivot Table, so they can use the column dropdowns and other Excel goodness.
                                    5. Support descriptions as tooltips when the user hovers on a field in…

                                    51 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 →
                                    • Live exchange rates in excel (compliment to the new stock features)

                                      The new stock feature only displays stock prices in the currency on the exchange. The ability to convert between different currencies (ether in the stock feature or as a separate function) would be great and remove the need for many (including me) to copy paste exchange rates from the internet.

                                      5 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 →
                                      • 6 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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Shortcut for paste as values

                                          90% of the time I want to past as values, so as to keep the formatting consistent in the location I am pasting. Rather than having to right click then select "paste as values" it would be good to have a shortcut to be able to do this instead.

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

                                          Feedback and Knowledge Base