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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. AutoFilter Spacebar Selector

    Like in Windows, it would be much faster to use keyboard shortcuts for things like selecting items in the AutoFilter list (i.e. using the space bar). As of today, you cannot highlight and select different items in the filter list without the mouse. Also annoying, is the fact that selections are applied instantly, causing nonsense CPU work and worse yet the window shifts in view as calculations are running. Messy.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  2. FOR THE LOVE OF GOD, fix your problem with MAC Excel's ability to open https hyperlinks!!!!

    I swear if I read "cannot open the internet server or proxy server" ONE MORE TIME I WILL THROW THIS COMPUTER THROUGH THE WINDOW. The addresses have been verified by a third party certifier. I DON'T UNDERSTAND WHY SOMETHING SO SIMPLE CONTINUES TO BE A PROBLEM!!!

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add a feature that can let csv file imported in excel

    There is no any ways to import csv file in excel for iPad Pro. Could you plz find out a solution to deal with this problem? Thank you!

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  4. Bring VBA on Excel for Mac to parity with Excel for Windows

    Bring VBA on Excel for Mac to parity with Excel for Windows.
    Currently, there are too many missing VBA elements missing. It is a major problem for those of us with mixed environments. Many things that worked under Excel 2011 no longer work in 2016.

    Why is the not being addressed?

    93 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  5. Toggle automatic formatting of dates.

    The automatic formatting of numbers to dates is incredibly frustrating when you dont want it. I am often in a situation where I need to paste a table into Excel, for instance to calculate something from the table. It always happens that some cells in the table get autoformatted as dates and this is extremely annoying. The work-arounds are difficult and cumbersome and I can never remember what they are, so my workflow gets interrupted because I have to google how to do it.

    I have very little use for the autoformatting of dates, but i appreciate that some people…

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  7. When will Excel for Mac bring back the shortcut for align right Command R?

    I was just reading complaints about this from 2017. Now we're at the end of 2019 and it's still not there, unless I'm missing something.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. Increase number of rows that can be filtered to more than 100,000

    Increase number of rows that can be filtered to more than 100,000. 10,000 is way too small when we deal with our data base. Is there maybe a way to increase this manually ?

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  9. 'Contains' should be by default option selected in Filter instead of 'Choose One'

    Contains could be the most commonly used option and system should allow to use this without using trackpad through shortcuts only. Cmd+Shift+F can put the filter. Then Option+DownArrow opens up filter but then there is not way to proceed with shortcut. User must have to use track pad to select the option (where I am suggesting it could be 'Contains' as default)

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  10. Including a time-or datestamp on templates for reports

    To insert a time or a date, we can either use the stamp function (e.g. ctrl+;) or use the formula (=TODAY). I would like to have the use of a timestamp inside a template, so that when we create a new sheet from that template, the fixed date appears, i.e. as a datestamp. I haven't found how to do this using help.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Support Internet Query Connection (.iqy files)

    It would be helpful for Excel to Mac to support internet query connections.

    When exporting a list from Sharepoint, the .iqy file is downloaded, which I subsequently can't open in Excel for Mac.

    44 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  12. Control of command button colour in Excel for Mac 2011

    Currently I have to use Excel for Mac 2011 as the later versions do not have the ability to create user forms. This is subject of other suggestions. But here I suggest a change is made to the 2011 version allowing the user to set the background colour properly.

    The default setting is incorrect - off white. When the default for the Mac version should be RGB 170,170,170. It also should have an option to be changed for any user. The default border is non-existent and is clearly an error.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  13. A real worksheet template

    I create a lot of workbooks with a repetitive worksheet. For example, a workbook would contain multiple sheets representing a particular day for a project, with the workbook representing the project.

    Each of these worksheets have exactly the same formulas and layout, so I create a 'template' worksheet in the workbook, which is then copied to create each of the worksheets.

    If I want to change the template, I have to go through each of the copies to manually alter the formulas.

    What would be cool is:

    1. Create a worksheet as a template
    2. Reference that template in copies…

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  14. MAKE IT SO IT DOESN'T CRASH!!!

    Guys! Excel crashes every 15 mins or more! It's almost unusable and I have to use it. It ridiculous how bad it is. I shouldn't have had to pay money for this and it makes my job 10x harder. Please fix it. For the amount of money I paid for office (and excel) it should be a working program. Right now Microsoft is a thief of my money and time with the amount of times I've had to redo work with all the crashes. I don't want to hear how you fixed it, just fix it!! (yes, I've updated the…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  15. Find and Replace Support for Non-Printable Control Characters (Alt Codes/Unicode)

    For example, searching for a printable character "x" and replacing with a linefeed <Alt>+000A, or carriage return <Alt>+000D.

    The Find and Replace functionality in the Windows version of Excel supports this fine when replacing with <Alt>+0010.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  16. microsoft excel 2016 v15.22 read-only cannot edit the .xlsb file.

    Microsoft Excel 2016 v15.22 read only i cannot edit my system generated file.

    all sheet are lock. but the windows all file can be open.

    please help..!

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  17. Obtaining Hang Seng Index from the Stocks module

    I am using Excel for Mac, version 16.30 (always updated to the latest version)

    I can easily obtain stock quotes all index members of the Dow Jones, Hang Seng Index, Swiss Market Index. Also to retrieve the index quotes for DJIA, S&P500, DAX, etc. is not an issue at all.

    Obtaining the quote for the Hang Seng Index itself I haven't figured out for a couple of months already.

    “HSI” returns "H.I.S. Co Ltd (OTCM:HISJF)” “Hang Seng” returns “No results found for Hang Seng” “^HSI” returns results such as H-Source Holdings, etc.

    I have reached out to Microsoft calling the…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  18. Obtaining Hang Seng Index from the Stocks module

    I am using Excel for Mac, version 16.30 (always updated to the latest version)

    I can easily obtain stock quotes all index members of the Dow Jones, Hang Seng Index, Swiss Market Index. Also to retrieve the index quotes for DJIA, S&P500, DAX, etc. is not an issue at all.

    Obtaining the quote for the Hang Seng Index itself I haven't figured out for a couple of months already.

    “HSI” returns "H.I.S. Co Ltd (OTCM:HISJF)” “Hang Seng” returns “No results found for Hang Seng” “^HSI” returns results such as H-Source Holdings, etc.

    I have reached out to Microsoft calling the…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  19. Add icons to charting bling to make better charts like in Windows

    It is nice in a column chart to see meaningful pictures instead of boring bars. Mac only allows you to import an image. Windows supplies a library of icons making it easier and more robust.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  20. Bug: Print sets page layout to the same across all worksheets on Excel for Mac

    To reproduce the issue, setup two sheets with different page layout (e.g. fit to pages, orientation etc). Select both and press print, then press cancel. Both sheets will now have the same print layout. This seems like a bug because:

    - This is not expected behaviour as it directly contradicts the documentation for Excel for Mac (see link below)
    - Pressing print shouldn't change the design of the spreadsheet and destroy painstakingly setup per-sheet page layout settings that take a long time to fix after this bug has paved over them
    - The Windows version does not have this problem …

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base