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. Add scrolling arrows at bottom to allow easy viewing

    Some arrows on the scroll bars would be nice to navigate individual cells without using the mouse scroll or shift+mouse scroll to view Excel sheets.

    Becomes rather tedious working on large sheets and is quite clunky.

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

    We’ll send you updates on this idea

    0 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  2. Reinstate ability to temporarily evaluate part of a formula in the formula bar

    In all previous versions of Excel for Mac, it was possible, while building a complex formula in the formula bar, to temporarily evaluate part of the formula by highlighting it and then using Cmd-= (Command & <equal sign>). To return the highlighted expression to what it was before evaluating, you then used Cmd-. (Command & <period>).

    In Mac Excel 2016, the first part of this works fine, but the second part doesn't work at all - you are stuck with the evaluation, and there is no way to return to the expression that gave rise to it. In other words,…

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

    We’ll send you updates on this idea

    1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  3. Saving file after crash and no internet connection

    After Excel for Mac crashes while the computer is not on an internet connection, it fails to verify that the software is authenticated and thus disables the 'save' function. This has been very problematic especially in areas without internet connection/ during exams!

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

    We’ll send you updates on this idea

    0 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  4. Toggle / Switch option under filtering

    If we have large number of data in table and we want to see data belongs to few filters and then rest of the data. Say I have data for 100 cities and wanted to see data of 30 cities first and then rest of 70 cities. In first filter action I can select 30 cities and can look for its data and for rest I can just use toggle option to select rest 70 and unselect earlier selection of 30.

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add feature to list all functions and include all functions offered on PCs

    Add feature to list all functions and include all functions offered on PCs

    5 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 →
  6. Fix PageUp/Down Left/Right key functions that were broken by 15.16.0 Update

    If you are in the middle of a large spreadsheet, these keys apparently move the cursor off screen, but the display does NOT move. They seem to work OK if you start from the R1C1 cell, but not otherwise. It all worked fine before the 15.16.0 update on 11/10/15.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add real subdivisions for logarithmic plots!

    In college I've had so many lab assignments where we were required to submit a semilog or log-log plot that only spanned one or two decades, but still needed subdivision gridlines (e.g. gridlines at {10, 20, 30, 40, etc.}, not just at {10, 100}). I end up finding an image of graph paper with the subdivisions I need and just dragging that underneath the plot and moving and resizing it to match the plot. I don't have to explain how much a pain that is. It would be so much better if Excel could add these subdivision gridlines automatically!

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  8. Checkboxes double print when printing or save to pdf making them unreadable

    When adding checkboxes to a sheet, then trying to print that sheet, print to PDF or Save as PDF, the checkboxes appear "double printed" making it very difficult to tell their checked state on the printed version. This bug has existed since the early betas.

    3 votes
    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 →
  9. Make AutoComplete work without crashing the application

    With AutoComplete switched on in preferences and some reasonably complex spreadsheets (names, table structured references &c.) typing into the formula bar will pretty reliably crash Mac Excel.

    It's extremely frustrating and makes working on more complex spreadsheets basically impossible. Please fix this!

    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 →
  10. Add webdav support

    Hi,

    I recently discovered that saving files to a webdav volume with Word, Excel or PowerPoint 2016 wouldn't work. I thought it was a bug and I opened a case at the support who explained to me that saving files to webdav volumes was not supported in Office for Mac 2016.

    I think it would be a great feature to re-introduce webdav support in Office 2016 as it is a very good way to access your files from a network drive that works anyware, while keeping your content hosted corporately.

    Best regards

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

    is not allowed in the 2016 Excel for Mac and I'm not sure what happened. Whenever I open an Excel file on my laptop, it always defaults to "15 (read-only) and gets really annoying when I have to open the file, save as "15" or "Copy of 15" just to save it, delete my old file and rename the new file. I can't even save properly named files as a name other than the names listed above. I've strongly considered making the switch to Apple Numbers instead of constantly dealing with how annoying this process has become. Please fix.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  12. [num, txt, raw] = XLSREAD(filename.xlsx); should return equally-sized variables

    NUM is a numerical array containing the numeric values from the spreadsheet. Super useful! Because it's numeric, non-numeric values need to be dealt with somehow, so they're converted to NaN. Also great! I can work with that!

    Here's the problem: any non-numeric values on the exterior of the spreadsheet (or, equivalently, of RAW) are omitted instead of being converted to NaN. THIS RUINS EVERYTHING. Indexing become messy, messy guesswork, because NUM is a different size than TXT and RAW. Please just have the function return NaNs, so that NUM can be the same size as TXT and RAW.

    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 →
  13. Sort Out Scroll Bars

    Sort Out Scroll Bars. Version 15.14 sorted the "respect OSX scroll bar visibility setting", but they are still not initialising/positioning correctly. When visible all the time, often when you grab the vertical slider with the mouse, the worksheet will jump miles (and by that I mean a really really long way) from the current scroll position.

    One aspect of the bug has been fixed, but there are still major problems.

    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 →
  14. copy a table from Excel and paste it a Mail message keeping all original formats

    with 2011 version I am obliged to copy a table from Excel and paste it to Word, then copy from Word to Mail, in order to keep all original formats. Very slow and frustrating procedure. I hope the 2016 Excel version allows direct copy/paste of a table from Excel to a Mail message with all its original formats.

    15 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 →
  15. Keep graph format the same when scrolling to other data

    When I scroll down to a next set of data to produce line graphs for several items, the format of lines and markers changes, which I do not want (the idea is to produce multiple graphs with identical formats). I can overcome this by copying the graph- paste special-format (onto this graph) before I start scrolling, but I have to do this again each time I re-open the excel file. Very annoying.

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

    We’ll send you updates on this idea

    3 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  16. Allow two open spreadsheets to share a search term

    In my previous version of Excel (Excel for Mac 2011), if I had two different spreadsheets open at the same time, and typed something in the search box for one spreadsheet, when I finished that search, all I had to do was click anywhere in the second spreadsheet and my search string would magically appear in the search box in the second spreadsheet! I loved that & it saved me time. I didn't purposely set it up that way & don't know if it was a built-in feature or not.

    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 →
  17. Make opening files from disk as fluid as opening from OneDrive

    Opening from disk takes longer than opening from OneDrive

    That's a really cheesy move to increase OneDrive usage, please stop it

    5 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 →
  18. Signature line needed in Excel 2016 for MAC

    I have several customers that would like to see the Signature line functionality that is available in the Windows version, also become available in the MAC version. This is needed for a variety of reasons, but the number 1 reason I hear, is so they can have employees 'sign off' on their timesheets, without having to print them or export to PDF. They have also called it 'Inking', where you can sign off with your fingertip.

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

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Paste a PDF-File in an Excel-Sheet

    Paste a PDF-File in an Excel-Sheet with menu Paste/Text/Object like Office for Windows.

    3 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 →
  20. Regression Data Must Be In Columns

    Regression models generated from data in rows are incorrect. Additional independent variables are added with zeros for there parameters. The last two independent variables are populated incorrectly. To get a correct regression model solution I must arrange the data in columns.

    Same thing happens with Excel 2015 for Windows. Data must be in columns. This was not the case with the previous release of Excel 2013.

    It is a real pain to have copy and transpose the data into columns to get the correct regression model.

    What will it take to get this fixed?

    Donald Barar

    5 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