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. Online templates missing?

    When writing an article about Excel features and ideas on the excel blog it's not user friendly when the description is either misleading or isn't working.

    The article link:
    https://support.office.com/en-us/article/Learn-how-to-use-the-Stock-Analysis-template-with-Excel-2016-f65e62ac-7af6-4cc6-98f3-f68b147ed65d?ui=en-US&rs=en-US&ad=US

    I was reading use excel like a boss and followed the link for the stock analysis and per the instructions I went into my templates and it's not there and it's also not online at the following link: https://templates.office.com/en-us/templates-for-Excel

    Also since comments are closed on that article I can't ask what happened to that template.

    I'm using office 365 on my iMac using Excel 2016 version 15.18. When I search…

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. bullet items for words in a cell

    allow items in a cell to be buletted

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

    We’ll send you updates on this idea

    4 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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 →
  4. Introduce "Offline Mode" to Reduce Latency and Improve Performance

    Please create an "Offline Mode" feature for Office 365 to reduce overhead and improve performance when network connections are not required for one's basic Office app use.

    While using Excel (Office 365 for Mac) there is too much latency in the most simple tasks. Additionally, the application(s) attempt to make multiple network connections to various sites for subscription, sharepoint, and other apps connectivity. All of these actions reduce performance and create an overhead which impacts the users' experience (one only needs to google the feedback to date on the latest Office for Mac issues). Additionally, there are times when traveling…

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

    We’ll send you updates on this idea

    7 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →

    This suggestion is from quite a while ago and we’ve had lots of updates since then. Please comment whether this is still an issue or let us know that it’s gotten better. We’ll keep this open and monitor for votes and comments.

    Steve K [MS Excel]

  5. Find and replace text without affecting font style[Bold,Italic,Subscript,Superscript]

    I want to find some text and replace to null string, After the text will be replaced. But, the following words font style would be affect.

    Any idea to fix this?
    Thanks.

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

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  6. Excel 2016 Please return the "enable: all files" in the text import box so we can import files that have extensions other than .txt

    Excel 2011 had the option at the bottom to switch to "all files" when importing text files so that files that had extensions other than .txt would not be greyed out. This is now gone in Excel 2016 so it is impossible to import text files that have other file extensions unless you rename them (which is very impractical for me).

    Please put the option back! I want to be able to import .dat, .ici, .ocw and so on as I used to on Excel 2011.

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

    We’ll send you updates on this idea

    9 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  7. VLOOKUP and 256 characters limit

    Many functions in EXCEL for MAC 2011 don't work at all (they return the dreaded #VALUE field) if the one of the reference cells has more than 256 characters. This is the case already for VLOOKUP, and for TEXT. Possibly for others as well?
    Users shall have a list of these, to avoid disappointment. Of course if it could be corrected it would be better.

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

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Fix https link resolution in Office

    The Office 2011 external-link-checking function needs either:
    - To be less restrictive with https links by resolving them even if the linked website does not present an Excel-readable SSL certificate (in my case, this is because the linked page redirects the browser to a login service).
    or
    - To offer the option of disabling the link checking function on Mac, as is already (partially?) possible on Windows: https://support.microsoft.com/en-us/kb/218153

    A Microsoft Communities feed describing this lack of support for https links on Office 2011 can be found here:
    http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/excel-2011-hyperlinks-not-working-error-unable-to/eac46a95-8fcf-43a1-8e69-4e8dc3da9461

    Thank you,
    Kurt

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

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  9. Major Data Entry Issue

    If a cell contains the number zero, and I enter another number in that cell, the zero gets appended to the new number. For example, if I enter the number 5, Excel shows 50 in that cell instead of just 5.

    Although this doesn't happen all the time, I have actually had it happen to me once out of approximately every three tries.

    This is serious because people using spreadsheets automatically enter numbers into cells and always assume the that new number will replace the old. The fact that it appends the zero to the new number can cause users…

    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 →
  10. Resume for Office Applications

    Intro: For almost 5 years, since Apple released Mac OS X Lion in July 2011), Mac users enjoyed "Resume" feature that enables applications to re-open in exactly the same state as before quitting the application or restarting the system, including window positions and contents of unsaved files.

    Problem: Lack of the "Resume" feature is what makes me dread logging off and restarting Windows. Especially when I have multiple Word, Excel and PowerPoint documents open in different virtual desktops on two monitors - having to re-create this setup after the restart is really annoying.

    Suggestion: I suggest Microsoft implements this functionality…

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  11. Pin the header row

    It would be great to have ability to pin the header row so that it would be easy to see the header while scrolling down.

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

    We’ll send you updates on this idea

    3 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  12. Highlight rows headers of that rows that are filtered

    It is hard to know if there are some columns with the filter activated, because the row header does not shows the numbers in blue, like the office for Windows

    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 →
  13. Full implementation of the Application.MacroOptions

    The "Application.MacroOptions" as described but the Microsoft documentation https://msdn.microsoft.com/en-us/library/office/ff838997.aspx does not appear to be fully implemented for Excel 2016 MAC. The argument "ArgumentDescription" that is described in the Excel VBA reference causes a compile error to be raised. How about full implementation of the Application.MacroOptions.

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

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  14. Open Dialogue

    The open dialogue starts by displaying location options - One Drive, SharePoint and OnMy Mac.

    Two issues - yes they are minor but I find them really annoying:

    1. For corporate security reasons, I store virtually nothing online - it is all on my Mac. This extra step is very annoying and adds an extra click to every open document I do. Please add a way to always go directly to the On My Mac dialogue for those who so choose. We can always then click on the Online Locations button if we really want to go to one of…

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

    We’ll send you updates on this idea

    0 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  15. Saving an Excel attachment from Outlook on MAC should retain the file name (as is done with Word, and PowerPoint attachments)

    An Excel file that is opened as an attachment to in Outlook (MAC) should be retain its file name when saved (recognizing that the file could be saved with right click before opening) - i.e., process should be the same as Word and PowerPoint attachments

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  16. Number of Decimal Points

    The default way Excel displays numbers after the decimal point needs an update. Right now, here are the results of Excel default formatting settings. (the values in brackets are in different cells)

    A1 = [1.234]
    A2 = [1.234]
    A3 = [A1*A2] displays [1.522756]
    2X increase in values displayed post decimal!
    4 sig figs become 7 sig figs

    A1 = [2]
    A2 = [Log(A1)] displays 0.30103
    5X increase in values displayed post decimal!
    1 sig figs become 7 sig figs

    Excel is clearly just displaying all the digits it calculates. This is not the proper way to account for significant figures,…

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

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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 →
  18. Unable to insert pdf files as an objects

    Enabling insert pdf file as an object. Currently only word can be added as an object...

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

    We’ll send you updates on this idea

    3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  19. Since downloading 2016 I get this alert everytime I do anything: Cannot use object linking or embedding. How do you stop that???

    Since downloading 2016 I get this alert everytime I do anything: Cannot use object linking or embedding. How do you stop that???

    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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  20. Using applescript, the character does not delete or change it[MAC]

    I need to delete or change the particular cell contents (more than 255 characters). But, I can't. Because, the cell having more than 255 characters.
    Please help me anyone!.

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

Feedback and Knowledge Base