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. Autosum Keyboard Shortcut Bug

    Can you please fix the autosum keyboard shortcut to behave like that of Excel 2011. It seems like the behavior is broken in Excel 2016. it sum a row at the bottom of a column way to fast and doesn't let you see the selection and press enter to except it. Also, when summing from the side it does a fast 1 cell sum but you need to hold down the key combination to get the selection cursor in order to make a larger column selection. Please fix. Thank you.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. Excel 2016 for Mac - external links do not hold the current values, but put 0

    The issues are confirmed for versions 15.26 and 15.27, and did not happen for version 15.24; there is an Excel file which has an external link to another Excel file which is on a computer which is on the network but not be shared; when we open the file in Windows Excel 2013, the values associated with the link are held in the cells; however, opening the file in Mac Excel 2016, those cells get zero (0) and another cells which are calculated based on the linked values go to wrong values. This is very critical as the file is…

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Save function/formula string used regularly to recall easily

    I think it would be very useful to be able to save a formula that you use regularly to recall. For instance, I have a formula I use to change the last character instance in a cell and it would be nice to be able to recall it by typing something like "=changelastcharacterinstance"

    =SUBSTITUTE(A1,”find”,”replace”,LEN(A1)-LEN(SUBSTITUTE(A1,”find”,””)))

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add Contextual Menu to insert Function

    When right clicking on a cell provide a contextual menu option to insert a function.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Use return key to change cells and retain copied information

    Why doesn't using the return key in 2016 Mac to change cells retain a copied formula to paste? Now we are forced to use navigation arrows (or clicking - both much slower) as the only way to navigate to paste. I miss this function from earlier versions

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Simplify formula entry / autocomplete

    If you enter a formular in a cell (e.g., "=Sum...") the autocomplete function pops up and presents you possible functions. You can select one of the functions by pressing the up- and down-keys. However, the most intuitive and consistent way to choose the highlighted function by pressing the enter key does not work as expected. If you press the Enter key, Excel stores what you have typed so far in that cell instead of selecting the function and move on to filling out the arguments.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. View (All) option (like Word) to see all white-space characters, training spaces, new-lines, etc.

    Given how single trailing spaces can disrupt smooth functioning of functions, especially like VLOOKUP, it would be wonderful to have an option to display spaces, new-lines (and indeed anything else that can contribute to "hidden" white-space) just like we have been able to see in Word as an option for, ooh, about a century (or at least since the beginning of time).
    At the same time, and in the same mode, a distinctive background shading or similar of numbers-stored-as-text — another huge time waster and caltrop for the novice, and even not-so-novice users.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Automatic detection of matrix formula results

    Add automatic range selection for matrix formula results, as works in Open/LibreOffice and Google Apps for many years - no more F2,CTRL-Shift-Enter...

    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. 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 →
  11. Enable batch convert cell refs in formulas from relative to absolute in one go.

    Sometimes we need to convert a relative reference in a cell (e.g. A1) to absolute values (e.g. $A$1) or the contrary. This is a painstaking process, requiring to click in the cell, locate the references, and adding/removing the $ as required. It is tedious and has to be done cell by cell, and within a cell ref by ref. Like the middle ages! It would be useful and great to enable to select the cell (and even a group of cells) and toggle ALL REFS at once to absolute and relative.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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 →
1 2 4 Next →
  • Don't see your idea?

Feedback and Knowledge Base