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. 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 →
  2. 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.

    16 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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.

    7 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 →
  10. 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 →
  11. 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 →
  12. 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,…

    11 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 →
  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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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 →
  15. 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 →
  16. 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 →
  17. Add a LOOKUP function for conditionally formatted cells

    A simple LOOKUP function that allows, not unlike the auto sum for a range of cells to be analysed subject to their conditioned formatting. I've a number of dates that relate to project KPI's which appear in a single row. The cell colours are condition formatted so that overdue goes red, 1 month to overdue goes Amber and not overdue are green. Using a "GETCOLOUR" that is interactive with the COUNTIF, IF, SUMIF, AND, OR, VLOOKUP AND HLOOKUP functions in Excel 2016 could be of equal value to Windows and OSX users alike? Quick win which would make analysis much…

    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 →
  18. Return features from Office 2010

    When copy and pasting, in Office 2010 you get a veriety of options when you right click, but in Excel 2016, it does not, you have to click on Paste Special and then choose from only 2 options! - Thos feature in excel 2010 is brilliant and gives so many useful options for paste special.
    In excel 2010, you can create your own personalised menu with shortcuts to the icons that you use most often... This I can not find how to do in 2016. It makes working in Excel so much easier and quicker.
    Unfortunately, I can not see…

    14 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  19. .docx file format

    When I open excel for mac, I get message: Book tasks to be completed.docx file format is not valid.I do not know where it comes from and I cannot stop message from appearing at startup.

    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 →
  20. Post a list of the improvements and fixes currently under development

    It would be helpful to your customers to be able to see what issues are being worked on and what issues are slated for future fix/implementation. That should include a current estimate of delivery time.

    I sense a lot of frustration on these pages. Having this method of providing you with our feedback helps, but only if you provide meaningful responses about what you plan to address. Black holes do not engender customer loyalty or appreciation.

    You are doing a much better job of providing feedback than your counterpart on the Word team. That is very appreciated. A list would…

    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  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base