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 the menu instead of the ribbon

    The ribbon is awful and requires a bunch of re-learning every time we upgrade versions. I want the menus from excel 97-2003 back, if only as an option for "power users"

    2 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 →

      The ribbon is a cross-Office, cross-Microsoft, and now cross-industry paradigm for UI. At this point we will not be switching out the ribbon in Excel for menus/toolbars.

      Cheers,
      Dan [MS]

    • Bring VBA into the modern world

      It would have a couple of stages.
      Stage 1: Get Visual Studio features into the VBA development environment.
      Stage 2: Fully integrate VBA into Visual Studio.
      Stage 3: Continually improve VBA until it is a modern langauge.

      Notes:
      VBA is probably the most used programming language in the world.
      It has so many established users that MS could really get big brownie points by continually improving the experience for users and developers. Why it has stagnated for so long I have never understood.

      226 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

        85 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

        I want to thank everyone for weighing in – none of us on the Excel team are surprised that this item is getting a lot of votes, and we have read all of the feedback in this thread. Extensibility in Excel is something that we are passionate about, and while we’ve been focused on other investments over the last few years (primarily around getting Excel onto more devices with versions for Mac, iOS, Android, and Windows 10), this is something we’ve been actively discussing as we figure out how to enable extensibility of those new platforms.

        As it stands, here’s our current position.

        First, VBA is very important to Excel, and we plan to keep it around for the foreseeable future. As we add new features to Windows Desktop and Mac versions of Excel (where VBA is supported), we’ll continue to add object model for those features (see http://dev.office.com/blogs/VBA-improvements-in-Office-2016),…

      • Formatting Comment default

        I can't SEE the comment in 9 pt font. (heck, I can't see THIS box) PLEASE let me change it !!!!

        Not all your users have "young" eyes, I'm not handicapped, just very nearsighted.

        1 vote
        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 →

          Hi Annette,

          As you noticed in the Mac area of UserVoice, comments use an old technology in Excel that we’re not investing directly in anymore, and instead we’re migrating comments to a new technology that will allow more control over their appearance (and things like fonts).

          In the meantime, a couple of workaround options for you, that you may already be aware of:

          1. You can use Windows Magnifier – click on Start > type “Magnifier”; you can then magnify parts of your screen, including comments.

          2. You can zoom the Excel sheet, which will also zoom comments, and make the text larger. You can find zoom on the View ribbon, or in the lower right corner of the Excel status bar.

          Hope that helps until we can get comments moved to the new platform.

          Dan [MS]

        • Allow Excel to undo macro actions

          I understand that not every macro is undoable, but some should be. For example, "Selection.Interior.Color = 255" is not undoable at the moment, but should be since you could do the exact same thing from the Ribbon. This really discourages people from using the macro recorder, or even macros in general.

          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

            5 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

            This VBA integration with the undo stack is not something that we’re planning on doing (see the idea about bringing VBA into the modern world).

            Cheers,
            Dan [MS]

          • Stock data type, Expense Ratio column

            First of all, love the new Stock data type and can see this new feature getting better and better as time goes on.

            One thing I noticed right off the bat is that the Expense Ratio column seems to be locked at 2 decimal places. ***.XX% for example. Checking one particular index fund from Vanguard (VINIX), they have the expense ratio listed for this fund as 0.035% but the Excel column brings it in at 0.040%.

            It looks like their is either some rounding issue going on or the data source Excel is basing this off of has it saved…

            1 vote
            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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

              Thanks for posting! I’m seeing that this is actually a bug in the data source and doesn’t have to do with a limit on the precision in the expense ratio field.

              You can verify yourself that the incorrect data is replicated on Morningstar here: https://www.morningstar.com/funds/xnas/vinix/quote.html

              Since this isn’t a feature request, I’m going to close this request as “declined”, and we will follow up with Morningstar about getting this fixed. For future reference you can report issues like this through the Excel “Send a smile” button in the top right of your Excel window.

            • Test

              Test, please ignore

              1 vote
              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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
              • Ability to Cut without adding to clipboard

                Sometimes I have to remove a graphic and replace it with a newer version.
                To do this currently I use CUT and then have to copy the new graphic and paste it.
                I'd like to be able to simply CUT the old graphic then PASTE pasting the new graphic (currently the way it works, it would just re-paste the graphic I just cut)

                1 vote
                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

                  5 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

                  The paradigm of placing “Cut” content onto the clipboard is something that is consistent across Windows, Mac, and mobile platforms. As such, we’re very unlikely to change it within just Excel.

                  Cheers,
                  Dan [MS]

                • Remove gross Yellow Smiley faces from all office applications

                  I've tried registry edits nothing works it looks unprofessional and is a big distraction.

                  1 vote
                  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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →

                    Hi,

                    The yellow smiley faces are a paradigm that we’ve used across Office for sending feedback to Office engineers for things that are great (Smile) or not so great (Frown).

                    They’ve been there for years, and aren’t something that we “control” on the Excel team, so they aren’t something that we’re going to remove.

                    Cheers,
                    Dan [MS]

                  • please add persian calendar (hijri shamsi) in excel 2013 (as like as 2016 version)

                    Some people who use Persian calendar in excel, need to do calculation on date; some apps help them in this way but these are not perfect and they affect on other procedures... this problem is solved by Microsoft in 2016 version... So if it is possible, please add Persian calendar (hijri shamsi) in excel 2013 too.
                    I am looking forward to see it in your next updates... thank you very much.

                    1 vote
                    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

                      Hi,

                      We’re unlikely to add this in previous versions of Excel, as we don’t have regular updates of those versions, as we do with OFfice 2016.

                      Cheers,
                      Dan [MS]

                    • Expand possible locations in "Add a Place"

                      Add a Place allows us to choose from iCloud Drive, Office 365 SharePoint and OneDrive.
                      Could we add the choice to connect to other location such as a G Suite account in order to be able to save or save as in Drive.

                      The only way around so far is to install the third party add in "Google Drive".

                      1 vote
                      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 →

                        Hi,

                        This list can be customized, but only via add-ins as you’ve already noticed. The reason for that is that Office needs to know how to communicate with those storage locations, and each works differently – that’s what the add-in does.

                        There’s no way for Office to allow you to enter a URL and have things “just work,” unfortunately.

                        Cheers,
                        Dan [MS]

                      • Axel - Combining Access and Excel into 1 excellent product

                        Hello,

                        I have been developing with Access and Excel for the last 17 years, it is my bread and butter and while I use VBA to communicate between the two I had the following thought...

                        Wouldn't it be great if a new product came to market that contained both Access and Excel objects?

                        Viewing Form tabs alongside Excel Worksheets in the same development window, showing sheets as objects in the same pane as tables and queries etc.

                        A benefit of both data storage and calculations plus it would certainly be faster.

                        You could call it Excess or Axel

                        It would…

                        1 vote
                        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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

                          Hi,

                          While we won’t be merging Excel and Access into a single product, we have been doing a lot of work in Excel to make it work better with data. Power Pivot, Power Query, and the Data Model are all tools that let you pull data from multiple sources, join and manipulate that data, and then do all of the ad-hoc reporting on it that you are used to doing in Excel.

                          Cheers,
                          Dan [MS]

                        • VBA formulas same as excel formulas

                          I would like to see the abiltiy to use any excel formula used in VBA, with the same syntax.

                          For example-Range("A1").value = ExcelFormula.=countif(B2:B30),testing

                          Something like that to signfiy to vba that an excel formula in the exact same way that it is used in VBA, so you could even cut and paste any formula between excel and VBA.

                          1 vote
                          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 →

                            Hi,

                            We have no plans to structurally update the VBA environment (see “Bring VBA into the modern world”). However, you can work with Excel functions in VBA already, using the WorkbookFunction object. The syntax is still VBA-like instead of Excel-like, but the functionality is there.

                            Alternatively, you can use Evaluate, as Kenneth suggested:
                            Dim x As Double
                            x = Evaluate(”SUM(A1,A2)”) ‘Evaluate function
                            x = [SUM] ‘Shortcut

                            Cheers,
                            Dan [MS]

                          • A spread sheet for farmers to keep track of their CCA

                            I would like to see an excel spreadsheet set up for farmers to track their CCA class, asset descriptions, market and purchase value of equipment, trade in values etc Right now I have to try and set it all up myself. would be handy to have a sheet all set up

                            1 vote
                            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 →
                            • Manage SQL Server table content

                              I wish there was a simple way to manage data in an SQL Server table using Excel. We can read the data with current tools, but I hope we could also insert and update data using Excel.

                              1 vote
                              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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

                                Hi,

                                This is an interesting idea, but one that we’re not going to integrate into the Excel product. Excel is really about connecting to, cleaning, and analyzing your data – it’s not about schema management or SQL Server management.

                                A better tool to do that management is Access, or the free Microsoft SQL Server Management Studio.

                                Cheers,
                                Dan [MS]

                              • Allow indirect conditional formatting to adjust when columns are inserted

                                Right now, if you use indirect conditional formatting, and a column is inserted between the formatted cell/column and the cell/column that drives the formatting, the indirect reference does not adjust.

                                1 vote
                                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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                                  INDIRECT uses strings to generate references. There is no way for Excel to know if the strings in INDIRECT should be adjusted or not – so they never are (in regular cell formulas or CF).

                                  Cheers,
                                  Dan [MS]

                                • 1 vote
                                  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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →

                                    There is no good way for us to know (with certainty) when a user is actively working in a workbook vs. just has left Excel open. As such, we are unlikely to do this feature, as it would be “wrong” at least as often (probably moreso) than it would be “right.” As an example – a user could be reading or transcribing numbers from an open sheet – so it would look to Excel like there was no activity, but if you asked the user, they would say “of course I was using Excel.”

                                    Cheers,
                                    Dan [MS]

                                  • numbers and not formulas in the cell

                                    in a formula, add the possibility to write a symbol after = to say that you want to write just the result, and not the formula, in the cell

                                    1 vote
                                    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 →

                                      Formulas are a key part of Excel, so we won’t be auto-converting them to values on entry. However, you can convert them to values by selecting the cell after you’ve entered the formula and copying it (Ctrl+C); then Paste Special (Ctrl+Alt+V) and choose Values.

                                      That will leave the number in the cell, rather than leaving the formula there.

                                      Cheers,
                                      Dan [MS]

                                    • Power Excel

                                      Rename and rebrand Excel to become 'Power Excel'
                                      This would reflect its modernity, point towards closer integration into Power BI and truly distinguish the product from old Excel
                                      Modern Excel with all the new functionalities therein represents a tremendous analytic arsenal at your disposal yet most users are unaware of this
                                      A product name change would immediately change perceptions and promote awareness
                                      Office 2017 Pro Plus comprising Word, Access, Outlook, Power Excel

                                      2 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

                                        Hi Anthony,

                                        While I personally love the implications of renaming Excel to Power Excel, this isn’t something we’re going to do at this point in time. The (Microsoft) Excel brand is already a well-known brand, and we’re going to look for ways to drive awareness of the new functionalities in that brand rather than change the brand itself.

                                        Cheers,
                                        Dan [MS]

                                      • Excel Sort v/s Folder Sort

                                        The sort order in excel is different then sort of files in a particular folder, eg.

                                        Folder sort
                                        abc 10.txt
                                        abc 12.txt
                                        abc 111.txt

                                        Excel Sort
                                        abc 10.txt
                                        abc 111.txt
                                        abc 12.txt

                                        1 vote
                                        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 →

                                          This is not one we’ll be changing, since Excel has sorted this way “forever” and we don’t want to break solutions that rely on this sort order.

                                          (I think Windows changed their sort order in the Windows Vista-ish timeframe)

                                          Cheers,
                                          Dan [MS]

                                        • If statement consistent formulas

                                          How IF statements currently work:
                                          A1=3; B1=2; C1=1;
                                          IF(A1>B1>C1, "True", "False") Results: True
                                          IF(C1<B1<A1, "True", "False") Results: False

                                          Both these statements should be true, but the second one gives the wrong results. For situations like this the logic statements are only correct if the > symbol is used; otherwise the true and false statements get flipped.

                                          0 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 →

                                            Given the way Excel evaluates formulas, which is from left to right, this isn’t going to change. Here’s what happens:

                                            IF (C1<B1<A1, “True”, “False”)
                                            IF (1<2<A1, “True”, “False”)
                                            IF (TRUE<3, “True”, “False”) <— you can see how the next check will fail (be false)
                                            IF (FALSE, “True”, “False”)
                                            “False”

                                            The way to write this function so that Excel will do the right thing is:

                                            IF (AND (C1<B1, B1<A1), TRUE, FALSE)

                                            Hope that helps,
                                            Dan [MS]

                                            (sorry for the wonky formatting, apparently there’s some UserVoice markup I have to work around)

                                          ← Previous 1 3 4
                                          • Don't see your idea?

                                          Feedback and Knowledge Base