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. WeekNum - let it work with a Array like Month() does

    We can use '=SUMPRODUCT( (MONTH(A1:A10)=MONTH(TODAY()) )* (B1:B10) )' to get a result from dates.

    However
    '=SUMPRODUCT( (WEEKNUM(A1:A10)=WEEKNUM(TODAY()) )* (B1:B10) )
    does not, because WEEKNUM can't handle an array or range.

    Please give us a WEEKNUM that handles Array and ranges

    Thank you.

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

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add CTRL+J for Find function to Mac version

    Add CTRL+J for Find function to Mac version

    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 →
  3. Copy Format by taking (with mouse) the left corner of the cell

    As well as you may copy the complete cell selecting the bottom-rigth corner, with this new feature you may be able to copy both; only the format or only the values (your choise on settings) by using the "upper left corner".

    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 →
  4. Allow images to be inserted/embedded into comments and notes.

    Please allow this desperately requested feature, as most Microsoft Excel users need to annotate their spreadsheets with images.

    For example, I have a spreadsheet comparing possible travel routes for a trip I am planning. I would like to insert a screenshot of a receipt into a comment/note so I can easily "hide" it or view/"show" it, as needed.

    The value of having images within comments/notes is that they will remain linked to the associated box. This would be extremely helpful for spreadsheets containing multiple images.

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  6. Find

    Why after so many years of people requesting that Find All button be added to the Find dialog box in Mac Excel version it's still not there? How difficult is it just to add a button?

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Sheet numbers change as you drag the formulae down

    Can there please be the ability to drag the below function down the column and the sheet number changes automatically only. The '$' sign fixes the cell but I need the ability for the sheet number to change automatically in numerical order as I have over 200 rows and 25 columns to change manually!!

    ='18'!$B$3

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Filtering directly from the chart

    Be able to filter information in the chart, similar to what exist on windows.
    Example attached(image)

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  9. Please don't bar people from using all functions on Office Home & Student 2016 for Mac

    As a student, I have purchased a lifetime license for Microsoft products. It seems ridiculous that I am barred from using functions such as "MAXif". Why can't all functions be made available? I am sure NO company will get rich making extra $ from students in this manner. This is so sad.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. In Office 2011 for Mac in the pulldown File menu under Recent the user has the option to Clear Recent. This option does not exist in Office

    In Office 2011 for Mac in the pulldown File menu the user had the option to Clear Recent. This option is missing in Office 2016. It was a useful feature. You should put it back.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Repetitiveness in the process of a Time Trial Worksheet.

    I'm making a document for data consisting of time trials. However when Adding the time trials together, it has to be in a certain conditional format. And its inconvenient, repetitive, and time-wasting to put multiple 0s for everything to find averages, and sums of my time trails. ex. 0:04:32

    I feel this may be a quick fix. Would appreciate the effort.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. Refresh a power query

    Allow Mac users to refresh a Power Query that gets files from a folder (and was created with windows).

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  14. Take the time to put more guidance online!

    What's really galling about excel for mac is that there's no online guidance from MS - I just wasted an hour trying to track down some basic stuff about document inspector and removing metadata before sharing (which, not surprisingly, is 5x as ******* a mac).

    SO regretting switching to this product from bulletproof Google sheets.

    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 →
  15. 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 →
  16. Please update excel to open files in Catalina OSX, all other 365 programs working

    Please update excel to open files in Catalina OSX, all other 365 programs working.
    Excel will open but will not open an excel file

    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 →
  17. Embed images in cells

    Users should have the ability to embed and image into a cell, so that when you sort data alphabetically, the image moves with its respective column. If google sheets can do this, so can Excel. The "move and size with cells" as well as "move but don't size with cells" options do nothing to help when alphabetizing other data in the same row.

    4 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 →
  18. 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  19. coucou

    coucou

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  20. Problem between cells

    When I divide 2 cells with results generated by formulas, the division cannot be dynamic!
    The calculus fixes on the 1st result found.

    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 →
  • Don't see your idea?

Feedback and Knowledge Base