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. Cursor Box Formatting

    Hi I have been using excel recently to create spreadsheets for work.
    I have noticed that I keep trying to locate the cursor box and have been looking for a function that allows me to make it more obvious but haven't managed to find anything.
    It would be a huge help if I could:
    Change the colour of the box by filling in the box with a different colour
    or
    Changing the colour of the border of the box - also if the border could be made thicker.
    Thanks for reading my suggestion. Would make a huge difference if this…

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  2. PLEASE change back the Save As function so I can choose PDF without going to Preferences!

    PLEASE change back the Save As function so I can choose PDF without going to Preferences!

    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 →
  3. Please Add Quick Analysis for Formatting

    Quick Analysis is available on Windows Excel 2016, but not Mac 2016 - please add.

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

    We’ll send you updates on this idea

    37 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  4. Formatting comments

    I want to be able change the color of the comment box and its border line, and change the color of the connecting arrow that connects the comment to the cell.

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

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  5. touch

    Please, add a function of customising Touch Bar! There are only default functions on it with no opportunity of customising! It is horrible!

    6 votes
    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 →
  6. Check/Uncheck Filter Items Shortcut

    There is no shortcut to check/uncheck filter items in the dropdown for Mac.

    Space bar or return do not work.

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

    We’ll send you updates on this idea

    11 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  7. Superscript a number in a cell

    Need to be able to add a superscript to a number in a cell and have it recognize the superscript as not part of the number in the cell when the cell entry is saved. Now it changes the superscript back to the regular number. Should work like when the superscript is added to an alpha character in a cell.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. I would like the ability to have thinner lines when formatting cell borders

    I am using Microsoft Excel to create some Accounting Sheets instead of using the PDF's I was given. A lot of cells I will need to format with borders and as it currently stands the border options in Microsoft Excel for Mac is limited to 3 solid lines and if I am correct the thinnest line is 1 Point.

    However, in Microsoft Word when creating Tables I am given the option of 1/4, 1/2, 3/4, 1 and all the way up to 6 Point. Being able to have these options would allow my spreadsheet to more closely resemble the PDF…

    6 votes
    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 →
  9. Conditional format date-range option

    The conditional format date options are too limited. When working with historical data - even last year's tax! - you may want to highlight dates that fall outside that tax year, for example. There is no simple way to set that range of dates.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  10. Date format addition

    Please add the date format option to have the date read as 01/01/2018.

    This option is not available in Mac version 14.5.7

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  11. Conditional formatting - Apply to named ranges

    Currently if you apply conditional formatting to a named range (i.e. a range named via the Name Manager or a table style named-range), the value in the "Applies to" column of the Conditional Formatting Rules Manager will immediately revert the named range to its absolute cell reference.

    eg. "Applies to: =Table1[Column3]" becomes "Applies to: =$C$2:$C$7".

    Apart from being more difficult to read, it creates other complexities. For example, if I insert a new column into this range, it creates a mess in the rules manager, creating a new rule for each cell pasted.

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

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. restore option for column width dialogue box to display in inches as in Excel 15.31 and earlier

    PLEASE restore option for column width dialogue box to display in inches as in Excel 15.31 and earlier

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. Make Cmd+Y repeat the previous action

    all of a sudden, command-Y no longer functions as "repeat last action" --- please fix this!

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. Match Destination Format

    In Preferences, allow for Match Destination Formatting as a default. Currently you can only do this by manually going to the Home>Paste area.

    20 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 →
  15. Fix problem with relative reference formulas in conditional formatting

    At present, if I want to compare 2 values in a row, I can easily use the conditional formatting feature to choose from which value is the highest, and change the colour of the cell for example.

    The problem occurs when I want to apply that to each row.

    At present, if I select the cells and use format painter, I can apply it to the 2 cells in the row below, and the conditional formatting formula is applied perfectly (relative to the 2 new cells).

    However, if I want to apply that all rows relatively, select the cells with…

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. Be able to bring hair line in excel for Mac

    Be able to bring hair line in excel for Mac

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. Decimals with external numeric pad

    When using an external numerical pad with a Mac, the dot for decimals is automatically changed into a comma, hence the figures are not recognized as numbers but as text (even though the Mac and Excel settings for decimals are set to dots).

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  18. AutoFit Row Height for Merged Cells

    Long time ask by many...create a button or functionality to AutoFit the row height for merged cells for those that use Excel to create forms, summary reports (based on drop-downs and IF statement). There are all sorts of ways to do this with Macros, some hard, and some easy, but it's so basic and needs to finally exist as an option.

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

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  19. Cannot change number of decimal places

    I have attempted to assign 4 decimal places to all values in a large table of values. Using the usual method of highlighting the whole array of cells and using FORMAT-CELLS-NUMBER-decimal places 4 does changes most of the values to 4 decimal places but a few columns show 0, 1, 2, 3 or other number of decimals. Using the Increase or Decrease Decimal button on the Home ribbon does nothing, although the increase/decrease decimal buttons work fine on the columns of numbers successfully set to 4 decimal places. Yet another glitch in this worst-ever version of Excel.

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

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. change comment line

    Permit changing comment line color (the little line connecting the comment to the cell) so it can be black. It's ALWAYS yellow now and no one can see it.

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

Feedback and Knowledge Base