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.

Take a look at the feedback that we are currently working on and what feedback we have already completed.

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. Sorting and calculation in Myanmar fonts

    I used a lot of Myanmar text in Excel and other office applications. Myanmar fonts are coded from U1000 to U109F in Unicode system. My major concern is I cannot sort the cells with Myanmar text properly. And calculation formula doesn't work with Myanmar digits. I checked with Thai language and sorting and calculation are working well. Could you please improve these functions for Myanmar language as well?

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    • Add the "Change Case" tool like Word 2016 & earlier has.

      I would love it if excel 2016 had the "Change Case" tool like Word 2016 does under the font section of the Home Tab

      1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
      • Paste to Non-Contiguous Cells

        When I hold the [CTRL] key I can load the clipboard by selecting cells in non-contiguous areas.
        It would be nice to be able to paste to non-contiguous cells also.

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
        • when I copy and paste the whole column with some hidden rows in between, I want the excel can copy the same columns with the hidden rows too

          when I copy and paste the whole column with some hidden rows in between, I want the excel can copy the same columns with the hidden rows too.

          1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
          • Single Ribbon for multiple workbooks open at same time

            I often have multiple workbooks open on the same screen. On 2010 and before, this was no problem as I had macros with keyboard shortcuts to have the books assume the top or bottom half. In later versions, Excel addressed this with multiple windows. The idea is great but could be executed better. The main problem is multiple ribbons showing for multiple workbooks. If I'm working on a single monitor and want details on the top and bottom half, about 1/3 of the space is taken up by the ribbon. Of course, I can collapse the ribbon but it takes…

            1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
            • PLEASE ADD WEBSERVICE FUNCTION FOR EXCEL ON MAC

              WEBSERVICE FUNCTION IS A MAJOR MISSING FUNCTION ON EXCEL FOR THE MAC

              1 vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
              • More functions to work with 3-D references

                Far too few formulae work with 3-D references. I don't see why CHOOSE or INDEX shouldn't when SMALL and LARGE do...

                Surely anyone with 3D data tables spread across tabs has to use indirect() to reference data from separate tabs, which is volatile. It makes manual calculation mode a given, as it's volatile. (Please correct me if I'm wrong)

                In theory, INDEX MATCH should work, but neither of these 2 do:

                =INDEX('Sheet1:Sheet12'!A1, 3)

                =MATCH("lookup value",'Sheet1:Sheet12'!A1)

                Could they be made to? It'd be logical.

                For a second I thought ADDRESS(1,1,1,1,"Sheet2") was my answer, but it only works if it's INDIRECT(ADDRESS(1,1,1,1,"Sheet2")), so…

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                • Non volatile lookup across tabs

                  Far too few formulae work with 3-D references. I don't see why CHOOSE or INDEX shouldn't when SMALL and LARGE do...

                  Surely anyone with 3D data tables spread across tabs has to use indirect() to reference data from separate tabs, which is volatile. It makes manual calculation mode a given, as it's volatile. (Please correct me if I'm wrong)

                  In theory, INDEX MATCH should work, but neither of these 2 do:

                  =INDEX('Sheet1:Sheet12'!A1, 3)

                  =MATCH("lookup value",'Sheet1:Sheet12'!A1)

                  Could they be made to? It'd be logical.

                  For a second I thought ADDRESS(1,1,1,1,"Sheet2") was my answer, but it only works if it's INDIRECT(ADDRESS(1,1,1,1,"Sheet2")), so…

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                  • Move or Copy Tab Function

                    Instead of having the (move to end) function at the bottom of the list, either move it to the top, or perhaps create a check box for this function and place I under the existing Create a Copy check box

                    1 vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                    • auto international scheduling for the rotational staff

                      I want a template that if i enter an offs for the a employee it should automatically calculate that when should be his next off and which employee should replace him. and who else can get the off.

                      like for example if employee A is working i put his 4 offs in a cell so it should show me what will be his next off and how can employee B can replace him

                      1 vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                      • Execution error

                        when you scroll the mouse button over the grouping filter at the top or bottom, Excel hangs and shuts down by restarting the application.

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                        • Stop changing the way to use it!

                          Stop changing it all the time. I can't find how to add in a line the format auto erased. I used to be able to click on a grid icon after highlighting the two or more spaces I needed to add lines back in, and now I can't find that function at all. It's buried somewhere in all the new stuff I don't use. Please tell me how to put this line back in via my email below.

                          Also, delete the erase function for lines when cutting text to move elsewhere. Leave the line there. That's a bug.

                          1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                          • Office Open XML format - Excel 2016 64-bit bug

                            The file properties issue is partly fixed (for Word files) on the Office 64-bit version build 16.0.8518.1000 or 16.0.8530.1000 or 16.0.8431.2079. For Excel 2016 (64-bit) the file properties bug is still not fixed for the file formats .xlsx .xlsb and .xlsm. You will get an interface error 0x80004002, see screenshot.

                            1 vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                            • Version number Forms3 not fully visible in VBA (bug)

                              If you go to <Help> -> <Info> in VBA the Forms3 version buildnumber is not complete, see screenshot below.
                              The last digit '6' is missing in this case, see screenshot 1. It should be: 'Forms3: 16.0.7571.7046'
                              The Info box form should be stretched a bit on the right-side, so that the last digit is visible, see screenshot 2.

                              1 vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                              • Recording macro gives Run-time error '9' Subscript out of range when it is runned (bug in recording macro)

                                I want to copy an existing sheet, rename it, and make the tab color of the new sheet "No Color". I've recorded a macro to do this, but when I run it, it errors. Run-time error '9' Subscript out of range. Debug highlights this line: .ColorIndex = xlAutomatic

                                The macro runs fine when this line is changed manually to:
                                .ColorIndex = xlColorIndexNone

                                This bug exists in all Excel versions.

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                                • Bug Fix Needed: Data Labels - Value From Cells - Text Not Updating

                                  When using the new Value From Cells option for data labels in an XY Scatter chart, if the range you select for the Value From Cells contains any BLANK cells and then you save the file and close the file ... when you re-open the file and try to edit the blank cells to add data labels to the chart, the data labels remain blank. Normally, you can edit the cells to edit the data label text and the data label text updates immediately.

                                  Current Work-Around: (1) Go to Format Data Labels (2) Click on the Reset Label Text button…

                                  1 vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Set a more complete default.

                                    Unless I am missing something, I am limited to what I can set as a default from one workbook to the next. Most of my work involves similar formatting. I would like to be able to set the default to include not only font and margin, but also cell size and positioning ... but why stop there. I should really be able to set any desired feature as a default for all subsequent workbooks (if I so chose) and personalize from there.

                                    1 vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                                    • alternating ranges used in various formulae (ie to sum every third row =SUM( alt( 3, a1:a100) )

                                      It would be nice to have a simple way to express ranges that miss out a regular arrangement of irrelevant cells between the start and end point of the range.

                                      e.g. rather than having to manually enter

                                      (a5,a10,a15,a20,a25,a30,a35,a40,a45,a50)

                                      instead i could use ALT(5,a5:a50)

                                      VERY USEFUL where data for relevant calculation is interspersed with titles or cumulative totals or whatever

                                      modified ranges (or bespoke arrays) expressed in this way could then be used within all sorts of other formulae

                                      e.g

                                      index(ALT(2,a1:g1),match(b1,alt(3,d2:d14,0))

                                      rather than

                                      index((a1,c1,e1,g1,i1,k1,m1,o1,q1),match(b1,(d2,d5,d8,d11,d14),0))

                                      which would not only save time and effort, but also allow some new things to be achieved…

                                      1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Filtering

                                        I work extensively in Excel, and run across a couple of things that I believe would be better served if they were rearranged.

                                        1) Filters:

                                        A. My primary idea for this is to move the “Blanks” check box to the top of the list. I often wish to filter only the blanks, and find it a little aggravating to have to scroll to the bottom of the list to select this.

                                        B. The ability to filter non-adjacent columns.

                                        C. The ability to create a custom filter that could include multiple columns of data simultaneously.

                                        2 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Position exact coordinate of a text box.

                                          In the Excel we need to position a text box but there is exact coordinate of box postioning. Add in a feature so that exact position put in.

                                          1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            2 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 148 149
                                          • Don't see your idea?

                                          Feedback and Knowledge Base