Feedback by UserVoice

Excel for Mac

Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. 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 Mac?

(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. Allow removeduplicates to be used in VBA

    In windows, remove duplicates function can be used in VBA and is very effective. Currently, Mac doesn't support this function in VBA. Please add this to be used on Mac as well. Thank you.

    20 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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

      Good news. In version 16.x, the RemoveDuplicates command works in VBA.

      Here’s an example of the code:
      ActiveSheet.Range(“$a$1”).CurrentRegion.RemoveDuplicates Columns:=Array(1, 2), Header:=xlGuess

      Steve K [MS Excel]

    • Fix Solver after update 15.19.1

      After the update 15.19.1 the picking problem is fixed. But now solver don't work anymore. When you try to solve a problem nothing happens.
      Please fix this!!

      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

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

        Several issues with Solver have been fixed since this suggestion was posted, so I am marking this post as completed. If specific issues are noticed, please post the details about what you are seeing. More detail is better, so that we can try to reproduce and investigate the issue.

        Steve K [MS Excel]

      • Bring back a fully functional VBE (Visual Basic Editor for VBA)

        Please bring back the full editor capability of VBE to Mac Excel 2016, like we had in Mac Excel 2011. As it is, the "slimmed down" editing experience of VBA is more like a notepad experience than anything - making it basically impossible to
        * edit VBA from scratch,
        * get syntax highlighting
        * see a watch window
        * etc.

        (Note: this title and description updated by Dan [MS] on 10/19/2015)

        855 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

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

          Hi All – The Visual Basic Editor was greatly improved in an update several months ago. If you don’t have the latest version of Excel for Mac, please go to Help > Check for Updates and update to the latest version to check it out. Thanks for all your comments and support for this feature.

          If you notice issues as you are using the latest VBE, please let us know by clicking the smiley-face feedback button near the top-right of the Excel window.

          Steve K [MS 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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
          • Don't see your idea?

          Feedback and Knowledge Base